For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hello There,
I would like to know how can I get the below output using BI Publisher for Excel.
I have three groups in the xml file.
G_1 -> G_2 -> G_3
Below expected output:
G_1 | G_2 | G_3 | |||
---|---|---|---|---|---|
Segment1 | Creation_Date | Line_Num | Item_ID | Quantity_Ordered | Quantity_Delivered |
10001008 | 08 11 2019 | 10 | 300000013603844 | 200 | 100 |
20 | 300000013612944 | 300 | 200 | ||
30 | 300000013615636 | 10 | 5 | ||
40 | 300000013626474 | 20 | 1 | ||
50 | 300000013676169 | 2 | 2 | ||
10001009 | 22 11 2019 | 10 | 300000014432708 | 11 | 11 |
20 | 300000014437123 | 25 | 25 | ||
30 | 300000014434715 | 6 | 6 | ||
The output I am getting now is as below:
G_1 | G_2 | G_3 | |||
---|---|---|---|---|---|
Segment1 | Creation_Date | Line_Num | Item_ID | Quantity_Ordered | Quantity_Delivered |
10001008" rowMark="2 | 2019-11-08T04:35:17.000+00:00" rowMark="2 | 10" rowMark="3 | 300000013603844" rowMark="3 | 200 | 100 |
20" rowMark="3 | 300000013612944" rowMark="3 | 300 | 200 | ||
30" rowMark="3 | 300000013615636" rowMark="3 | 10 | 5 | ||
40" rowMark="3 | 300000013626474" rowMark="3 | 20 | 1 | ||
50" rowMark="3 | 300000013676169" rowMark="3 | 2 | 2 | ||
10001009 | 22 11 2019 | 10" rowMark="3 | 300000014432708" rowMark="3 | 11 | 11 |
20" rowMark="3 | 300000014437123" rowMark="3 | 25 | 25 | ||
30" rowMark="3 | 300000014434715" rowMark="3 | 6 | 6 | ||
Please find attached the sample xml, output and the excel template file for your reference.
Look forward to hearing from you.
Thank you & regards,
Donald
The folder is empty.
A duty role exists for it, BI_EXT_REPORTING_DUTY, but unlike the other folders, the permissions on this folder have not been updated so that only people with that role see this folder.
I had been doing the following configuration to assign folder reporting duty roles to role
Custom BI Webcat Reporting Duty
CONFIGURE NEW BI REPORTING DUTY ROLES TO HIDE THE FACTORY CATALOG FOLDERS
Cloud Readiness Common Technologies and User Experience
https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098
Nathan
After generating an Excel file with the BI Publisher the sheet is grey and the data is not visible. But the data is there and can be seen in the small field in the header. After saving and reopening the file the sheet looks normal.
What is wrong here?
Hi All,
We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report?
We need to know the username as well as IP Address of the machine.
Thanks,
Visu
We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspace as error message is returned. Kindly help us in this regard as we have to build OTBI report on smartview
I am trying to connect BI Publisher but unable to connect, I have download the BI publisher and while opening the word file to connect it with Oracle it is not giving me the tab to connect with Oracle.
Any idea or steps to connect with BI publisher.
I have added some roles to my fusion account. But, I cannot see the bi publisher administrator console offering in fusion 19c
Could anyone please help with this?
Hi,
I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels
1. The user adds an instance 'the box' and enters dimensions and more information.
2. I created a relationship from 'the box' to 'the item' called 'the debrief item in the box'
3. I added this relationship to the entity collect screen, so you can check which items will be in the box.
4. The data overview displays exactly what I want:
5. However, I cannot get this in BI publisher. I want an overview of items per box, however, I can't seem to pull this off. Once I create a 'for each' for every box, I can't add another 'for each' in there. I can't seem to add the items in this overview..
How do I create a report with BI publisher with a page for a box and a list of items in the box below?
Hi Everyone
Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the right roles to the right people throughout our implementation and I feel this report will give us a much better understanding for our programme team to see what each role gives access too. Below is a screenshot from the Security Console showing what I would like to extract (Role Name, Role Code and Role Description...if possible the type of role too, such as Duty, Data etc.).
Hi All,
How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub query and all.
Where to get the SQL including sub query.Also help me with the navigation.
Thanks in Advance.
Regards,
Praveen G.