Popular Tags
- OTBI 1,430
- Reporting 1,386
- FDI 1,073
- Analysis and Data Visualization 977
- BI Publisher 842
- Analysis 673
- Oracle Fusion Analytics 578
- Administration 555
- OBIEE 431
- OAC 419
- Analytics 389
- BI Publisher Data Models 349
- Security 290
- Answers 264
- HCM 255
- Analyses 253
- BIP 249
- Developers 243
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 205
- BI Publisher Report Templates 202
- Report Output 183
- Oracle Analytics Cloud 171
- Customizing Reports 156
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
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…User_TSZUE 211 views 7 comments 0 points Most recent by User_LL6E2 Oracle Analytics Cloud and Server
-
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…user13696629 21 views 0 comments 1 point Started by user13696629 Oracle Analytics Cloud and Server Idea Lab
-
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 …Gopi Krishna P 421 views 9 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
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 …kusuma l -Oracle 1.4K views 11 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
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 82 views 3 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Cloud and Server
-
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 11 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Business Intelligence Applications
-
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.7K views 4 comments 0 points Most recent by SOUMYA PRIYA CHOWDHURY Oracle Transactional Business Intelligence
-
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 591 views 6 comments 0 points Most recent by User_307T7 Oracle Transactional Business Intelligence
-
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…User_LYZND 101 views 4 comments 4 points Most recent by Michal Zima Oracle Analytics Cloud and Server
-
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.1K views 7 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
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 201 views 8 comments 0 points Most recent by SR_CC Oracle Transactional Business Intelligence
-
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
-
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…Anirban310 51 views 1 comment 0 points Most recent by EzequielC-Oracle Oracle Analytics Cloud and Server
-
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 131 views 2 comments 1 point Most recent by SAHIL VASYANI Oracle Transactional Business Intelligence
-
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 32 views 0 comments 0 points Started by Satyavrat_Savarn Oracle Transactional Business Intelligence
-
How to add fields to change history?How to add fields to change history? i want to add a new Fixed Choice List field in the fields search in change history tab of Opportunities. please let me know if we ca…Pavan_Ketha 21 views 1 comment 0 points Most recent by Hitesh Patel-Oracle Oracle Fusion CX Analytics
-
2security rules/watermark/user informationHi All, Can we add a user information like water mark, user name etc on the downloaded report(excel) in OAS application. Can someone suggest on the same please.User_CGBX8 31 views 1 comment 2 points Most recent by User_CGBX8 Oracle Transactional Business Intelligence Idea Lab
-
Performance Tile not working with PercentajesHi guys, I'm having a problem trying to display a performance Tile in obiee. I'm reporting a total percentage but is seems that the performance tile object does't work w…