Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
General Transactional Reporting (OTBI)
Discussion List
-
OTBI - Not exists / Outer Join ?Summary Can we write a report where something DOESNT exist?Content I want to create a report where we list where a user HASNT entered their timecard records. So effectiv…
-
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 f…
-
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 administ…
-
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 insta…
-
Require report output in A4 page layout.Summary Require report output in A4 page layout.Content We have report output format as PFD. We want report output in A4 page layout ,how we can achieve this in oracle f…
-
Oracle Business Intelligence 11g installationContent I Guys, I want to install Oracle Business Intelligence 11g, I Just download the 5 file.zip from https://www.oracle.com/middleware/technologies/bi-downloads.html …
-
PDF output in IEContent Hi, We have created a custom report and rtf output. And the format is defaulted to PDF. When we are generating the output, Mozilla and chrome is giving the exact…
-
Use ESS to run a BI Publisher job that transmits reports via SFTPSummary Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?Content We have built some Custom Reports in BI Publisher that extract data …
-
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter?Content I need an Analysis with a filter to pick up dates within the last week…
-
OTBI - Patching and impact on "Manage Priveleges" set-upContent Hi All, I was not aware so far, but it seems that with each patch, access set-up (Administration/Manage Priveleges) is brought to default values. E.g. - We dont …
-
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 rig…
-
BIP Failing With Error: oracle.xdo.servlet.data.DataException: Could not apply digital signatureSummary BIP Failing With Error: oracle.xdo.servlet.data.DataException: Could not apply digital signatureContent Hi, We have a requirement is to add digital signature to …
-
Force Performance Tiles to show 0 versus No ResultsSummary Force Performance Tiles to show 0 versus No ResultsContent Is there a way to force a Performance Tile to show 0 versus the No Results message?
-
Get privilege to issue logical SQL in OTBISummary As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log …
-
Oracle report development methodologySummary Looking to see if there is a suggested report development methodology for use across Oracle reporting toolsContent Using HCM & ERP and wondering if there is a re…
-
R13.19C Introducing OTBI Metadata Independent Mode Using BI Cloud Connector (BICC)Summary Opt in to use the OTBI Metadata Independent Extract Mode in BICC introduced in R13.19C.Content What is the Change? Starting in Release 13.19C, BICC will no longe…
-
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated valuesContent Hello, I have a need to see only the null values and future dates. I'm …
-
Remove Access to Create OTBI ReportsContent Hi, How can I remove this access? I am able to remove from New using Manager Privileges.
-
BI publisher custom roleSummary BI publisher custom roleContent Can we create a custom role so the user can only have access to new data model for creating SQL queries and not able to edit exis…
-
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was runCo…
-
Not able to View Job history for OBIEE Agents in Fusion HCMSummary Not able to View Job history for OBIEE Agents in Fusion HCMContent Hi, As of now in OTBI we are not able to view the job History for the Agent? this feature is v…
-
How Can I Post a Question for BI Publisher Reporting?Summary Need to understand etext templates and ordering of dataContent Hello, I would love to see any example please of etext templates for Fusion BI Publisher that have…
-
NO Permission in BI Publisher --xmlpserverSummary NO Permission in BI Publisher --xmlpserverContent Hi, The admin user have the folder permission in OTBI / analytics but permissions are greyed out in xmlpserver.…
-
Future Dated ActivitiesSummary Show Opportunities with Future Dated Activities tied to themContent I posted this to the Reporting and Analytics for Engagement Cloud forum but I don't have grea…
-
Audit History to access changes made in BIP Data ModelSummary Require table or methods to find out changes done in BIP Data ModelContent Hi, We have encountered an issue recently where the data model query were updated by s…
-
Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B versionSummary Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B versionContent Hi, Can we generate a OTBI analysis in a Pyramid format in R13 relea…
-
OTBI Reports take into Account AoR settings ?Summary OTBI Reports take into Account AoR settings ?Content When running an OTBI report would they only see employee data in the output according to their Area of Respo…
-
Where to change file format to UTF-8Summary Exports from OTBi must be UTF-8 encodedContent Hi everybody, I try to find a way to have extracts done by OTBI agents in the UTF-8 encoding format by default. Cu…
-
Customer hierarchy using BI Analysis (or OTBI)Content Hi All, I need to build a customer hierarchy report using BI Analysis (or OTBI). It should display Party Name, Party Usage and Primary Address. Can anyone help m…
-
Parameters are not showing up in the report output when i use Bursting OptionSummary Parameters are not showing up in the report output when i use Bursting OptionContent Hi Team, I have build a custom report with Excel template, there is a requir…