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
Hello. I just created a new account and i set the location in United States. I entered a redeem code. when i sumbit, they said that i've redeemed 10$ successfully. then i tried to purchase an app, then it suddenly requeired my to sign in then i could [More]
What is the best way of putting music onto another iphone for a different itunes account user and different phone carrier? multiple user accounts on my mac? or home sharing to put the music on? then they have their own itunes account for apps etc?Hi [More]
Hi all, I am currently on contract with a network called Jersey Telecom. Having upgraded to 4.3 I have the options for personal hotspot, but when I try to activate it, it says to contact my carrier. I have been into the 1 and only Jersey Telecom shop [More]
my iPad is stuck with a small blue screen saying iCloud Backup, this iPad hasn't been backed up in 4 weeks.Backups blah blah- Click OK. I can't get it off the screen and I can't use the iPad because of it. Can anyone out there help?Have you tried res [More]
hi friends what is diff between a. BBP_ctr_init_upload  &  BBP_contract_initial_upload b. BP-preselect vendors & BBP_SUPP_Moni diff Regards SuryaHi surya, First one will use for uplaoding the contract data,... second will use for montioring the bu [More]
Hi Could anyone provide me with some example where in we can test XI Integration. I have a situation like I need to integrate a text file in C directory to any other directory. I need some help on how to build SLD and also to build integration reposi [More]
1* BEGIN DBMS_TTS.TRANSPORT_SET_CHECK(ts_list => 'TEST', incl_constraints => TRUE); END; SQL> / BEGIN DBMS_TTS.TRANSPORT_SET_CHECK(ts_list => 'TEST', incl_constraints => TRUE); END; ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at & [More]
Hello SAP Experts, I have gone through all the steps of configuring release strategy for PO. I checked at the end with the transaction code OMGSCK and everything is good with no error. But when I test the strategy by creating a PO, the 'Release Strat [More]
The question is ....from a flex based AIR application do you always have full access to all of the HTML content loaded from a remote site via the DOM (htmlLoader.window.document), or is the 'context' of what you can see limited to what the initial ur [More]
I want to limit the number charecters in the JTextfield during the time of typing the charecters. How can I do it simply ? One way, I can make an own class extend the JTextfield and check by using the events to restrict the charecters. Other than thi [More]