I have created a ragged hierarchy for Geography , some of the geos are having 2 levels like North America and some are having 4 levels like Middle East Africa.
My cube is having data from different sources and for some source the data is at country level and for some source the data is Region Level .
When I promote hierarchy its working totally fine .
Once I create a metric set and drag the geo hierarchy to rows and then click on the Pencil icon in the data analysis panel there is an option Default Parameter value if I click that to see all the available values I am getting an below error.
“The fact table contains data for non-leaf ragged hierarchy members, which prevents meaningful aggregations.”
So fix this, I Limited the data in my cube to only source which is at country level and then once again when I checked the cube it gave me the desired result.
Hence my question is if my data in the cube is at different levels then it will not work ? , all the data should be at same level?
As the hierarchy is having the data at all levels then it should show up .
Thanks & Regards