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... ......

Posted On Monday, September 25, 2006 10:53 PM | Comments (2)

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 ......

Posted On Tuesday, September 5, 2006 8:28 PM | Comments (6)