OBIEE: Return only one record in a one-to-many relationship
I have a one-to-many relationship between two tables. But when I create my OBIEE analysis, I only want to return the most recent record from the second table. For example: Table1: Employees. Table2: Help Desk Tickets. I want to create an analysis that lists only the most recent help desk ticket for a given employee. A basic SQL statement works ...
The OBIEE Equivalent of Countif or FIlter on Duplicates
"Make sure you have server complex aggregate on this, a lot of the time the result of case statements fails because OBIEE tries to evaluate AFTER aggregation" How do I toggle this setting on? "Btw, the case statement was your addition, I actually meant to put this in columns and then reference one column in the condition of the other column ...
IF Statement in OBIEE — Oracle Analytics - Oracle Community
However one requirement is to have a report that returns a code in place of the department name. For example my report will return Human Resources and Finance for department, but my reporting requirement is to return 11 for Human resources and 12 for Finance. Is this something that can be done in OBIEE via an IF statement. E.g.
OBIEE - Best practice for Lookups in Business Layer
Good morning, In the current development of the Business Layer (OBIEE 12c) for some dimensions and facts tables, we have a question about the lookup columns. New Oracle Analytics Data Visualization Challenge Register today to the Oracle Analytics Data Visualization Challenge starting in February 2025
Fact Table Selection for Multiple stars in OBIEE
Thank you for the quick response. I completely understand that OBIEE is taking the optimum path, but is it possible to make it choose the Implicit fact table column wherever possible in scenarios where non conformed dimensions are present along with other fact table columns as well. Example : Dim1, Fact1, Dim2
How to create Percent of total in OBIEE — Oracle Analytics
Creating your measure which just gives 1 for shipped late, 0 otherwise (simplified) as a PHYSICAL calculation will force OBIEE to do the logic FIRST and aggregate second. This is one of the crucial factors. Create your measure which counts pinning it at the total level on the dimension hierarchy that you want it to be computed - i.e.
OBIEE/ODI compatibility on Redhat linux RHEL 8.6
2022年10月15日 · System Requirements and Supported Platforms for Oracle Business Intelligence Enterprise Edition 12c (12.2.1.4.0)
How to create AND OR condition in obiee 11g filters.
Try to set real values in the filter instead of "is prompted", if you don't protect the filter OBIEE will anyway replace it with the value. So try setting default filters with conditions which are impossible, so you turn the (condition on "Processed Date") OR TRUE into (condition on "Processed Date") OR FALSE which will be simplified by just ...
OBIEE: How can I keep multiple filters "on/off" when creating an ...
Hello Experts, I am new to Oracle BIEE, we have version: 11.1.1.9.5 installed - when creating Analysis from Subject Areas, I like to design one report to serve many purposes.
OBIEE - static text view to display presentation variable
OBIEE 12.2.1.2.0. Creating report. I have added formula in the column: @{variable_name}{"Folder"."Dimension"} Now I would like to display it in Static text. Setting@{variable_name} do not work. Is it possible to display presentation variable from report column in Static text view? Or it will work only for variables from prompt?