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)
2. Create a new Table view
3. Go to Table view properties and make the following changes, so that we can enable dynamic sorting in table view.
4. Hide the Table view rows value by changing their front and background color to white and set border to none
5. Hide the excess columns (For eg. Brand & Billed Qty), which are not required for sorting.
6. Table View Column Heading will appear as a button.
7. Pivot table view will be affected due to the above changes in Table view.
8. Manually format the column and value and border properties
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
10. Sorting in action
July 3, 2009 at 4:54 AM
Nicely written article
July 4, 2009 at 10:46 AM
Thanks guys, good info.
August 6, 2009 at 7:25 PM
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.
August 6, 2009 at 11:34 PM
Hi santhy
sorry
but i am not able understand it clearly.
could you please explain a bit?
August 21, 2009 at 1:52 PM
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?