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

Oracle Fusion BI Publisher - Pivot table - Dynamically derive header

Summary:

Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name(Description of parent value of segment6) where the fund name has to be dynamically derived using a subquery for the BIP report. Our requirement met when we hardcoded these fund names in the pivot section (as mentioned in below example).


Eg. select * from master_data_table pivot( max(opening_balance) for fund_name in ('parent_fund_1','parent_fund_2')


However we are facing challenges in deriving these fund names dynamically using a sub query inside pivot section. So we can dynamically derive the parent_fund_names and can match with fund_name from master_data for pivoting.(as mentioned in below example)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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