This issue normally comes when there is a problem in relationship between Dimension and Measure group. Go to the Dimension usage in the cube solution and check the relationship type & how it is implemented there.
Related Posts
SSAS – Performance issue with Date Dimension
When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we…
SSAS Dimension Performance Report
Objective The objective of this report is monitor progressing time of all the dimensions as well as data retrieval time duration…
SSAS 2012 – Multi-Dimensional Handout
Topics Dimensional Modeling Building a Cube Dimension Usage Namedset Calculated Member KPI Drill Through Partition Design Aggregation Perspective Translation Browsing…