8 Replies Latest reply: Dec 16, 2012 7:35 AM by fiaz0419 RSS

    Percentage Issue

    User472204-OC
      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
          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
            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
              Maqs-Oracle
              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
                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
                  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
                    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
                      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
                        Good Point...

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