-
Forums
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
HCM ANNOUNCEMENT: Deadline Approaching Responsive UX - Urgent Action Required! -
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
Ideas
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
My IdeasCustomer Experience
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted Yesterday by Donald Ferreira
, tagged BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, Report Delivery, Report Layouts, Report Output, Reports in General OBIEE publicTitle:BI Publisher Excel - How to get multiple horizontal repeating groups working?Content: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
Document:Sample Template.xls (36KB)Document:Sample XML.xml (5KB)Document:Sample Output.xls (36KB)
Topic last edited November 20, 2019 by nathan morgan (at Client)
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Setup, Setup/Administration in General OBIEE publicTitle:What is catalog folder Extension?Summary:Does anyone know the purpose of the empty shared folder Extension in the catalog?Content: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#F10098Nathan
Version:19C (11.13.19.07.0)Image:
Code Snippet:- Topic posted November 13, 2019 by Stephanie Burghardt, tagged BI Publisher, BI Publisher Report Templates in General OBIEE publicTitle:Excel report is grey and no data is visibleSummary:When generating an Excel with BI Publisher the file is grey and no data is visible.Content:
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?
Version:Oracle BI Publisher 12.2.1.1.0 (build:20160526.2332)Image:
- Topic last edited November 5, 2018 by Viswanadh Kambham
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, Reports, Sample Reports, SQL in General OBIEE publicTitle:Need inputs to find who created/deleted the folder in Reports and AnalyticsContent: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
Topic last edited September 23, 2017 by MShrini
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Online Layout Editor, OTBI, Report Delivery, Reports, Sample Reports, Setup, Setup/Administration, Upgrades in General OBIEE publicTitle:The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary:The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent: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
Topic posted October 29, 2019 by Farooq Haider Syed, PMP
, tagged BI Publisher, BI Publisher Report Templates, OTBI in General OBIEE publicTitle:Unable to connect to BI PublisherSummary:Unable to connect to BI PublisherContent: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.
- Topic posted October 15, 2019 by Geetha Devi
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, OBIEE Answers in General OBIEE publicTitle:how to connect to Bi publisher administer console in fusion 19C?Summary:How to access the bi publisher administer console in fusion 19c?Content: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?
- Topic posted October 22, 2019 by Gaston van de Weijer, tagged BI Publisher, BI Publisher Report Templates, Report Output in General OBIEE publicTitle:Reference Relationship in BI PublisherContent:
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?
Version:19B 
Topic posted July 20, 2017 by Aaron Leggett
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, Report Output, Setup/Administration, SQL in General OBIEE publicTitle:Security Console TablesContent: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.).
Image:
- Topic posted May 15, 2019 by Praveen Kumar, tagged Analyses, BI Publisher, BI Publisher Report Templates, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, OTBI, SQL in General OBIEE publicTitle:How to get and SQL for our own OTBI AnalysisSummary:SQL for OTBI AnalysisContent:
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.
