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
-
Format Graph Color - Select Pattern FillSummary Format Graph Color - Pattern FillContent I know that we can add a pattern fill for a color > Column Properties of the graph > Style tab > Style drop down > Patte… -
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a… -
Pulling multiple candidate Q&A answers into single columnSummary Advice on how to combine multiple candidate answers into single columnContent We are currently running a campaign where a requisition has been duplicated 20 time… -
BI Publisher - Adding Pivots with specific formatting on Head Count ReportsSummary Approach to use/add Pivots based on some Head count Reports built using BI PublisherContent Hi All, We have requirement to generate Pivot tables/Charts (Pie/Bar …
-
BIP OptionsContent Hi experts - I need some assistance with some options within BI Publisher reporting, hoping you can help! 1) Is it possible to allow users to type into a paramet… -
Subtract resulting values of CASE functionSummary Need to subtract two values that are first derived using the CASE functionContent I have created two measure columns that use a CASE function. I am trying to sub… -
How to Create a Data Set using Content Server as Data Source in Oracle BI Publisher (Embedded withinSummary How to Create a Data Set using Content Server as Data Source in Oracle BI Publisher (Embedded within Oracle HCM Cloud Release 12/13)Content Hi Experts, Has anyon… -
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 quer…
-
Pivote future is available in OTBISummary Pivote future is available in OTBIContent Hi All,ecause of I have the requirement to develop the exit clearance report using OTBI.In Current case i am getting 10…
-
How to Pass Parameter from Dashboard to BI ReportSummary Passing Parameter from Dashboard to BI ReportContent Hi Experts, I have a BI Report which has a parameter. (A List of Value Item which gets value from a SQL Quer…
-
How to modify the content of a column through a result similar to RPADSummary How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to…
-
One report - multiple tabsContent Hi all - how do you create a report with multiple tabs? Right now, the team implemented a page break in the report build, but it places a blank row at the top of…
-
Moving Print and Export OptionsSummary Can we move print or export options at top from bottom?Content Hi All, We have reports at Dashboard and we want to move Print and Export options at top from bott…
-
OAC instance CreationSummary OAC instance creationContent Hi , Kindly share the link or document to create OAC instance. Thanks
-
Oracle Cloud Gen2 - Version ControlSummary Version Control for PaaS and SaaSContent Hello Everyone, Do you guys know if Gen2 will provide any version control tool? I am more interested in PaaS (to control… -
Password Protect Scheduled OTBI Excel AnalysisSummary Question on whether it's possible to add a password to OTBI outputContent Hi, I'm looking to add a password to the output produced by OTBI Analysis (excel format…
-
Usage of LAG function in Oracle BIP's child data set - Any Limitations?Summary Usage of LAG function in Oracle BIP's child data set - Any Limitations?Content Hello, I am trying to LAG function in a child dataset of Oracle BIP but it gives a… -
Groovy with the EPMSummary Learn Groovy to use with EPM and BIContent Hello Leaders, I want to learn groovy to use it with oracle Hyperion and BI , i know some fundamentals of the language…
-
Formula to capture last 7 days of dataSummary Formula to capture last 7 days of dataContent Hello, We are looking to capture requisition in specific statuses (Approved, To Be Approved, Draft, Sourcing and Fi…
-
Exporting RTF to Excel - merged cellsSummary Exporting RFT to Excel is producing merged cellsContent Hello I have a business requirement to remove 3 columns from a rtf template in BI. I have downloaded the …
-
Schedule new Report Job for BIP report, Notification tab doesn't save valuesSummary Schedule new Report Job for BIP report, Notification tab doesn't save valuesContent Hello. Has anyone else noticed this behavior when scheduling a BIP report job… -
Review Period FieldSummary Data not showing Review Period value when i am adding any other dimension columnsContent I am trying to fetch Review Period column in my report that is created u…
-
Published Report Schedule - showing message if attachment has nothingSummary If the published report attachment has no data, can we put that in the body of the message?Content Hello, For a personal BIP report schedule, if the attachment h… -
'Publish for Subscription' in OTBI AgentContent Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to not…
-
Export Analytic XML structure (not data) via analytics-wsSummary Back up analytics using analytics-wsContent I am wanting to do some partial automation with version control/backups using the analytics-ws. Does anyone know if t… -
Customize the embalmed Dashboard page option(Hide Edit dashboard)Summary Customize the embalmed Dashboard page option(Hide Edit dashboard)Content Hi Team, I have created a Custom page and added a dashboard into this page. I am looking…
-
Report Schedule DetailsSummary Need help to find out if it's possible to get some information regarding report schedulesContent I need to extract information of report schedules in the system.…
-
is there a report or how to create one that displays all the existing OTBI/PUBLISHER reports ?Summary is there a report or how to create one that displays all the existing OTBI/PUBLISHER reports ?Content Hello,We would like to know if there is an existing report … -
OBIEE IssueSummary Report giving blank values for few columns when adding second subject area.Content I need to create report to pull performance rating given by manager. Right now…
-
New features - BICCC 19A patchSummary Document for new features list in BICCC - 19A patchContent New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be…