OBIEE Answers
Discussion List
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: ****-XX-XXXX (112-10-1234) TI…satya_nvs 23 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI) -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 112 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI) -
How to Dipslay Total at the Top of Stacked Vertical Bar ChartSummary Need to know how to Dipslay Total at the Top of Stacked Vertical Bar ChartContent While representing data as vertical bar chart (due to groupings used/needed) I …Krishnaraja Nelli-47394 41 views 4 comments 5 points Most recent by Noelle Bartlam-Oracle General Transactional Reporting (OTBI)
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t…Dhanuka Chamal 41 views 5 comments 2 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI) -
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…Richard Beet 147 views 5 comments 0 points Most recent by Venu Kumar General Transactional Reporting (OTBI)
-
Is there possible to create prompts in combine resultDear , i have otbi report which showing result based on two criteria means combine and now i want to click on colleague name and opens new report based on that name so i…Mirza_Adeel 12 views 3 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory.Content Hi, I have an OTBI Report running into error when …Aloka Bhattacharya 15 views 5 comments 2 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 21 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisionsContent Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision …Mr H 22 views 8 comments 1 point Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 26 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
OTBI Report Date Format changes when exporting to ExcelContent We are trying to change the formatting of a column in OTBI report by changing the column properties of each date columns. We are using the following format: Date…
-
Run an analysis (agent) as target user, but deliver to proxy userContent We have some sensitive data which are automatically shielded off through HR roles in the BI Catalog because they are obiee analysis in hcm subject areas. We have…MaartenDIF 23 views 3 comments 1 point Most recent by MaartenDIF General Transactional Reporting (OTBI) -
OTBI session and repository variables full listContent Hi, could anyone provide the full list of session variables and repository variables available in OTBI Regards, AlbertoAlberto Boccato 53 views 6 comments 0 points Most recent by mgoswami General Transactional Reporting (OTBI) -
Pivot table in RTF TemplateContent Hello, I am trying to create a pivot table for an asset number per row and period name and depreciation amount in columns. I have followed this doc to create the…Nalinee Uppiah 24 views 10 comments 0 points Most recent by Anil Kola-Oracle General Transactional Reporting (OTBI)
-
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest valueContent OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If differ…Srinivas Challa 77 views 3 comments 1 point Most recent by Matthias Ludewig General Transactional Reporting (OTBI)
-
As Of Date Report Not Pulling Current Row if Ethnicity Is Included In OutputContent The report below is an "As Of" dated report. The issue i am seeing is that if ethnicity is included in the output of the report multiple rows are pulled for asso…User_EQ8R5 5 views 2 comments 0 points Most recent by User_EQ8R5 General Transactional Reporting (OTBI)
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEEContent Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Objec…edpalomo 12 views 2 comments 0 points Most recent by edpalomo General Transactional Reporting (OTBI)
-
OAC/OBIEE and Hyperion Planning PBCS integration questions about RPD and about reportingContent We have two Oracle Cloud Services: OAC and Hyperion PBCS. My questions about general integration between these two. OBIEE and OAC works the same way, that is why…
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBIContent Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bus…Nathan CCC 18 views 2 comments 1 point Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Calculating Percentage in OBIEE ReportSummary Calculating the Percentage of two columns. One column being a calculated field in itself and the other pre-defined field.Content Hello, I am trying to calculate …MarkS 24 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle General Transactional Reporting (OTBI)
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errorsContent Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here I…Dhanuka Chamal 27 views 3 comments 3 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI)
-
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 …Rob F 31 views 5 comments 3 points Most recent by SantoshKumarB General Transactional Reporting (OTBI) -
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…Dhanuka Chamal 21 views 4 comments 2 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI)
-
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…Jenny Tan 18 views 1 comment 0 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
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…Brenda Jacks-49721 84 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
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 …Kunal Daya-76859 47 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
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…SaurabhJaiswal-Oracle 15 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)