Analyses
Discussion List
-
set metric alert for dashboard or analysis (Fusion OTBI)Content Hello, I have a question regarding metric alert or email notification, let suppose there is KPI for total sales MTD (1M), I want to add a condition to alert the …Maram Abuzaid 14 views 2 comments 0 points Most recent by Maram Abuzaid General Transactional Reporting (OTBI) -
Libro GiornaleSummary What report are people using for the Libro Giornale?Content I have a requirement from our Italian Office that they require a report called the 'Libro Giornale' I…Josh Martinez-Perez 25 views 9 comments 2 points Most recent by Josh Martinez-Perez 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 83 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
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)
-
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…VipinSharma 30 views 12 comments 0 points Most recent by Syed Misbauddin-Support-Oracle 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 16 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
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…Stephanie Gott 38 views 2 comments 3 points Most recent by MaartenDIF General Transactional Reporting (OTBI) -
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 …MaartenDIF 15 views 13 comments 1 point Most recent by MaartenDIF General Transactional Reporting (OTBI) -
How to add row number (fixed order) in analysis?Summary How to add row number (fixed order) in analysis?Content Hello Oracle Team, Is there a way to add row numbers in analysis? When I used RCOUNT(1), the row number w…Jonathan Chan gmg 16 views 4 comments 3 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog?Content In our PROD pod, we have several folders under the custom folder location that inclu…User_VR8E0 39 views 4 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
oracle transactional business intelligence cloud service documentationContent Hi Experts, Please can you share the oracle transactional business intelligence cloud documentation link. I am not able to find it. Best Regards ParmitParmit Choudhury-Deloitte 33 views 6 comments 2 points Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
1z0-591 OBIEE CertificationSummary Need assistance on preparation of 1z0-591 OBIEE examContent Hi Experts, The course is all about 12 C and the exam is for 11 g.So can anyone help me how to prepar…priscilla balusupati 23 views 2 comments 0 points Most recent by priscilla balusupati General Transactional Reporting (OTBI)
-
Dividing MetricsSummary I am trying to divide two metrics -- Not working!!Content I am trying to divide two metrics and am not getting the results I need. Can someone help? The number o…Stephanie Gott 14 views 12 comments 2 points Most recent by Cyrille Saulnier-Oracle General Transactional Reporting (OTBI)
-
Can data model data be called out by infolets on Oracle Cloud/Fusion?Summary In addition to analysis data, can data model information be added to infolet on Oracle Cloud/Fusion?Content Hello Oracle Community, Is there anyway to post data …Jonathan Chan gmg 16 views 6 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date dataContent Hello Oracle Community…Jonathan Chan gmg 8 views 2 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to create a prompt, Year-Month format, in analysis while not having a "Month" dimension?Summary The goal is to enable end users to look at an analysis by year-month periods (ex. YYYY-MM, 2020-01), but "Month" dimension is not available within the subject ar…Jonathan Chan gmg 21 views 6 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
Scheduled Report JobsSummary Deails of Scheduled Report JobsContent Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI or…User_3Y94S 57 views 8 comments 1 point Most recent by Akshay Aiyer General Transactional Reporting (OTBI)
-
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of useContent Hi All, I am looking for ways to monitor the performance of OTBI Reports in fussi… -
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column propertiesContent We have recently had an issue where one of our users has hidden a couple fie… -
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure"Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how can…Jonathan Chan gmg 19 views 8 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to build an inventory analysis coupled with time constrained measure?Summary An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measure…Jonathan Chan gmg 11 views 0 comments 1 point Started by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysisContent Hello Oracle communities, When I attempt to display the total number of rows shown in an analy…Jonathan Chan gmg 18 views 2 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder locationContent Does anyone have a SQL or know the tables that would contain the… -
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results?Content Hello Oracle Community, The below error (per enclosed 2 scree…Jonathan Chan gmg 20 views 7 comments 1 point Most recent by rajArun General Transactional Reporting (OTBI)
-
Sort drop-down list descendingly in Table Prompts in AnalysisSummary How to sort drop-down list descendingly in Table Prompts in AnalysisContent In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to so…Jonathan Chan gmg 14 views 8 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor FilterContent Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR Hany
-
Report on SocialSummary Need to create a report on Application SocialContent Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select fr…
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …Jonathan Chan gmg 20 views 8 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 20 views 1 comment 0 points Most recent by aconavay General Transactional Reporting (OTBI)
-
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, b…