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 More1. To change Brand Name (Next to Oracle Logo) on the Business Intelligence home page , Alter kmsgHeaderBIBrandName attribute of productmessages.xml file under <Middleware_Home>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages. 2. To change OBIEE 11G browser TitleTo change the OBIEE 11G browser Title name to your custom text Open productmessages.xml from <Middleware_Home>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages. Search for kmsgProductPortalattribute and change its value with your custom...
Read MoreWe can open any sites or drill down report from our dashboard page by clicking on data value of report. Here is the original JavaScript for it… <script language="javascript" type="text/javascript"> <!-- function popitup(url) { newwindow=window.open(url,'name','height=200,width=150'); if (window.focus) {newwindow.focus()} return false; } // --> </script> Then, you link to it by: <a href="popupex.html" onclick="return popitup('popupex.html')" >Link to...
Read MoreRecently I came across a customer requirement to allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly’ or ‘Monthly’ and the appropriate sections of a dashboard would be shown. To achieve this I...
Read MoreOne of the interesting attributes that OBIEE provides is the facility to enable users to add/update data back to the database. The user can have a column for which values can be entered in the user interface (UI) section on their platform and this can...
Read More