September 2006 Entries



SSAS: New white paper on Many-to-Many relationships

Marco over at sqlbi.eu has just announced that he has released a great new white paper on some of the many possible uses for Many to Many relationships within SSAS cubes. Marco has put a great deal of effort into this paper and it is well worth reading. The paper (plus demo code) is downloadable from SQLBI.EU starting from this page: http://www.sqlbi.eu/manytom... ......

SSAS: Named Queries or Database Views?

I was recently asked about the issue of whether it is better to use views in the database or named queries in the data source view (dsv). I don't think there is any one correct answer. I think it comes down to the following 2 issues: Consistency: If you already have logic in database views, I would continue to use them. As long as you know that you go to one spot to view/change the logic. Putting the logic in 2 different spots could lead to confusion. Security Permissions: often you may not have ......

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online
Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: