Pivot Table Dynamic Sorting in OBIEE/ Siebel Analytics

This article will guide you in implementing the dynamic sort feature in pivot table in OBIEE

We can sort columns dynamically in table view in OBIEE. However when it comes to pivot table we feel helpless in getting the same feature.

But cheer now…we can exploit the functionality of table view sorting for pivot table view.

Lets C how.

Logic: Use Table view column as a button for Pivot Table sorting.

Step By Step Guide for Pivot Table Sorting:

1. Create a Pivot Table view which is to be used for dynamic sorting. Identify the columns to be used for dynamic sorting

(For eg. Cust Name)

070209_0621_PivotTableD1.png

2. Create a new Table view

070209_0621_PivotTableD2.png

3. Go to Table view properties and make the following changes, so that we can enable dynamic sorting in table view.

070209_0621_PivotTableD3.png

4. Hide the Table view rows value by changing their front and background color to white and set border to none

070209_0621_PivotTableD4.png

5. Hide the excess columns (For eg. Brand & Billed Qty), which are not required for sorting.

070209_0621_PivotTableD5.png

6. Table View Column Heading will appear as a button.

070409_0512_test1.png

 

7. Pivot table view will be affected due to the above changes in Table view.

070209_0621_PivotTableD7.png

8. Manually format the column and value and border properties

070409_0512_test2.png

9. The final layout will be something similar to the below image, where table view column will act as a Button for sorting in pivot table

070409_0512_test3.png

10. Sorting in action

070409_0512_test4.png

Advertisements
Posted in OBIEE. 5 Comments »

5 Responses to “Pivot Table Dynamic Sorting in OBIEE/ Siebel Analytics”

  1. hanny Says:

    Nicely written article

  2. suthee Says:

    Thanks guys, good info.

  3. santhi Says:

    Hi
    can we move a column from rows section to page items in pivot table at run time? If yes How?

    I heard it can be done.

    thanks.

  4. santhi Says:

    Hi,
    In discoverer we can move a column from rows section to page items sectio in a crosstab layout at runtime. In OBI, can we do it?


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s


%d bloggers like this: