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