Union, UNION ALL and Intersect in OBIEE11g Some times the data model does not allow you to create a single query to get the results you need. then we are forced to do a Union. (actually they are 4 possible operations Union, Union All, Minus and...
Read More
Evaluate() Function in OBIEE to Embedded DB Functions This Evaluate functions (since version 10.1.3.3) enables users and administrators to create more powerful reports by directly calling Database functions in OBIEE from: Either By Oracle BI Answers. OR by using a Logical column (in the Logical Table...
Read More
Conversion Functions The conversion functions convert a value from one form to another. You can also use the VALUEOF function in a filter to reference the value of an Oracle BI system variable. Functions include: CAST CHOOSE IFNULL INDEXCOL TO_DATETIME VALUEOF CAST This function changes...
Read More
Version 11.1.9.0 There is a great new feature introduced with Oracle BI 11.1.9 which allows report developers to overcome issues with "non-conformed" dimensions. A non-conformed dimension is where you add an attribute to an analysis which does not logically relate to all the facts. Take this example, here we have...
Read More
Variables used to hold a value at any point of time. In OBIEE, there are 4 different types of variables. They are 1. Repository Variables 2. Session Variables 3. Presentation Variables 4. Request Variables Initialization block: Initialization block is used for assigning a value to a variable.With the help of initialization...
Read More
Selecting columns dynamically" saga, you can create a set of prompts where each prompt controls a column and enables the user to select the column formula or decide not to show it at all. Something like this: But the users might ask you to have a single...
Read More
In previous post I talked about column selectors. They are not enough in complex cases, for example: Single selection of columns for several reports. Using the same column selection in several columns of the same analysis. Dependency between selection of columns (for example, I can...
Read MoreYou can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing data environment. A variable has a single value at any point in time. Variables can be used instead of literals or constants in the...
Read MoreIn this topic, you learn how to create an analysis with a Pivot Table view, format, add a calculated column to a pivot table, add a Gauze view, and create a master-detail linking. You also learn how to filter your results using Selection Steps in...
Read MoreYou create a Narrative view to provide information such as context, explanatory text, or extended descriptions along with column values for an analysis. You can include values from attribute, hierarchical, and measure columns. If you want to include hierarchy levels in a Narrative view, use...
Read More