How was it done? I created a basic report: The last column has no meaning, we just need something to be in the measures part. In my case I decided to have a column of NULLs with space as a label. So I create a Pivot: And rearrange it: Now...
Read MoreBottom N function displays the lowest n values of the expression argument from 1 to n, 1 corresponding to the lowest numeric value. The BOTTOMN function operates on the values returned in the result set. A request can contain only one BOTTOMN expression. ...
Read MoreOne of the main problems of Narrative is the lack of drill options, what is called now "Navigate to BI Content". On the other hand, it can be easily achieved using basic scripts and GO URL. I will do a basic example, for more detail on...
Read MoreThere will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside,...
Read MoreBursting is a process of splitting data into blocks, generating documents/output for each block and delivering the documents/output to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a key value (e.g....
Read MoreStep 1: In the Administration page, Goto System Maintenance à Scheduler Configuration. In the Scheduler Configuration page that appears, click Test Connection in the Database Connection section to check if the scheduler is configured properly. This should display the following message indicating the connection was successful. Step 2: In the Administration page, Goto DeliveryàEmail. Click on Add Server. Step 3: Select the report...
Read MoreEvent 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 MoreWhere You Are Now OBIEE 12c has been out for some time, and it seems like most folks are delaying upgrading to OBIEE 12c until the very last minute. Or at least until Oracle decides to put out another major version change of OBIEE, which is understandable. You've...
Read More