Cloud based BI tools have become increasing popular in recent years especially among small and medium enterprises. The amount of data churns out from enterprises has overwhelmed in past decade or so, turning such swatches of data into useable information is pivotal for any enterprise....
Read MoreCreate Unifier Domain Click Start > Oracle >Configuration Wizard Replace “base_domain” with “unifier” and click next Enter name and password > Next Select Production > Next Select Administration Server > Next Leave Server Name as “AdminServer” Change Listen Port if it need to be changed. Once 100% then click Next This will start...
Read More
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 More