The following blog is only for history purpose and is not anymore maintained. The whole style is a mess. Sorry.

Category OBIEE

Book Review: OBIEE 11g: A Hands-On Tutorial

Sunday, October 14th, 2012

Since a few months, a new book has appeared in the Oracle Business Intelligence landscape. This is good news for the Oracle BI community because it gives us a new middle of communication and discovery. The book provides a more comprehensive approach that articles or blogs and gives a privileged and direct access with the [...]

OBIEE – Dimension fragmentation design to add an automatic filter with the choice of a column

Saturday, February 13th, 2010

In response to an original Idea of Venkat with this blog entry: [[|Puzzlers – Puzzle 1]] “How do we make BI EE to generate different filters for every column(within a dimension) chosen from Answers?” The idea is when you add the column Channel desc to an answer the query must be automatically filtered. You can [...]

Densification with OBIEE logical Sql (Sparse to dense data)

Tuesday, May 12th, 2009

You may want to view the data in [[analytic:dense_sparse|dense]] form, with rows for all combination of dimension values displayed even when no fact data exist for them. And it’s also the most problem that you have when you work with [[analytic:function_time|time series calculations]] as the [[dat:obiee:presentation_service/obiee_period_to_period_lag_lead_function|lag/lead function]], is that the data are not [[analytic/dense_sparse|dense]]. This [...]

Obiee – How to configure the Mail server of Oracle BI Scheduler/Delivers

Sunday, April 26th, 2009

This article talk about the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as : * the sender address * the smtp server * the smtp port

OBIEE and Apex Integration

Saturday, April 25th, 2009

You may have sometime to change some data in your application. [[ide/apex|Apex]] is a great tool that allow you to develop and deploy rapidly a web based application. Here for our example, we must access to a vendor Apex form to change some values on it. Our goal is to have the report below in [...]

Obiee – Period to period comparison with the analytical function Lag/Lead

Friday, April 17th, 2009

During [[|this thread]] on the Obiee forum, [[|Goran]] point out a solution for a period to period comparison with the analytical function lag. It was time for me to drill down in this analytical function and to compare it with the obiee time function : ago. [[analytic:analytic_functions:analytic_function_lag|lag and lead]] are analytical functions that can be [...]

Obiee – A special subject area to handle the dashboard parameters prompts

Friday, April 17th, 2009

All the prompts in OBIEE are column based prompt. You can’t create a prompt if you don’t select a column. And as it’s the only way to set up a variable for a formula, it’s impossible to bypass this constraint. In our case, we don’t care about the value in the dimension column as we [...]

Obiee – How to suppress detail rows of a master group in a pivot view ?

Friday, April 10th, 2009

You have detail rows of a group in a pivot table that you want suppress,
We have two solutions :
– if you don’t need a total by “promo Category” (by post or by internet), you can create a new dimension with a formula
– if you want a total by “promo Category”, we must perform a cross conditional formatting.

Obiee – How to mix string and number data type in one column and get a sum ?

Thursday, April 9th, 2009

Sometimes, you want to mix number and string data type in one column because you want to send a conditional message :

For instance, :
* if value > 1000, write “To Big” else value
* if value is null, write “No Data” else value

But If you write a function, on this way, you get a error message. Here is how to do to avoid it.

Obiee Cross conditional formatting on a pivot

Monday, April 6th, 2009

OBIEE does not support cross column conditional formatting in Pivot Tables.
For instance, it’s not possible to set a red background of a column based on the value of an other column.

Below is a workaround to be able to perform this kind of formatting and the principal idea is to transform a table view in a pivot table.