Today I had a problem with a dimension which displayed the transaction numbers in duplicates were I knew there shouldn´t be any. I realised after some searching that the table which resided from the relational source didn´t only used one key but two primary keys to create a unique row. So I had to set the key column in SSAS to both these (as a surrogate key I guess) in order to get unique rows. I still haven´t looked at the result since there are other problems which are more pressing.
One is the YTD function which I explain here at Stackoverflow:
Another problem I had which resulted in sacrificing some reputation for a bounty is:
This problem maybe isn´t any problem and perhaps it´s just the only way SSRS can show drill down on columns. If I should put it on rows instead I think it would look better but then the report will be to wide. As an example I have followed the book “Delivering Business Intelligence with Microsoft SQL Server 2008” by Brian Larson and there he does somehing similar with the same “empty” space when opening the report. Maybe this has been fixed in later versions?