Home > Default > Mimic "show data as percent of row parent" in non-pivot table

Mimic "show data as percent of row parent" in non-pivot table

October 11Hits:7
Advertisement
Is it possible to implement or mimic the 'percentage of parent row' functionality, foreseen for pivot tables in obiee 11g, for a 'normal' table?
We use a rather fixed table, in which no drilling is allowed - conditions are applied by means of prompts and filters. The report is based upon the store dimension, which has as hierarchy: country > cluster > store. We have added a column to represent the 'share' of a store's net turnover in the cluster total. The results looks like:
country  cluster  store  turnover   share
=======  =======  =====  ========   =====
belgium  1        a        20.000   66.7%
                  b        10.000   33.3%
         cluster total:    30.000  100.0%
         2        c        40.000   57.1%
                  d        30.000   42.9%
         cluster total:    70.000  100.0%
country total:            100.000  100.0%
holland  3        e        50.000   71.4%
         4        f        20.000   28.6%
         cluster total:    70.000  100.0%
country total:             70.000  100.0%
grand total:              170.000  100.0%Instead of all the total levels showing as 100% however, we would like to see each sub-total represented as a percentage of the level above, much like the forementioned pivot table functionality. For the example above that would mean it should look like:
country  cluster  store  turnover   share
=======  =======  =====  ========   =====
belgium  1        a        20.000   66.7%
                  b        10.000   33.3%
         cluster total:    30.000   30.0%
         2        c        40.000   57.1%
                  d        30.000   42.9%
         cluster total:    70.000   70.0%
country total:            100.000   58.8%
holland  3        e        50.000   71.4%
         4        f        20.000   28.6%
         cluster total:    70.000  100.0%
country total:             70.000   41.2%
grand total:              170.000  100.0%Any advice or idea would be greatly appreciated...

Answers

902360 wrote:
Hello,
I'd like to know if there's a way to configure the Pivot Table "Show Data As - Percent of" precision.
ATM, I have some reports using SR types where one of those are much bigger than the others.. So when the report its generated, it returns something like:
TYPE A: 99%
TYPE B: 0%
TYPE C: 0%
TYPE D: 0%
How can I show the other types correct value? Something like number of decimal places...
Ps: As criteria to this report, I have changed my Data Format to "Number", "Minus: -123" with 15 Decimal Places.
Thanks,
RamonYup. Can do. Read this link:
http://shivabizint.wordpress.com/2008/09/14/changing-the-precession-of-percent-of-columns-in-pivot-table-of-obiee/

Read other 3 answers

Tags:

Related Articles

  • Mimic "show data as percent of row parent" in non-pivot tableOctober 11

    Is it possible to implement or mimic the 'percentage of parent row' functionality, foreseen for pivot tables in obiee 11g, for a 'normal' table? We use a rather fixed table, in which no drilling is allowed - conditions are applied by means of prompts

  • Copy a certain row of data into the next row in a same internal table ??October 11

    HI, guys. May i know how to copy a certain row of data into the next row in a same internal table ?? Bcz I plan to update a certain colum of data in the row just now into another value.. For example:- *at first... ebeln1   ebelp1   xblnr1 ebeln2   eb

  • Sub Total value is empty in  parent child hierarchy pivot tableOctober 11

    Hi All, I am using obiee 11.1.1.6.2 in Test environment. Is it a known issue/bug for 11.1.1.6.2 to show empty/blank values for sub total when using parent child hierarchy pivot table. The sub total for parent value is showing but sub total for child

  • Include Row/Column Headers in Pivot Table Export to ExcelNovember 30

    I am using JDeveloper version 11.1.2.3 I am trying to export my pivot table to excel using dvt:exportPivotTableData. I'd like to include column/row headers in the export, but can't seem to find a way to do that. Is there a way to do this in my jdevel

  • Inserting static text in between rows returned from a pivot tableOctober 11

    Is there a way to type static text (eg. "Note that the data for Land has an accuracy of 98%") in between rows returned from the dataset in the rtf template. The alternative would be to break the BI analysis report (which is the source of the tem

  • Rows To Columns Or Pivot Table with SQL Model over two tablesNovember 30

    hi @all oracle 10.2.0.4 i have following situation table_1 t1_id   t1_name 1      reggie table_2 t2_id   t2_t1_id   t2_start_date   t2_end_date 1      1      01.01.2008      31.03.2008 2      1      01.06.2008      31.07.2008 cardinality from table_1

  • Chart in pivot table not shows computed dataNovember 30

    [related thread|http://forums.oracle.com/forums/thread.jspa?threadID=945178] !http://img194.imageshack.us/img194/4729/asuifuadsfuiasduifuasdf.jpg! in the example above, "market" is put on the "rows" "brand" is put on the &quo

  • Summarize total for Row items in pivot tableNovember 30

    Hi, I have a certain number of row items and few fact columns. 2 of the row items are level based measures that will summarize on other conditions so I cannot have them in the Fact section. But for these 2 row items (in the Rows section) I want them

  • Top 10 rows in a pivot tableNovember 30

    Hello, I have an requirement to retrieve top 10 rows from the output pivot table. Data on pivot table is structured as follows Rows                                                                                  Measures "Name" "Grade"

  • Sorting Totals After on rows in a Pivot tableNovember 30

    Hi, I need to Sorting Totals After on rows in a Pivot table . Can anyone help? ThanksTry this: 1) Duplicate your measure column in Criteria. 2) In the fx window, enter RANK(your_measure_column). 3) Place this column in the Rows section of your pivot

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 15 q. 1.591 s.