1 Reply Latest reply: Feb 12, 2014 11:07 AM by Raj2188 RSS

Wrong percentage in BIP Report

Alex1 Newbie
Currently Being Moderated

I have created an analysis in obiee (answers)

This analysis has one dimension of two elements (Public and Private) and 3 measures (actual, previous, %)


Then I have create a report on Publisher based in obiee answers analysis.

My report lookslike:





TOTAL---300-----------125-------140%     <--- Correct value is 140% but when I show TOTAL on PUBLISHER I see sum of values (100+166=266%)

How can I fix this?



  • 1. Re: Wrong percentage in BIP Report
    Raj2188 Explorer
    Currently Being Moderated

    Hi Alex,


    Dont use supplied values, instead create a column in the report that calculates the %age and total for individual line.





    TOTAL---(Total for actual)-----------(total for prev)-------(Total for prev/Total for actual)


    hope this helps.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points