If we have measures that have hierarchies (such as Sales Expenses + Marketing Expenses = Total Expenses), in order to have drill down, is it necessary to have them as dimension by cross tab? I could create a measure hierarchy just like dimension hierarchy but it appears not available in pie charts etc to be used as a measure?
Hi thanks for the response. As indicated, the idea is to show some visualisation (Bar for example). And the drill down should reflect details.
Let us say the bars are for each month (Jan, Feb, Mar) and show total expenses (which can be a summary measure). If user clicks on, say, May, it should show for that month, Sales Expenses, Marketing expenses etc which are measures. Right now they are columns in the datasource and loaded as is. (not cross tab to dimension).
The row or X-axis can be not necessarily month but something else as well (Say, Company or Division etc)