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
-
Is there a way to specify new default colors in OTBISummary Overwriting Default Colours for bar graphs and Pie ChartsContent Hello Everyone, I'm looking for a way to overwrite the default colors for graphs. I know that I … -
BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"Summary BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"Content Hello Everyone, We are on Oracle Cloud Application 20B. I was try… -
Smart view no longer connect to OBIEEContent Hi, I have installed the latest smart view and now found out that the private connection to obiee is no longer provided. below is the screenshot of old smart vie… -
BI Publisher : How to hide a sheet in excel based on parameter using Excel TemplateSummary BI Publisher : How to hide a sheet in excel based on parameter using Excel TemplateContent BI Publisher : How to hide a sheet in excel based on parameter using E…
-
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then I…
-
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 expec…
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …
-
The report cannot be rendered because of an error, please contact the administrator.Summary The report cannot be rendered because of an error, please contact the administrator.Content Error The report cannot be rendered because of an error, please conta…
-
OTBI Outer Join Subject AreasSummary How to connect subject areas where I need to represent null for rows that are not existing in other subject areaContent Hello, I am struggling with creating an a…
-
Remove empty folders in /CustomContent Hi, When being provisioned an environment, there are often a lot of empty folders already in the Shared Folders/Custom folder. See screenshot below of what we cu… -
MD5 encryption in RTF templateSummary In BI Report output using RTF template, need to to include a URL string which is formed using multiple flex field values and need to encrypt that particular URL …
-
Display photographs in OAC AnalysisSummary Display photographs in OAC AnalysisContent Facing a strange issue in OAC while displaying photos. Customer is capturing photographs of readings. These photos are… -
How to add a BI Report in Dashboard to a Briefing book?Summary I'm trying to add a BI report in Dashboard to a Briefing book,but it error'd out with following error.Content A fatal error occurred while processing the request…
-
Report on BIP Catalog Folders detailsSummary Report on BIP Catalog Folders details like Roles and Permission etc.Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission etc… -
IO Exception Thrown! 13 >= 13Summary When attempting to run a BI Publisher report and export to Excel (or generate it as an Excel report), I receive an IO Exception ErrorContent When attempting to r…
-
Workforce Performance - Performance Document Eligibility Real timeSummary Assignment Level DFF Attribute1 value in Workforce Performance - Performance Document Eligibility Real timeContent Hi All How can i bring Assignment Level DFF At… -
Dashboard with multiple BI Publisher reports export to excel is blankSummary When using the Export entire workbook to excel function the exported excel sheet creates all the correct worksheet pages and headings however, the data is blank.… -
Dynamic Scale Markers for Trellis GraphSummary How to define Scale Markers that vary by Account in order to reflect the service level agreement for the AccountContent In a Trellis graph of Account v. Activiti… -
Table Cell level BordersSummary How to change the border color to blackContent In one of my analysis which is table layout i get the attached Output. I want to change the white color to black. …
-
PDF Template with Form Fields not Showing Data in BIPContent I've created a BI Publisher Data Model and Report and I'm trying to upload a PDF template that has form fields with the XML columns inserted. When I run the repo… -
BI Published Report Date VariablesSummary Date variable for previous monthContent Hello, I was on this site: https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.h… -
Run OTBI Report in previous Accounting PeriodSummary Run OTBI period in previous Accounting PeriodContent I have a OTBI Report with Accounting Period as input parameter. Requirement is to run the report for current…
-
Wrap Text in MHTML formatSummary Wrap Text in MHTML formatContent Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wan…
-
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t… -
Drill to another Compound LayoutSummary How can I let users drill into a number that takes them to a 2nd compound layout on an analysis?Content Hello, I have an analysis that I plan on making into a da…
-
Issue with xsl:number used in BIP ReportSummary xsl:number used for formatting in BIP Report doesnt work.Content Hi All, BIP newbie here. I am building an RTF template, where I am required to show continuous v…
-
Getting error in BICC while running the DOO Line DetailSummary BICC job is failing while running the DOO Line DetailContent BICC job is failing while running the Line Detail. Attached is the log file. Please help Table name:…
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…
-
Calculated column not giving valuesContent I'm creating an AP dashboard where I want to combine the subject areas for AP invoices and payments to show in a single column whether an invoice is paid/unpaid …
-
OBIEE 11.1.1.9 - BI Publisher report with Bar Chart - Hover does not show dataSummary I have created a BI Publisher report with a bar chart however, when I run the report there is no data shown when I hover over the bar graph.Content I have now us…