Basicly total reflets your condition. If you have column calculated direct on database total created on analisys just sum that.
When you set aggregation like MAX, OBIEE only returns MAX line, in other words, your last line.
You can create a MTD column using Times Series Functions (See ToDate Function) and your total will be expected
Mark right if help you.
Use the LAST() function to return the correct MTD for your total.
NOTE: To limit the FIRST/LAST function, you must define dimension-specific aggregation rules in the repository.
Thanks for the response. I have created the MTD column using the time series function TODate and the measure is lets say which
has the aggregation value as SUM defined in the RPD.
But the problem when I apply Grand total in the presentation layer, it sums up all the rows and give the Grand Total. Instead I want the last Row displayed as Grand Total. If we apply aggregation Last in the RPD, first of all the Rolling sum functionality will be lost in the MTD and we will not be able to use ToDate function on the measure.
let me know if we have any other approach.
1 person found this helpful
Is your table column marked to use report aggregation? Use Last ...
First MTD column uses Aggregation Rule (Last) ... second is using default
Ignore: To limit the FIRST/LAST function, you must define dimension-specific aggregation rules in the repository.
Apologies for that ...
Thanks for the response I have tried that and working as expected. But this is a manual setting which the power users have to do everytime if they want the Grand total on MTD Columns. Is there a way of customization anything which OBIEE will automatically do it.
I don't know of any automatic way... other than modifying your DW design to match the requirement (the use of information drives DW design, not the other way around)