BEx Query with Percentage Functions (%GT, %CT etc.)
If a BEx Query is using data functions, it cannot be used as a data source for BO, thus we need to remove these data functions from the query and implement it to BO WEBi report level.Below solution shows hoe the %GT function can be implemented in WEBi.
BO Solution: Calculation Context
%GT functions can easily be implemented in BO using Calculation Context.
In BO report by default the calculation context is define by the dimensions fetched on to the report.Adding or removing the dimensions from the report changes the measure amount aggregation.
However, if user wants to remove or add any dimension from the calculation context without adding or removing the dimension from the report block the this can be achieved using the calculation context.
As in below example Contribution percentage can be calculated using the formula:
=[REVENUE] / [REVENUE] In Report
The IN Report Context projects the measure up to the overall report total.By using this calculation context in the report denominator we can ensure that we will always be dividing by the grand total.
Please note we cannot achieve the above result by using =Sum[REVENUE] in denominator because Sum will be calculated in context with Resort dimension, so =Sum[REVENUE] will give $971,444.00 only when placed in adjacent column to revenue.