Popular Tags
- OTBI 1,473
- Reporting 1,405
- FDI 1,194
- Fusion AI Data Platform 1,038
- Analysis and Data Visualization 1,004
- BI Publisher 874
- Analysis 687
- Oracle Fusion Analytics 611
- Administration 556
- OAC 524
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 419
- Fusion ERP Analytics 409
- BI Publisher Data Models 361
- Security 301
- HCM 279
- BIP 267
- Answers 266
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 245
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Data Connectivity 214
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE
Discussion List
-
Multiple Fact tables for single MeasureHi Everyone, We are having 2 fact tables (Fact_1, fact_2), Fact_1 is having current year sales data and Fact_2 is having historical sales data other than current year an… -
Add a Horizontal Scroll Bar to Dashboard PromptsHello, We have a dashboard prompt that contains multiple user input text boxes and drop down menus. To the right of all that are the apply and reset buttons. Some users …
-
Error when viewing report in PublisherFrom analytics a Publisher report opens and shows an error. Attached image. The same report, from Publisher, shows a different error. Attached image. Does anyone know wh…
-
OBIEE 12C to SAP HANA ODBC Connectivity Issue on SUM FunctionsHi, I hope you all are doing well. Recently we are using SAP HANA DB as a data source for OBIEE 12C environment and are utilizing a third party ODBC driver to achieve th…
-
Prompt before OpeningHello, For one of my dashboard pages, I checked the box for "Prompt before Opening" on the Dashboard Properties window. When the user opens this page, a banner across th…
-
AGO function - culculating dynamic OFFSET with TIMESTAMPDIFFTo solve the problem I thought of using the TIMESTAMPDIFF function in the offset but it doesn't work and I tried various solutions:AGO ("SellOut Measurements (Detail)". …
-
Changing data format for varchar datatypeOne way to change data format to a column with varchar as datatype is to use String functions in a measure in obiee Admin tool and then use it in report. But I need to c…
-
OAC Subject Area IssueHi Experts, @Gianni Ceresa I have 1 fact table and 5 dimensions and in that one is from different database. if I pull 1 fact table and 3 dimension from 1 database and 1 …
-
Is there a way to link to subpages..Currently we can create links from one page in a dashboard to another using the format Is there a way to link to individual subpages?
-
After a Migration from OBIEE into the Oracle Analytics Cloud: Get the dataset migrated too?Hey there, I have recently done a migration with the OBIEE into the oracle analytics cloud. I used the data from the Oracle BIEE 12c SampleApp v607 as use case. There a…
-
Is it possible to change the defaultlocation ofthe file jazn-data.xml in obiee12c to different path?My default location for jazn-data.xml is [Domain_home]/bidata/service_instances/ssi/metadata/authmodel/jazn is it possible to have a path outside of the domain_home to b…
-
OAS 5.9 After Installation obis1 Service not able to StartDear All, I have specific problem with my laptop. I have installed successfully OAS 5.9. After restart some days works all the services, but after 1 month under EM BI Se…
-
OBIEE cross database joinHello, I have two data sources 1)Snowflake 2)Oracle snowflake has 4 tables(2 fact 2 dim) Oracle has 1 dim as per my requirement, I have to join snowflake dim to oracle d…
-
Reg: Bar Graph for TopN and rest of the valuesHi Everyone, As we have no. of sales in vertical axis and rank of the regions in horizontal axis we have to plot the Bar graph. There will be prompt for dynamically sele…
-
How can I fix the data pump export wizard error in the OBIEE 12c Sample Appliance v607?Hey there, I followed the instructions in the link: OBIEE 12c Sample Appliance v607 - Error on starting BI Services in Oracle VM VirtualBox — oracle-tech to start up the…
-
Problems with OBIEE sample app 607I am having troubles downloading the .zip files in the OBIEE sample download page https://www.oracle.com/business-analytics/business-intelligence/technologies/obiee-samp…
-
OBIEE 12c 12.2.1.1.0 - Sample Application v607 unzip errorHi, I'm currently having problems while unzipping the SampleAppv607p-appliance.zip.001. I have tried on two windows machines and even with the previous version (OBIEE 11…
-
Two different aggregation base on one column with two sourcesHi, I have question about aggregation in Oracle BI Administration Tool. I have measure: Numer of policies. And not this column has two logical source table (with union) …
-
Behavior of obiee with respect to generating queryObiee version:12.2.1.2.0 I created an analysis & it generated a backend query .I got both of these from Administartion->Manage sessions Obiee logical query vs db query F…
-
Can we do subtraction for Grand Total in an anlysisVersion:12.2.1.2.0 My requirement is to subtract two sub totals and show it in the analysis. I have 2 account types like Expense,Revenue The grand total should be Total …