I've had the same issue's also and ended using MOLAP. Is there a particular reason why you are using ROLAP? From my experience, the storage cost of a...

I've always tried to build views in SQL for a filtered data set instead of using the named queries. In my opinion, views are easier to manage and maintain.

You...

If possible, I would suggest creating 2 new dimension tables.

Using the Fact table as a dimension source would mean your using a DISTINCT or GROUP BY query for the dimension...

Do you use any variables to update the data source? You might want to check if you've set the data source to update it's connection string/database information to a...

I've used the following queries and SSRS reports to extract metadata around SSAS objects.

http://www.purplefrogsystems.com/blog/2011/05/video-automating-ssas-olap-cube-documentation/

Perspectives are used to define which Measures and Dimensions are visible to help the end user connecting to the cube have a subset of them.

As far as I know, there...

Can you build a hierarchy on above the attributes that are causing this issue?

I've noticed this issue occurs when you have an extremely large dimension and the user tries to...