Hello, In administration of BIP you have: set it to a new value. Regards, Carlos

Hello, The only things i know are described here: https://blogs.oracle.com/saas-fusion-app-performance/enabling-scalable-mode and in here: https://docs.oracle.com/middleware/1221/bip/BIPDM/best_practices.htm#BIPDM550 Take a try. Carlos

Hello, Ok, let´s go step by step. Can you attach the downloaded xml? I am a litle confused, how did you obtained that xml? Was executing the data model with the new query( SELECT ITEM_PACKAGE_COUNT FROM ( select t.*, row_number() over (partition by s_ship_unit_gid ORDER BY INSERT_DATE DESC) rn FROM shipment_stop_debrief t)…

Hello, For what i´ve seen so far you have a DS named: 'archivec' where you´re shipment_debrief is connected to, and all others are connected to another DS named 'otmoltp' (this is defined has default). This means you´re data is coming from different DB/schemas, right? What is the types of your DS…

Well, i was thinking it could be something about the DS´s. BTW, the shipment_debrief sql test was made on wich DS/DB?Can you run it in the same, AKA:otmoltp ?Does it still works and return data? BR Carlos

Yes it does. The new data set is in a new group of result set. Before you could have something like: <G1> <field1>value1</field1>…</G1> And now you have something like: <G1> <field1>value1</field1>…</G1><G2> <field1>value1</field1>…</G2>… The data sets in data model do not have to be mandatory connected(linked) among each…

Can you try to remove the link and execute, pls? Thanks, Carlos

Ok, it´s working. That´s fine. Next step: the link; You linked the SHIPMENT_GID field from first data set to what field of 'new' data set? You are aware you must link correlated fields ( as foreign keys), right? The same you do in DB when you want a value from a table to appear in another table, as example above( as if you…

Hello, Have you tried just to run your sql query on sql plus/developer ? Did it worked? Regards, Carlos

Hello, Not sure if this is what you are looking for but give it a try at:https://docs.oracle.com/middleware/12213/bip/index.html Regards, Carlos

Hello, Please confirm: can you run that report in BIP and output as excel? Regards, Carlos

BTW, are you able to successfully run it in soapUI?

Hello, Could you please provide you´re bip version? final String outFormat = "xlsx";reportRequest.setAttributeFormat(outFormat); and you do not need to add the extension in the file name, otherwise you´ll get e.g.: fileNamepdf.pdf Regards, Carlos I tested in 12.2.1.3.0.

Hello, Not quite sure if i understand you´re issue. Looks to me there are two issue in you´re post: generate a report in xlsx format using rtf template and data definition file and migrate the code to use BIP 11g api right? Kavitha_CP-Oracle has provided you a good document that helps you get started to use/test bip api´s…

Hello, There is a way of you change the source of data in all of your data model in one place, however the DS name will remain the same. Just change the name of the connection where you connect to. Example of 2 jndi DS: and you have in you´re reports the SRC_A. Now to point to B change in administration: and you will not…

Theoretically speaking (this is my big imagination...LOL) if you could download all dataModel at once, unzip all .xdmz folders, edit the _datamodel.xdm (and set where is the defaultDataSourceRef="your dataSource B" ) and upload all again it would work Regards, Carlos

Hello , Can you please provide the wordLayout.rtf and sampleData.xml files, pls? Regards, Carlos

Hello, BTW, have a look at: ,it might be helpful. Regards, Carlos

Hello ​, Thanks for clarify. So if that is the case, you need a sum, not a group(or perhaps the group is only to 'aggregate' the sum of results). I do not know if ​ agrees with me, but you would do a query like: select item, sum(quantity) from table where 1=1 group by item; Although it can also be done in msword. If i am…

Hello, Have you tried to run the query(s) in the sql developer/plus? Regards, Carlos