“All pages” In Pages Block of Pivot View

25 Aug

1.      Select Periods. Year, Sales Measures. Dollars  From Paint Subject Area




2.      Next Click On the Pivot view




3.      Now you will see the following screen




4.      Create one Duplicate column for Year as follows



5.      Now move the Duplicate column to “Pages” Block of the Pivot table



6.      Once you moved the Duplicate year column to Page block then you will get one drop down list to select the Year, as per the drop down list value the pivot view displays  the respected year data.




7.      As per the drop down list you can select only one option for year prompt. And there is no option to display all year data.



8.      To have all years data in addition to the existed values for prompt. Click the  option and select the “Before” value to get the “All Pages” option as first and default choice of your Prompt. If you selected “After” value then “All Pages” option will display as last choice in drop down list.




9.      Now you have the following options in your drop down list




10.  Finally the Report will be as



11.  Finally the report renders automatically and displays the correspondent data as per the Dropdown list choice















Posted by on August 25, 2008 in OBI EE


4 responses to ““All pages” In Pages Block of Pivot View

  1. Sainath Baludu

    September 4, 2008 at 10:20 am

    itz really gud

  2. Zoran Milokanović

    April 18, 2009 at 11:03 am

    Hmmm… Does anybody know how to have lets say 10 page items in pivot table (OBI EE) and that each item has something like “all values” or “all pages” or something like that….I want to know how to put in each page item something like in Oracle Discoverer. Is that possible, cause my users used to that in Discoverer and we have hundreds of reports like that??
    Is there any generic solution?
    I tried with workaround by making calculation/formula for each page item (name , formula: sum(*)) and it works fine for 2-3 page items. However for more page items it gets very slow with rendering resultset.
    Any help?


  3. Zoran Milokanović

    April 18, 2009 at 11:08 am

    Now I see that some of my text wasn’t shown….Somehow //ALL// has been deleted…
    So again, how to manage in each page item of OBIEE //ALL// values as it comes by default in Oracle Discoverer page items.
    That was all about…

  4. Sunil

    July 3, 2009 at 12:11 pm

    Hi Shiva,
    Rather than ‘All Pages’, is it possible to show ‘ALL’ only.
    I have two columns in Page section. If I choose before,it comes ‘ALL Pages’ for first column hiding the second column. After choosing value from first column second column appears with corresponding values.

    I want to display both the columns showing All as their value as default.

    With Regards,


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: