Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 453
- OBIEE 433
- Analytics 402
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Cloud and Server
Ask questions in the Oracle Analytics Cloud and Server forum to get immediate help from peers and experts. Collaborate on best practices and dive into discussions around Data, Analytics and AI.
Discussion List
-
RPD. CAST in BMMHi, What is wrong with this formula: CASE WHEN "WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" = 999 THEN 'Not Rated' ELSE CAST("WORKFORCE".""."HRDWH"."DimRating_MD"."… -
Warnings while Starting OBIEE after upgrade to OBIEE 12.2.1.4.0.Hi All, We upgraded to OBIEE 12.2.1.4.0 from 12.2.1.1.0. After upgrade, services are getting started and users are able to access OBIEE. But we notice few warnings while…
-
How do I calculate the pYTD (previous year to date) value?Hi, I'm using Oracle Business Intelligence 12.2.1.0.0 and I'm struggling to calculate the pYTD. I've managed to get the YTD value using ToDate("Measures"."Revenue", "Tim…
-
How to rotate the obis1-query logWe are troubleshooting some queries in OBIEE and our obis1-query.log is reaching 100MB. Is there a way to archive/rotate this log manually? thanks Dan University of Pitt…
-
Obiee 12c Repository Variable Refresh ProblemHi, We use following obiee version in our company. Our problem: repository variables is not updated automatically. This is not for all days but some days. For example, t…
-
Unknown User Principal found: authenticated-roleOBIEE: 12.2.1.3.0 (Build BIPS-20170820114118 64-bit) OS: Linux 3.10.0-862.11.6.el7.x86_64 #1 SMP x86_64 x86_64 x86_64 GNU/Linux (i.e. RHEL 7) Out-of-place upgrade from 1…
-
OBIEE 12c: DB Repository migration from 11g to 12cHi guys, fist of all I want to state my versions I am using for the upcoming scenario / question: OBIEE: Version 12.2.1.1.0 Oracle Essbase: Version 11.1.2.4.008.28 In th…
-
OBIEE 12c: Substring Dashboard promptHi guys, fist of all I want to state my versions I am using for the upcoming scenario / question: OBIEE: Version 12.2.1.1.0 OBI Administration Tool: Version 12.2.1.1.0 O…
-
column fx based other column filterHi Every One, Below is the scenario which i need to implement in Obiee. Query : select c1,c2,(select c3 from t3 where t1.c1='1' and t3.c5='s' and t1.c2=t3.c2) as C3, fro…
-
Data Lineage in OBIEE 12.2.1.4.0Hello Experts, We have OBIEE 12.2.1.4.0 installed on RHEL 7.3. We are trying to achieve Data Lineage to track which DB column is used where (report/dashboard) and to als…
-
How to mimic an existing RPD file?Dear Experts, We have two companies, one of them has an existing rpd file. We need to create the same like rpd, with some modification of course to be addressed later, i…
-
OBIEE missing action link optionI am using obiee 11.1.1.9 on Windows OS. Till yesterday I was able to add a new action link "Navigate to BI Content" using column property in analysis criteria tab. But …
-
EXECUTE DIRECT DATABASE REQUESTSHi Folks, Is 'EXECUTE DIRECT DATABASE REQUESTS' has been deprecated for BI ADMINISTRATOR ROLE? If yes, then what are the alternatives for accessing the DB directly? Than…
-
Cache Variable in obiee 12cHello, We are using OBIEE 12c and I created an analytic report. It has dashboard prompts. I did not enter or set any variable in the prefix section in the advanced tab. …
-
How can we restrict a user to write only numbers in the text fields in obiee 12c reports?How can we restrict a user to write only numbers in the text fields in obiee 12c reports?
-
Can we perform custom calculations on top of the Pivot view in OBIEE?Requirement is to calculate Residual trend for customer’s i.e. % of customer remaining in each month: Row LabelsJul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17(blank)Grand To…
-
Level based measure query formation issueCreated a level based measure which is present in two logical hierarchies when this level based measure is used in report along with some columns which only belongs to o…
-
Logical sql of a analysis of presentation server in OBIEE 12.2.1.4When an analysis is created in OBIEE, then it goes to presentation server, generates a logical sql , generates a hash key to check whether the result is in presentation …
-
OBIEE11g Agent delivery row level security problemHi everyone, I am using OBIEE 11.1.1.9.0 on windows. I have to configure Agents to send data to email to a group of users in monthly schedule. I have 60 users in BI Publ…
-
function absolute in calculated itemIm trying to calculated the percentage difference between two columns using a calculated item ($2-$1)/$2 but it fails when both values are less than 0. Is there a way to…