Popular Tags
- OTBI 1,475
- Reporting 1,406
- FDI 1,204
- Fusion AI Data Platform 1,040
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 613
- Administration 556
- OAC 533
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 421
- Fusion ERP Analytics 411
- BI Publisher Data Models 361
- Security 302
- HCM 282
- BIP 267
- Answers 266
- Analyses 255
- Oracle Analytics Cloud 248
- Developers 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Fusion Data Intelligence 216
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE
Discussion List
-
Report: Run the report for past 1 year from Month and Year as Front End Prompt. OBIEEHi All, If someone can please help me with this issue. Business Case Month and Year are taken as input from front end as Presentation Variable; PV_M, PV_Y. Once I select… -
How to find out Tenure in Months of a customer? OBIEEHi all, Please help me with this attribute, I am unable to achieve correct answer. Tenure in Months 1- TIMESTAMPDIFF(SQL_TSI_MONTH,cast("Customer"."Customer Created Date…
-
Last 3 months data dynamicallyHi Team, We have Date_1 column with timestamp data type (9/30/2010 12:00:00 AM), we converted to month year format as Date_2 (SEP 2010) and using converted format Date_2…
-
Limiting the Prompt ValuesHi Team, We have created a prompt for month field format is like (Ex. Jan 2020, Feb 2020) for the count of orders report, here for few of the months we don’t have count …
-
Memory Usage of DV vs Classic OBIEE Report - OAS 5.5Can someone help me understand this in more clear? On OAS 5.5 memory and process usage when compared to DV and Classic report, I have few questions. * Does canvas on DV …
-
How to make change OBIEE RPD in online modeWhen trying to open OBIEE RPD in online mode, I'm getting error window, RPD will open in Read-only mode. This means I can not make any changes. There are few option, whi…User_U19WZ 52 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum
-
Multiple Compound layouts split by columnHi All, Using Oracle Business Intelligence 12.2.1.4.0 I've been tasked with creating a compound layout (5x performance tiles, one graph, one gauge and one pivot table) w…
-
Week Start Date (Date return) of week and First & Last Date of last weekRespected Members, Can someone please help me with below Query. I want to find out 1- Week start date of any date I pass. Input: 21-April-2021 Result: 18-April-2021 2- L…
-
OBIEE Presentation Variable Not working in FilterRespected Members, Can someone please resolve my issue trying to built MTD report(Date select from prompt): 1- I have Date column "Calendar Date"."Calendar Date" present…
-
Display Pivot Table sections horizontally in 11gHello! This question has been asked, but as far as I can find, never answered. When you set up a pivot table and specify sections, each section of the pivot table is sta…
-
OBIEE 11.1.1.9 - Enterprise Manager Console issueHello everyone, i just completed a brand new installation of the OBIEE 11.1.1.9 on linux. All the services are up and running. I can access the weblogic console and all …
-
Reg: Hrs Metric for Difference Between two dates excluding weekends and HolidaysHi Team, How to calculate the Hrs metric for the Difference Between two dates for business Hrs (between 10 to 5 PM) also excluding weekends and Holidays in OBIEE reports…
-
Is there any file that contains (em / console / analytics) url in domain_home ?I create new domain for OBIEE with 19500 to 19999 ip range i forgot to save config.sh log at the last of my installation . is there any log file that store urls ? i pers…
-
Year and Month Number formatHi team, We have date format column (6/21/2018 7:01:00 AM) we need extract year and month number ( 2018 06) from the date field in obiee RPD level can someone assist. OB…
-
Getting Sample sales Lite obiee 12c rpdhi every one i need sampleSalesLite.rpd i have delete it from my pc its very important for me please give me link or send me that rpd tnx🙏
-
RPD Concurrent DevelopmentHi Team, Any recommendations / documents on how we can setup GitHub or SVN to configure a concurrent development of OBIEE repository? The requirement is, User 1 should b…
-
Reg: Month sorting in OBIEE graphsHi Team, As we have graph in below format for diff years (like 2018 to 2020) it was showing like Alphabetical order, we have prompt to select the data, how to sort the g…
-
OBIEE 12.2.1 Login Via Netscaler Proxyserver To WLS Admin Console Fails with Authentication DeniedLogin Via Netscaler LoadBalancer / Proxyserver To WLS Admin Console Fails With Authentication Denied Problem Description ------------------------------------------------…Martijn Ceelen, iConsultancy, OBIEE Consultant 32 views 1 comment 0 points Most recent by Martijn Ceelen, iConsultancy, OBIEE Consultant Oracle Analytics Forum -
Data Level Security for more than 1K regions belonging to one managerHi Team, I came across a scenario where one manager might be assigned for more than 1K cities. The combination of the cities can be different for each manager, so we can…
-
Reg: Month Chronological OrderHi Everyone, We have Date timestamp field ‘Service_Date’ 4/22/2020 8:01:00 AM and as per the requirement we converted the format into Apr 2020(changes done in RPD level)…