Sitemap

Amicuk Programming Answers

BI Publisher Pivot Table or Cross Tab

2015-10-11   Views:16

Advertisement

Hai All, I have a doubt in developing a Matrix report in XML. I have developed a matrix report in RDF and the output is coming fine in RDF. I have generated the XML file which looks like this. I need to develop the report which displays employee deta

Hai All,
I have a doubt in developing a Matrix report in XML. I have developed a matrix report in RDF and the output is coming fine in RDF. I have generated the XML file which looks like this. I need to develop the report which displays employee details followed by the allowance which are dynamic.
- <XXHRPRF>
- <LIST_G_SUMRESULT_VALUE>
- <G_SUMRESULT_VALUE>
- <LIST_G_EMPLOYEE_NUMBER>
- <G_EMPLOYEE_NUMBER>
<EMPLOYEE_NUMBER>100026</EMPLOYEE_NUMBER>
<PERSON_ID>80</PERSON_ID>
<NATIONALITY>USA</NATIONALITY>
<NATIONAL_IDENTIFIER />
<UNIFIED_ID />
<FULL_NAME>Thomas H Mathew</FULL_NAME>
<ORGANIZATION_NAME>Corporate Affairs</ORGANIZATION_NAME>
<PENSION_FUND_ID />
<CS_SNO>1</CS_SNO>
<CF_PENSION_CONTRIBUTION>3637.5</CF_PENSION_CONTRIBUTION>
<CP_PENSION_COMP_CONTR>10912.5</CP_PENSION_COMP_CONTR>
<CP_TOTAL_SALARY>72750</CP_TOTAL_SALARY>
<CF_TOTAL_CONTRIBUTION>14550</CF_TOTAL_CONTRIBUTION>
- <LIST_G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>1</TAG>
<ELEMENT_NAME>Basic Salary</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>39650</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>2</TAG>
<ELEMENT_NAME>Housing Allowance</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>25000</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>3</TAG>
<ELEMENT_NAME>Child allowance</ELEMENT_NAME>
<LIST_G_PERSON_ID />
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>4</TAG>
<ELEMENT_NAME>Social allowance</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>700</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>5</TAG>
<ELEMENT_NAME>Excess Allowance</ELEMENT_NAME>
<LIST_G_PERSON_ID />
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>6</TAG>
<ELEMENT_NAME>Additional</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>7400</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
</LIST_G_ELEMENT_NAME>
</G_EMPLOYEE_NUMBER>
- <G_EMPLOYEE_NUMBER>
<EMPLOYEE_NUMBER>100030</EMPLOYEE_NUMBER>
<PERSON_ID>82</PERSON_ID>
<NATIONALITY>Canada</NATIONALITY>
<NATIONAL_IDENTIFIER />
<UNIFIED_ID />
<FULL_NAME>Sara Wilson</FULL_NAME>
<ORGANIZATION_NAME>Human Resources</ORGANIZATION_NAME>
<PENSION_FUND_ID />
<CS_SNO>2</CS_SNO>
<CF_PENSION_CONTRIBUTION>1203.75</CF_PENSION_CONTRIBUTION>
<CP_PENSION_COMP_CONTR>3611.25</CP_PENSION_COMP_CONTR>
<CP_TOTAL_SALARY>316575</CP_TOTAL_SALARY>
<CF_TOTAL_CONTRIBUTION>4815</CF_TOTAL_CONTRIBUTION>
- <LIST_G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>1</TAG>
<ELEMENT_NAME>Basic Salary</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>19600</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>2</TAG>
<ELEMENT_NAME>Housing Allowance</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>22500</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>3</TAG>
<ELEMENT_NAME>Child allowance</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>600</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>4</TAG>
<ELEMENT_NAME>Social allowance</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>800</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>5</TAG>
<ELEMENT_NAME>Excess Allowance</ELEMENT_NAME>
<LIST_G_PERSON_ID />
</G_ELEMENT_NAME>
- <G_ELEMENT_NAME>
<TAG>6</TAG>
<ELEMENT_NAME>Additional</ELEMENT_NAME>
- <LIST_G_PERSON_ID>
- <G_PERSON_ID>
<RESULT_VALUE>3075</RESULT_VALUE>
</G_PERSON_ID>
</LIST_G_PERSON_ID>
</G_ELEMENT_NAME>
</LIST_G_ELEMENT_NAME>
</LIST_G_EMPLOYEE_NUMBER>
</G_SUMRESULT_VALUE>
</LIST_G_SUMRESULT_VALUE>
<CF_PERIOD>MAR-2009</CF_PERIOD>
- <XXHRPRF>
I need to develop a cross tab format in RTF using template builder. Can we get this in matrix report using the standard wizard given in template builder or else it should be done manual. If it can be done through wizard can u please explain the process.
And one more think what is the latest version of template builder available. In few cases its given as pivot table and in few its given as cross tab. I confused by that.
This seems to be basic doubt, but please guide me.
Regards

The replay answer
Advertisement
i,
I am developing cross tab report with group in BI Publisher(i.e matrix with group above report in report builder).
My req.is
Country1
region1 region2 region3 --- (level1 column)
d1 d2 d3 d1 d2 d3 d1 d2 d3 --(level2 column)
Row1 10 15 18 24 38 40 36 35 78 --data
Row2 -- -- -- --- --- -- - -- -- --
regions(level1 columns) and d1,d2,d3(level2 columns) are data depenent on XML data.
d1,d2 d3 may change in number based on data.Also we have page break on country.
We could able to achieve in report builder but in Bi Publisher we are unable to achieve the same.
Wizard in BI Publisher gives only one level of measure(region) only.
Currently we are using BI Publisher template builder version 10.1.3.2.1
Need help in this regard ASAP.
Thanks in advance.

Go to See the other 6 answers

BI Publisher Pivot Table or Cross Tab

Category:DefaultRelease time:2015-10-11Views:130

Hai All, I have a doubt in developing a Matrix report in XML. I have developed a matrix report in RDF and the output is coming fine in RDF. I have generated the XML file which looks like this. I need to develop the report which displays employee deta[More]

Oracle BI Publisher 10.1.3.3.2 - Grouping a cross tab in sections

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, I am trying to make a BI Publisher template containing a cross tab and the cross tab is repeated for sections.This is how the structure of tables are Costs Dim (Cost_id, Costs_Section , Costs_Type) Trans_Dim (Trans_id, Trans_Ref, Trans[More]

Adding a pivot table while creating report in BI publisher

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have been working on OBIEE and i need to create a multipage report. I have created a report in BI Dashboard using pivot table and i like to create the same pivot table (as pdf report) by using BI publisher. But i am unable to add pivot tabl[More]

XML Publisher Report Fails While using Pivot Table in R12 Oracle EBS

Category:DefaultRelease time:2015-10-11Views:130

Hello All, Need your help. I am trying to create a report with a Pivot table. I have created the .rtf file using the Oracle BI Publisher Template Builder for word 10.1.3.4.1. the data comes correctly in preview but when i register it in EBS and run t[More]

How to extend No. of columns for PIVOT table in BI Publisher Desktop

Category:DefaultRelease time:2015-10-11Views:130

Hello Everyone,   I am using the Oracle BI Publisher Desktop to design the TEMPLATE for Oracle Reports. I need to create the PIVOT table .In my PIVOT table I need to display 9 columns but when I tried to create PIVOT table by dragging 9 columns only[More]

Creating a Pivot Table in a XML publishe

Category:DefaultRelease time:2015-10-11Views:130

When creating a Pivot Table in a XML publisher in Word, is there a way for a Pivot table to respect the fact that it's inside of a group function? I'm looping over site , and within each site I want to create a Pivot Table that has Months going acros[More]

Pivot Tables in BI Publisher

Category:DefaultRelease time:2015-10-11Views:130

When including multiple Criteria in the "Rows" section of Pivot Table we get a desired format of Pivot Table in BI Analytics Answers. However, when creating a Pivot Table in a BI Publisher Template, Adding multiple measures in "Rows" r[More]

Add additional DESC column at right side of pivot table in bi publisher

Category:DefaultRelease time:2015-10-11Views:130

ARABIC DESC India UAE Total English DESC QUANT_DECIMAL VALUE_DHS QUANT_DECIMAL VALUE_DHS QUANT_DECIMAL VALUE_DHS 0 0 0 0 0 0 اجر 4 4 23 5619 27 5623 ABC اجر 0 0 10 3510 10 3510 CDF ملابس 0 0 14 772 14 772 XYX جالية 0 0 25 2020 25 2020 EJB Total 4 4 7[More]

Modify Pivot Table in BI Publisher Template

Category:DefaultRelease time:2015-10-11Views:130

Hi, I've a crosstab report requirement in BI Publisher. Suppose I've 2 row-items, 1 column-item(Month) and 3 datapoints. In BI publisher template builder->pivot table wizard I found only option is there to display datapoint columns one after another[More]

BI Publisher Template Builder for Word 10.1.3.4.1 and Creating Pivot Table

Category:DefaultRelease time:2015-10-11Views:130

I'm new to BI (XML) Publisher and Pivot Tables.  I have XDO Engine version 5.6.3 and Template builder 10.1.3.4.1.  I creates a Word 2010 RTF template containing a pivot table.  When I preview in Word, it displays.  When I execute the Concurrent Reque[More]

Disabling auto sort of rows for Pivot Tables in BI Publisher

Category:DefaultRelease time:2015-10-11Views:130

is there a way to avoid the Pivot table in BI Publisher from sorting your data and just display the rows in the order retured from the data model ? By default it is sorting the data in asc order. Thanks !hi jim if you carefully look inside the form f[More]

Hot
Anyone try the cable listed at the link below? I'm looking for a mini-->mini audio cable to connect my IP to my Aux input in my car. I bought a cable that seems to work from Radio Shack, but it doesn't go fully into my IP. At least I think it doesn't [More]
I have multiple apple id's and iCloud on my Mac somehow assumed the wrong one.  I see no option to change it to the correct one.I discovered that I can sign out of iCloud on the Mac and sign in with my correct apple ID.  However, I get a message that [More]
Dear All, During sales order user enters the price manually since condtion type is manual. And during billing the user can change the price because it is in display mode. Please suggest how to restrict price changes in billing. Regards, rameshHai, Fo [More]
  Never had a problem with plotting large format drawings before in Reader but since installing Reader X on my machine it will not plot to my HP 750C+.  I uninstalled version X and found a link to download the version I was using before v9.4.  Upon i [More]
Hi, I have brought a mac mini exactly 1 month back and while moving to a new office it was stolen. I have registered it, does anyone knows how i can trace the Mac mini. I have all the serial no and details for the Mac mini. Please, let me know. Thank [More]
Hello, I'm reading Bruce Eckel's book. In chaapter 14, I read TextArea.java. My question is: What is the purpose of getContentPane() in the constructor TextArea() in the code below ? Isn't JFrame IS a Container ? why bother to get another Container ? [More]
XI 2.0 Tomcat 4.1 JDK 1.4.2   The only way I've been able to have my java proxies find the jpf.properties file is when I put jpf.properties in the same location that I start up my WebServer from (my case, tomcat).   Is there some an xml file or perha [More]
I have just loaded Illustrator 3 and don't think i'll have too many problems creating designs but, how on earth do i print my labels to avery stock. I have tried exporting but can't figure it out - do i need to buy more software? Please help!!!!! Jen [More]
Hi All I am trying to create Reports in Hyperion Interactive Reporting Studio using Essbase Applications. I created a BQY document but I am unable to find further steps to go ahead. I gone through many documents but its not helpful. Kindly guide me t [More]
I has standrat BI7 data load process: DataSource -> IPackage -> DTP -> DSO. I've deleted 3 last requests in my custom developed DSO. They do exists in PSA. Now I want them to be restored from PSA, but unfortunately, there is no "Update with [More]