6 Replies Latest reply: Aug 7, 2009 1:57 AM by Kishore Guggilla

# how can i use the Ratio_to_report function in obiee

Hi,
I have to use ratio_to_report function to create the report.

this is the link which explains the usage of this function.This function computes the ratio of a value to the sum of a set of values.How can i achieve this in BI

Thanks,
saichand
• ###### 1. Re: how can i use the Ratio_to_report function in obiee
Hi Sai,

Take another column in criteria change it's functionality to...
``Measure/sum(Measure)``
Even though, you column (Measure) is aggregated in rpd..

Hope it works..

Edited by: Kishore Guggilla on Aug 7, 2009 11:54 AM
• ###### 2. Re: how can i use the Ratio_to_report function in obiee
Hi Sai,

One more approach is:

Use pivot and duplicate the measure in Measures block.
For Duplicated Measure, go to More Options > Show Data As > Index of > Column

Even it serves the same purpose...

Hope you got my point... :)
• ###### 3. Re: how can i use the Ratio_to_report function in obiee
hi kishore,
i did the same thing .....i added one column in rpd and made the agg as sum.But its not giving the correct results..... when i run the query in back end its giving different results which is different from my report
• ###### 4. Re: how can i use the Ratio_to_report function in obiee
Hello,

have you tried my first approach?

take column in answers, not in rpd..
In rpd, you are already having that measure with aggregation right ? (Say A)
Now, take a column in answers criteria, change it's functionality to below.

A/SUM(A)
• ###### 5. Re: how can i use the Ratio_to_report function in obiee
hi,

yes....first tried with that thing only krishore.....after that i created one more column in rpd and made the agg rule of that col as SUM.But no luck
• ###### 6. Re: how can i use the Ratio_to_report function in obiee
Make sure that the measure is not level based measure, and it's the detail level measure..