This discussion is archived
8 Replies Latest reply: Dec 16, 2012 5:35 AM by fiaz0419 RSS

Percentage Issue

User472204-OC Newbie
Currently Being Moderated
Hi Experts,

In OBIEE 11.1.1.6.0, when I click 'Column Property'-->'Data Format',enable 'Override Default Data Format',then select 'Percentage' format from list, the result will be only added '%' symbol,not mutiply 100 automatically. Why? Is it the product problem? Is it possible to change the configuration?
Since it is inconvenient for customers to create query.
  • 1. Re: Percentage Issue
    Srini VEERAVALLI Guru
    Currently Being Moderated
    I've seen the same behavior in all versions and I was assuming its about Data format, and all % calculations are done in rpd using formula and I never used it for % calculations..

    For run time % as you expecting can get using Pivot table right?

    If helps pls mark

    Edited by: Srini VEERAVALLI on Dec 13, 2012 5:57 AM
  • 2. Re: Percentage Issue
    User472204-OC Newbie
    Currently Being Moderated
    Hi ,

    You mean I should mutiply 100 in RPD, then use the data format in answer, right?
    However, sometimes customers should create query and create some new mesure columns .So we do not help them create these columns in RPD.
  • 3. Re: Percentage Issue
    Maqsood Hussain Journeyer
    Currently Being Moderated
    Hi,

    'Column Property'-->'Data Format' is for formatting the data. When you select Percentage in data format OBIEE assumes the data is percentage of some value. It is not a product problem.


    Thanks
  • 4. Re: Percentage Issue
    Srini VEERAVALLI Guru
    Currently Being Moderated
    In Criteria tab we can use column->fx for the same to create % measures based on available column in the subject area to create report level.

    This is the way most of the people use it for table view or else using column options at Pivot table on report side if not go for pre-built % metrics using BMM layer.

    If helps pls mark

    Edited by: Srini VEERAVALLI on Dec 13, 2012 6:35 AM
  • 5. Re: Percentage Issue
    fiaz0419 Journeyer
    Currently Being Moderated
    Hi
    As Hussain said , It is only for Formatting the data. it will display only '%'.

    You have to keep the data int Percenatage only by Multiplying 100 in column FX.......example (a/b)*100 or c=a/b is calculated it RPD then either use c=(a/b)*100 in RPD or c*100 in column fx.

    I dont find any complexity or Production problem over here ....... Its simple... thats the way all use it... you have to convince customer the way it is given to you.


    Regards,
    fiaz
  • 6. Re: Percentage Issue
    User472204-OC Newbie
    Currently Being Moderated
    Hi fiaz0419 ,
    Thanks for your reply.
    I am new OBIEE developer, I have used Cognos,SSRS before, I remeber it is very easy to implement this simple requirment.
    For example:
    I have basic column A and B,so customers can do the query for A/B, then select 'Formatting the data'. it will mutiply 100 and add '%' symbol for suffixe automatically.
    But in OBIEE ,it will display only '%'. So it is not convinent for customers to do query.
  • 7. Re: Percentage Issue
    User472204-OC Newbie
    Currently Being Moderated
    Hi Maqsood Hussain ,

    You said:
    'Column Property'-->'Data Format' is for formatting the data,When you select Percentage in data format OBIEE assumes the data is percentage of some value.

    However, it will only display '%' symbol, not mutply 100.
    I remeber other BI tools can do it simplily.
  • 8. Re: Percentage Issue
    fiaz0419 Journeyer
    Currently Being Moderated
    Good Point...

    But thats how it is.... Its not production issue...

Legend

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