Home » Fusion Middleware & Colab Suite » Business Intelligence » Display Values in PIVOT TABLE (BI Publisher)
Display Values in PIVOT TABLE [message #352149] Mon, 06 October 2008 05:46 Go to next message
deepz
Messages: 2
Registered: October 2008
Junior Member
Hi All,
I want to build a cross tab report. My XML is the following
<row>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>MHO</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>700</AMOUNT>
</r>

<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>MHO</SUBLOCATION>
<GL>LIABILITY</GL>
<AMOUNT>900</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>ADH</SUBLOCATION>
<GL>LIABILITY</GL>
<AMOUNT>300</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>ADH</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>200</AMOUNT>
</r>
<r>
<LOCATION>MHO</LOCATION>
<SUBLOCATION>FLX</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>500</AMOUNT>
</r>
<r>
<LOCATION>CHN</LOCATION>
<SUBLOCATION>ADH</SUBLOCATION>
<GL>LIABILITY</GL>
<AMOUNT>200</AMOUNT>
</r>
<r>
<LOCATION>CHN</LOCATION>
<SUBLOCATION>FLX</SUBLOCATION>
<GL>ASSET</GL>
<AMOUNT>500</AMOUNT>
</r>

</row>



My RTF file is attached here , I am not getting values in the proper order since some values are null in the pivot table,
please check the attached rtf file for more details
please help me
my code is below
<?for-each-group:r;./LOCATION?><?sort:LOCATION;'ascending';data-type='text'?>
<?LOCATION?>
<?horizontal-break-table:1?>
<?for-each-group@column:current-group();GL?>
<?GL?>
<?end for-each-group?>
<?for-each-group:current-group();./SUBLOCATION?>
<?SUBLOCATION?>
<?for-each-group@cell:current-group();GL?>
<?sum(AMOUNT)?>
<?end for-each-group?>
<?end for-each-group?>
<?for-each-group@column:current-group();GL?>
<?sum(current-group()/AMOUNT)?>
<?end for-each-group?>
<?end for-each-group?>


thanks in advance
Deepz

/forum/fa/5125/0/

[Updated on: Mon, 06 October 2008 05:50]

Report message to a moderator

Re: Display Values in PIVOT TABLE [message #352230 is a reply to message #352149] Mon, 06 October 2008 13:16 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

use format '99g99g990' or at the data store stage use nvl to store zero in column
yours
dr.s.raghunathan
Re: Display Values in PIVOT TABLE [message #352265 is a reply to message #352230] Mon, 06 October 2008 22:29 Go to previous message
deepz
Messages: 2
Registered: October 2008
Junior Member
hi,
it is not necessary that all location and sublocation has a GL and amount,So NVl will not help me here..

thanks
Previous Topic: How to use OBI Answers reports in OBI Publisher
Next Topic: XML Publisher (XSL-FO question)
Goto Forum:
  


Current Time: Fri Mar 29 09:59:58 CDT 2024