This content has been marked as final. Show 5 replies
When using pivot table, you should also make use of a fact value.
If that's the case it should work to drill on both dimensions...a good example from the demo's is for example $dollars per quarter for each region. (You'll have to possibility to drill on quarter as well as on region)
Hope it helps you out.
Yes i do,I didn't write it before but in my pivot table there are the 2 dimension on columns and rows and the aggregate measure from the fact table...
That should work...
You have set the correct levels on your fact table source in the BMM?
Yes I'm pretty sure about it because if I view the same dimensions in a "Table" (not a pivot one) I can drill down following BI hierarchies:
Region -> City -> store
Customer -> Order
Did you get how do that? I have the same problem. We would like to drill down in a pivot by the headers.
Thanks in advanced.