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 454
- OBIEE 433
- Analytics 403
- 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
-
Is it ok for databases in the Physical Layer to share ODBC connections?Is it ok for databases in the Physical Layer to share ODBC connections? Or should each database in the Physical Layer have it's own ODBC connection built (System DSN)? I… -
Conditional formatting in rtf template on a calculated columnMy code is red Logic: if (sum(todate)/sum(cac)) > 100 then i have to display results in red color. This code works fine with out a calculation like below but not with a …
-
All column values range - how to?Hi! In Prompt we have an option call Include all column values choice in the list. When it's choice then we get's all values, not depend of list that we chose (it's take…
-
How to remove duplicate rows in OBIEE analysisI have an analysis that is producing multiple rows as shown on the attached screenshot and I wanted to know if there is a way to eliminate the duplicate rows. In this ex…
-
-
OBI 11g->12c migration - different aggregation method used (DBMS SQL vs. BI serv aggregation) causinhi, we are just migrating our exisitng 11G OBI instance to 12C (important note: both are still connected to exactly the same 11G database, so literally using same data )…
-
Multiple email's configuration from OBIEE Scheduler ?I've a requirement from my client that I need to send a FIN dashboard page from FIN email id and rest all from default email id how can i achieve this functionality ? Pl…
-
Summary and Detail reports from level based hierarchyHi, i am trying to create action link to detail report from summary report. summary report has level based hierarchy which is 'Ragged and skipped'. i tried different way…
-
How to "execute" a soap request to reloadMetadata() in obiee 12cHi all, Bit out of my depth on this one. I've written some simple batch files to export a bar file from one obiee instance and then import it to another. The last missin…
-
Refreshing user roles in 12cQuite frequently, if I add, delete, or change a group in WLS, then assign that group to a role in Fusion Middleware, any users who are assigned to that WLS group do not …
-
Subquery in OBIEEDear All, I have a requirement where I need to display the value of a measure based on the maximum submit order. Below is the scenario. Here against the invno 469 there …
-
Differences of # of OpportunitiesGood Day, Just want to know what are the differences of the following please in the Facts table: 1. Pipeline Facts.# of Opportunities 2. Pipeline Detail Facts.# of Oppor…
-
Writeback is working on OBIEE 12.2.1.2.0I tried to enable writeback feature on OBIEE 12.2.1.2.0 version but for some reason, it's not working. Any help on this is greatly appreciated.
-
Reg: Prompts ValuesHi All, We have 3 pages with different reports and 3 prompt with same column, value selecting in prompt 1 should show same for prompt 2 but for prompt 3 it as to show de…
-
OBIEE 12c Disaster Recovery optionsHi all, I'm currently undertaking a large effort of work to move our existing users (2000+) from 11g to 12c. As part of this move, I am looking to apply DR. Unfortunatel…
-
obiee 12c how to use (import) SQL Server 2014 stored procedure as data source in RPD physical layerHi Gurus, We are on OBIEE 12c, data source being a sql server 2014 stored procedure. How do we model this in the physical layer of RPD ? Creating a new table, selecting …
-
Migrate Default Data Formats between EnvironmentsIs it possible to migrate default data formats from one environment to another in OBIEE? For example, if I created a default data format for "Financial - Budgetary Contr…
-
display results for all column values for pivot table prompts column in pivot viewi am using obiee 12c. i am trying to display data for all columns values for pivot table prompts column. but when i add column in 'pivot table prompts' by default its ta…
-
How to verify OUI InventoryI was checking the prerequisite for applying WLS Patch 30386660. One of them is to verify the OUI Inventory. I tried the command mentioned here, however its not working …
-
Percentage share based on Grand TotalWe have a report: # of Workers by 4 dimensions: Region, Month, Age Bucket and Gender presented as Pivot table. I would like to calculate Percentage share per Gender for …