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
The Doclet API was extended in Java 5 for getting information in generics, but I have been unable to get it to work. For example, calling ClassDoc.typeParameters and typeParamTags always returns an empty array. * @param <X> The X public class Test&l [More]
Hello Everyone, Well one, I have a little concern with my iPhone 5S 16gb Black for Sprint. I am noticing that from day 1 people have said that they have trouble hearing me and are experiencing a muffled effect on my voice. I end up having to speak re [More]
Is there a way for me to use airplay on my mid 2010 MacBook Pro ?http://support.apple.com/kb/ht5404Read other 2 answers [More]
Hi I wonder if I need to open all my user's that are in the satellite system (ECC) in the solution manager for the purpose of create support message or I can only create them as BP? If I don't need to open them, What is the proper way to configure th [More]
Hi , Shopping cart is not getting updated with backend document number in follow on document section I am getting graphic display but no backned doc number I am on EBP 5.0 Has anybody come acroos such issue any solution? Thanks in advance DiwakarHI D [More]
In the templet,I use a font type "Simsun" for Chinese in the subform. This font type is added in the output desginer by "font setup" . And this font has been existing in my os. When I generate a pdf file, the size reaches >6M.George [More]
Hi all, I have a very strange problem. I am trying to do a simple photo-gallery using edge animate without using the timeline as much as possible. Let's say I have a thumbnail, and I want to mouse over the thumbnail and it goes semitransparent and a [More]
Is there a way to have Greek spelling in Mavericks natively like for other languagesAnother one to try http://computerizer.biz/how-to-enable-greek-spelling-in-mac-os-x/Read other 3 answers [More]
Hi all, I'm using Flash Builder 4.5 (not burrito), and I'm not getting auto-complete on variables or functions within the class I'm working in.  It will auto-complete classes, and even variables within another variable, but not a variable within that [More]
IPad shuts down when I open Facebook, articles on CNN, newspaper articles, various videos.  Many thanksHi The apps, are now needing, more power from ipad that why you have problems If you can a good buy, is the iPad Air 1 was £479.00 now £359.00 For [More]