Popular Tags
- Reporting 1,306
- OTBI 1,240
- Analysis and Data Visualization 823
- BI Publisher 697
- FDI 678
- Analysis 628
- Administration 517
- Oracle Fusion Analytics 482
- OBIEE 394
- BI Publisher Data Models 290
- Answers 253
- Analyses 248
- Developers 231
- Analytics 212
- Security 209
- Data Connectivity 200
- HCM 189
- Data Modelling and Datasets 189
- ERP Analytics Content 169
- Report Output 166
- BIP 158
- BI Publisher Report Templates 147
- Agents 147
- OAC 143
- Packaging and Licensing 128
Answers
Discussion List
-
2 columns report issueI have used 2 columns in report not get correct data but some values is correct and some values not correct so how to get achieve this report in Obiee and am checked in …User_HQ9TE 32 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
If applied formula in column grand total percentage value doesn't correct percentageIf applied formula in column grand total percentage But column value based on formula is correct but grand total percentage is not correct 2/804 *100=0.25% is correct Bu…User_HQ9TE 125 views 5 comments 0 points Most recent by EzequielC-Oracle Oracle Analytics Cloud and Server
-
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 ThanksUser_HQ9TE 47 views 2 comments 0 points Most recent by EzequielC-Oracle Oracle Analytics Cloud and Server
-
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 122 views 8 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
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…User_HQ9TE 21 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
OPERA CLOUD VS OPERA R&A Timing ARE NOT MATCHINGHi team, My time in Opera is Different from time in R&A for example, if the Reservation time created in opera is 16/01/24 - 4:40 Am in R&A it shows 15/01/24 - 5.40 exact…User_TSZUE 33 views 3 comments 0 points Most recent by Harriet Huang-Oracle Oracle Analytics Cloud and Server
-
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel Templates Content Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when …Dhanuka Chamal 457 views 7 comments 0 points Most recent by Manish Maheshwari Oracle Transactional Business Intelligence
-
2Restrict 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 397 views 1 comment 2 points Most recent by Balasubramanian Oracle Business Intelligence
-
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 183 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 320 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 783 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 Business Intelligence -
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 68 views 3 comments 0 points Most recent by Federico Venturin 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 2K 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 414 views 6 comments 0 points Most recent by User_307T7 Oracle Transactional Business Intelligence
-
4How 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 33 views 5 comments 4 points Most recent by Michal Zima Oracle Analytics Cloud and Server Idea Lab
-
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 894 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 203 views 8 comments 0 points Most recent by SR_CC Oracle Transactional Business Intelligence