Patch Name wls1036_upgrade_generic.jar Reference https://www.youtube.com/watch?v=Be6hrYTANQE Just Click Next and Next MAKE SURE ALL OBIEE SERVICES ARE DOWN AND CLOSED IN PROCESS Open CMD prompt C:MiddlewareOracle_BI1jdkbinjava –jar “c:/10_3_6.jar” [counter style="style2" number="1" text="Counter"]...
Read More
Where are these images located? All images are stored in the 'browser look and feel plus' folder of the BI Server, you've probably seen this notated as 's_bflap'. This folder exists in two locations and it is critical that any image you upload be housed in...
Read More
OBIEE Reports/ Dashboards/Analysis Export to Unix/Windows/FTP Procedure 1 using EjB: Oracle Business Intelligence 11g, doesn’t provide any built-in method to allow Agent to automatically export/archive OBIEE11g content (Entire Dashboard(or) Dashboard Page(or) Analysis(or) Conditional Report of Agent(or) even Briefing Book) to file system, although this can be done...
Read MoreBI Publisher with JFreeChart an Open Source plotting API in order to generate plots that are not provided by BI-Publisher such as the Gantt chart type. The main steps are as follows: 1) Create the BIP data model: as an example I used the sample Gantt data mentioned...
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
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