Hi all;
I'm just starting to work with modelling, and I've built a DMR model design to analyze orders for our customers. Our product dimension has 3 hierarchies. When I create a quick report in Report Studio, the order totals work OK until I drill down to Level 3. At that point, the order totals are identical across all customers for the same product SKU and correspond to the total amount ordered for that SKU across all customers. This doesn't happen if I'm sitting at Levels 1 or 2 (the totals are correct, showing only the total ordered for that customer).
If I look at the sql sent to the Sql Server (via profiler), it's returning correct results. If I apply a design filter against the model and test the dimension view, it also looks like things are being returned OK.
I know it's tough to debug that kind of issue in the abstract without actually seeing the model, but does anybody have any hints as to where I can look? All of the dimensions relate to a single fact table, and they all relate at the same level (no determinants).
Thanks for any advice,
Jason
Check how the scope is set for the combination of measure and regular dimension. Use the view 'dimension map' and check the scope setting for the combination. I suspect the scope is not set for the lowest level of the regular dimension..
Thanks for the hint! I took a look and the scope is set for all measures at all levels in the hierarchy (as it should be).....