Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Design of rtf template for multiple data sets
Summary
Design of rtf template for multiple data sets
Content
Hi Guru's
I am having trouble to display column data for CUST_NO_INV as it appears in the xml. The values are coming through as null values. Now for the sake of simplicity I will only show you a portion of the xml of which I am interested in. I want to have the output in a flat file exported showing column CUST_NO_INV in column A of excel file and CONS_BILL_DISP in column B of the excel file.
Now the problem as I see it the one part of the data lies in G_CUST_INV data set and the other lies in G_1.
So how do I build the template that will allow each record to show me the customer number and it's correllated bill number?
Any help or guidance would be most appreciated.
Message was edited by: 2810700 I have now attached the xml sample file and rtf. Please have a look and see if what I want are possible.
Answers
-
Hello,
I am not guru , but looks (and your title suggests it) that these values are coming from distinct data sets.
Can you please attach the sample.xml to check it better.
If that is the case (the data is not correlated) how do you expect the excel/word(whatever output) to correlate it? I do not think it is possible unless you change you query to have dependency between CUST_ID_INV and CONS_BILL_DISP.
Or am i seeing this all thing wrong and you simply want to list the all the values side by side from each data set, no matter what values are alligned?
Regards,
Carlos
0 -
Hi
Thanks for your feedback. I cannot change the code. Seeded code is being used. Was hoping to get around it in the custom template. The data set is used in the seeded template but not as part of the detail data. It is part of the header data.
Thanks
Cheryl
0 -
Cheryl,
When you are building your template run a for-each:group on G_CUST_INV display the"CUST_ID_INV" and a for-each or for-each current group and display the "CONS_BILL_DISP"
something like below
Hope this help s...
0 -
Hi
Thank you for your response. I have now tried that but it still pulling null values. I am not sure if it is because the template also have other commands built in.
Would it help if I sent you the rtf for review?
Kind Regards
Cheryl Kleu
Independent Contractor
T +27 11 5758645
M +27 83 2229644
Echeryl.kleu@britehouse.co.za
0 -
Hello,
You could send the rtf and the sample.xml.
Regards,
Carlos
0 -
it would be easy if you can send the RTF and the sample XML to the thread
0 -
Is there any sort of key that joins this data together or are they completely separate? If there is a common field in both datasets you can join them in your datamodel which will allow you to use data from both datasets in the same loop.
0 -
Hello,
You can attach to your reply the files as you did with image in original post.
That way everyone will be able to help you.
Regards,
Carlos
0 -
Hi there
Can I please send it to your email address and if so could you share your address with me please?
Thanks
Cheryl
Cheryl Kleu
Independent Contractor
T +27 11 5758645
M +27 83 2229644
Echeryl.kleu@britehouse.co.za
0 -
Hi Adam
The only link I can find is that of <INV_ACCT_DESCRIPTION> from the <G_INVOICE> data set that has the same value of the <CUST_NAME_INV> from the <G_CUST_INV> data set.
I cannot however join them in the data model as we are using seeded data model and scope to change this is not possible.
I must find a way to 'join' or dispay within the template?
Thanks
Cheryl
0