Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Dynamic Pivot column in BI Publisher — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic Pivot column in BI Publisher

Received Response
25
Views
1
Comments
edited Jul 3, 2020 9:42AM in Reporting and Analytics for ERP 1 comment

Summary

Need the column of a pivot table to be dynamic in BI Publisher

Content

We have a requirement to display GL balances by BU hierachy and period.

As the users can run the reports for multiple periods and the period balance has to be in columns, we have used pivot(Jan-20, Feb-20 format below. Data model would only give them in rows.).

The next requirement is to display BU hierarchy which is fine. But they want to have it dynamic. When they choose only display level 2,4,9 then the pivot should be of following format.

BU level2 Level4 Level9 BU

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!