This content has been marked as final. Show 2 replies
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.