Design of rtf template for multiple data sets

Chez

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.

Carlos Carvalho

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

Chez

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

YGUTTIKONDA

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...

Chez

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

https://urldefense.proofpoint.com/v2/url?u=http-3A__www.britehouse.co.za&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=J0c9pJSHG4nYqXAMPCi8W4OODRgLT8Gma9DHAp5n8DHBwoVbFCCQ4OEmzUQt6qul&m=sRFjiNHVqQ-MUNf0hPsmQLF7bFriALFtERpibxwg-ys&s=O81Ftet67H9QCn1I8MEP8roXFwCGt4VjdDQsAY_6yTQ&e=

View our disclaimer at: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.britehouse.co.za_Pages_disclaimer.aspx&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=J0c9pJSHG4nYqXAMPCi8W4OODRgLT8Gma9DHAp5n8DHBwoVbFCCQ4OEmzUQt6qul&m=sRFjiNHVqQ-MUNf0hPsmQLF7bFriALFtERpibxwg-ys&s=4xVhWBylF831m7Zk4aDptcAsnr7lpvL6a0Tasutlr0w&e=

Carlos Carvalho

Hello,

You could send the rtf and the sample.xml.

Regards,

Carlos

YGUTTIKONDA

it would be easy if you can send the RTF and the sample XML to the thread

Adam Wickes

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.

Carlos Carvalho

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

Chez

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

https://urldefense.proofpoint.com/v2/url?u=http-3A__www.britehouse.co.za&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=J0c9pJSHG4nYqXAMPCi8W4OODRgLT8Gma9DHAp5n8DHBwoVbFCCQ4OEmzUQt6qul&m=sfOEoIkVlekagXwDbDT5tfocw4fiStk72EXOlzCxwaI&s=Br6uMJiI_ZC2uFiQf11W6Ih4qtvf7IIxRYBI5uXF03U&e=

View our disclaimer at: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.britehouse.co.za_Pages_disclaimer.aspx&d=DwIFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=J0c9pJSHG4nYqXAMPCi8W4OODRgLT8Gma9DHAp5n8DHBwoVbFCCQ4OEmzUQt6qul&m=sfOEoIkVlekagXwDbDT5tfocw4fiStk72EXOlzCxwaI&s=yPaTrVLdpe7bLhKnWoRacu0FqkIMeWIuSQXypxjWjn4&e=

Chez

Hi Carlos

Would prefer to email direct if possible? :-)

Thanks

C

Chez

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

Adam Wickes

I've never used a seeded data model but would something like what's described in the following work where you download the model to a zip file and manually create the join between the datasets?

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=500139775040682&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id…

Apologies if i'm barking up the wrong tree.

Chez

Hi Carlos

I have now attached to xml sample and rtf. Would appreciate your input to see if it can be done within the template.

Thank you kindly

C

Chez

Hi Adam

I will have a look at the link and see if possible.

Thanks

C

Carlos Carvalho

Sorry for delay, but i had/have milestone deadlines...

Anyway, find out a space to your question.

Check if this is what you want(attach).

Regards,

Carlos

Carlos Carvalho

Hello,

Glad to hear

Regards,

Carlos

P.S.- pls, close this post.

Chez

Thanks implemented your solution.. Now working.

Mehak Arora

Hi Carlos,

Can you please tell the solution for the above discussion as i also have the same problem and am not able to see the attached file ?

Thanks in advance.

Muzammil Aman Siddiqui-Oracle

Can you anyone post the solution please

Gianni Ceresa

@Muzammil Aman Siddiqui-Oracle ,

This is a 6 years old thread, migrated through a number of forums over time.

If you have a question, even if similar to this one, could you please post it as a new question in https://community.oracle.com/products/oracleanalytics/categories/bi-publisher ?

Remember to provide as many details as you can about it, including what seems to be obvious (it is for you, but could help others understand your context better).

Thank you