Popular Tags
- OTBI 1,473
- Reporting 1,405
- FDI 1,195
- Fusion AI Data Platform 1,038
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 611
- Administration 556
- OAC 527
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 419
- Fusion ERP Analytics 409
- BI Publisher Data Models 361
- Security 301
- HCM 279
- BIP 267
- Answers 266
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Data Connectivity 214
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
How to get top 5 model report in ObieeHello Everyone, I have a 2 columns 1 is model and another is measure column so how to set top 5 model report in Obiee Could you please guide me any one Thanks -
Is there a way to identify list of analysis which are using a particular saved filterIs there a way to identify list of analysis which are using a particular saved filter, how to do in OAC?NIKHIL ARORA-Oracle 147 views 8 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Forum -
When ever apply some another column in sql it will automatically affected another measure columnHello Everyone, When ever apply some another column in sql it will automatically affected another measure column in sql report I want c1 is 15 value based on add another…
-
3Restrict the display of information from a custom report to specific users through data access.Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Aseguradora Aserta, S.A. de C.V. Grup…Fernando Ch 411 views 1 comment 3 points Most recent by Balasubramanian Oracle Transactional Business Intelligence Idea Lab
-
How to Custom Sort Months in OBIEE 12Hi All, can you please tell me how to custom sort months in FY order Jul 23 - June 24, in Subject topic Statistic history and forecast. Thank you in Advance. kind regard…
-
1LAST_PERIOD functionHi, the LAST_PERIOD function does not seem to work (there is no difference to the LAST function; "Data is dense" flag is checked) I tried to analyze quarter values (wher…
-
After migration from 12c to OAS, Customized home page is not working as expected in OAS.Hi Team, We have recently migrated the BI reports from obiee12c to OAS. we have custom home page in 12c like logo, company name and report name text in bold. But in OAS …
-
Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.Hi, I am facing an ' Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.' error in OAC. Is this related to 'Maximum Number of Rows …
-
2Fits Maps in frame in dashboard when you hide map data layer.When you are using maps in an Analytics dashboard, and you hide the map data layer, the map doesn't Autofit to the frame and the unsightly spaces appear at the sides of …Jose Luis Alvarez Elbal-Oracle 11 views 0 comments 2 points Started by Jose Luis Alvarez Elbal-Oracle Oracle Transactional Business Intelligence Idea Lab -
Customized export option is not working in dashboard reports in OAS after migrating from OBIEE12cHi, Recently we have upgraded the BI server from 12c to OAS. After reports migration to OAS, we have an issue with customized export option. we have created customized e…Gopi Krishna P 102 views 3 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Forum
-
How to use And condition in Conditional formatting in Taleo OBI ?Hello Guys, We are trying to combine two conditions like if job board = 'xyz' and number of days the job is posted to to 'xyz' job board is >=7, then display the cell or…User_P2ZNQ 21 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Business Intelligence Applications Forum
-
Query to find the HRBP Representative of an Employee in HCM DatabaseSummary: Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details. Content (…User_H69RU 2.9K views 4 comments 0 points Most recent by SOUMYA PRIYA CHOWDHURY Oracle Transactional Business Intelligence Forum
-
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…Donald 685 views 6 comments 0 points Most recent by User_307T7 Oracle Transactional Business Intelligence Forum
-
How we can find a list of all reports which are not being used by end users in OAC?How we can find a list of all reports which are not being used by end users in OAC? We’ll need this information multiple times during the OAC Migration and it’s not viab…
-
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…rbeet88 1.2K views 7 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
Bursting output file name character limitContent Hi, I have defined Bursting Output file name in the query as below- LegalEntityName || BusinessUnitName || 'Report' || To_CHAR(SYSDATE,'YYYYMONDDHH24MISS','NLS_D…JYOTI MAURYA 242 views 8 comments 0 points Most recent by SR_CC Oracle Transactional Business Intelligence Forum
-
How to convert PO ordered amount in USD (Conversion type as SPOT)We are creating an analysis using 'Procurement-Procure to Pay Real Time' where we need to convert and display PO amount in USD. Using the conversion tyoe as SPOT. I coul…Thanigainathan R 1 view 0 comments 0 points Started by Thanigainathan R Oracle Transactional Business Intelligence Forum
-
Getting error while creating reportHello All, We are recently migrating from OBIEE 12c to OAS 6.4. But we are facing one problem after migration. One of our connection pool contains connection for vertica…
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best Practice Content This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 161 views 2 comments 1 point Most recent by SAHIL VASYANI Oracle Transactional Business Intelligence Forum
-
EVALUATE function with REGEXP_SUBSTR dbfunction not working as expected within OTBI reportingHi, We need to use REGEXP_SUBSTR function to get 6th segment value from Depreciation Expense Concatenated Segments. For example, we have a concatenated segment value of …Satyavrat_Savarn 44 views 0 comments 0 points Started by Satyavrat_Savarn Oracle Transactional Business Intelligence Forum