BI Publisher (MOSC)

MOSC Banner

Modifying genrated pivot table structure

edited Jun 25, 2018 4:33PM in BI Publisher (MOSC) 5 commentsAnswered
Hello,
Can anyone help me to modify the generated Pivot Table template from BI Publisher Desktop ?

Lets' suppose i have a simple xml like :


<DATA>
<DETAILS>
<PERIOD>JAN-2010</PERIOD>
<ACCOUNT>4111</ACCOUNT>
<SUM>1200</SUM>
<OPEN_PER_BAL>0</OPEN_PER_BAL>
</DETAILS>
<DETAILS>
<PERIOD>JAN-2010</PERIOD>
<ACCOUNT>4112</ACCOUNT>
<SUM>100</SUM>
<OPEN_PER_BAL>0</OPEN_PER_BAL>
</DETAILS>
<DETAILS>
<PERIOD>FEB-2010</PERIOD>
<ACCOUNT>4111</ACCOUNT>
<SUM>1300</SUM>
<OPEN_PER_BAL>10</OPEN_PER_BAL>
</DETAILS>
<DETAILS>
<PERIOD>FEB-2010</PERIOD>
<ACCOUNT>4112</ACCOUNT>
<SUM>102</SUM>
<OPEN_PER_BAL>10</OPEN_PER_BAL>
</DETAILS>
</DATA>

I can generate easily a structure with period as rows, account as columns, and sum like values. But how can i display OPEN_PER_BAL for each month at the end of table ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center