I need some help. We have a report that requires what I call 'Custom Subtotals' -- i.e. I need the subtotal values to point to a different column than the one it belongs to.
For example, in a database table I have 4 columns: [Parent Entity], [Child Entity], [Parent Limit], [Child Limit]. The [Child Entity] column rolls up to the [Parent Entity] Column. In my OBI report, I need one column called 'Limit'.. And it should display [Child Limit] at the [Child Entity] Level, but it should display [Parent Limit] at the [Parent Limit] Subtotal. In this example, the subtotal is not the sum of the child limits, it is a completely separate number in the database.
Thanks prassu -- I know about dimension metrics, but will that be able to consolidate two columns into one one column, so that level2 attributes show level2 metrics, while the SUBTOTAL shows level1 metric?