This content has been marked as final. Show 2 replies
Check out your data modelling once again, i mean check if you hav done your modellign correct. The aggregation level should be setup correctly.BI server understands what ever you give in your modelling.
When the query is sent to the detailed source, here are some causes (Not all though ;))
1. Query Grain : If the query grain is much lower than the aggreated source grain.
2. Calculations : Are there any calculations in the query/logical column that might need a detailed source.
3. Setup : The content settings on the aggregated source might be incorrect. You might start by setting, all the levels to Total and keep decrementing the levels of each dimension and see where it fails.
Hope this helps.