Event Triggers in BI Publisher 11g give the facility to call a function in Oracle either before or after a data set is refreshed. The function must return a boolean (true/false), and if it returns false the data model will abort execution. In this article I...
Read MoreEvent triggers in BI Publisher allow code to interact with the database at run-time. Typically, they are used to perform any required pre- or post-processing on the data, perhaps checking data is valid, confirming security privileges, setting languages, updating ‘printed’ flags in tables or may...
Read MoreSomething came up this week that I was surprised hadn’t come up before. And I was looking around thinking there must be an obvious way to do this but I couldn’t find it. The idea was to use a single report that could be sent to...
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
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
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 MoreOpen localhost:7002/analytics Catalog > CD Analysis > Dashboard > Unarchive Select setting like below Test Dashbaord has populated If any answer not appearing than follow below Is any Answer showing Breakdown sign –in my case it is all ok. In case of breakdown remove...
Read More