OBIEE11g Golden Rules: RPD-Presentation Layer

First of al the original inspiration for these “Golden Rules” Series are based on the “20 GOLDEN RULES FOR REPOSITORY DESIGN” from the people at Peak Indicators. Kudos to them.

The series contains:

The “rules” is this article are somewhat in random order

This is always a “work in progress” and please feel free to make any suggestions!

Presentation Layer

- Common dimension

When you have multiple Subject Areas, list the common dimensions in the same order  across all the Subject Areas


- Time dimension first:

Since (more...)

Simba previews Cognos8 Analysis Studio accessing Oracle Database OLAP Option cubes

Hot on the heels of support for BusinessObjects Voyager, and in addition to the native Excel 2003/2007/2010 pivot table access, Simba are previewing the same connectivity for Cognos8 Analysis Studio - the dimensionally aware UI in the Cognos BI suite.

Together with the unique SQL access to the same multidimensional (more...)

A first look at OBIEE 11g with Oracle OLAP

For those who missed it, the global launch for the 11g release of the Oracle Business Intelligence Enterprise Edition suite (OBIEE) took place in London on July 7th.

And the fantastic news for Oracle OLAP customers is that OBIEE 11g will work out-of-the-box with Oracle OLAP in almost exactly the (more...)

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

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 [...]

Running OBIEE Oracle By Example Tutorials against a database not called ORCL

I’ve been working with OBIEE for a while now, but I’ve not actually gone through the Oracle By Example tutorials, so I figured it would be a good idea to do that.

I started looking at the first Oracle By Example OBIEE tutorial yesterday and came across an issue with (more...)

OBI Forum Live Second Edition

I’m going to present in the [[|OBI Forum Live]] the next week on the 3th Wednesday of Juny 2009. This second edition is really impressive and as I see that we will have parallel sessions, I’m already very disappointed because I couldn’t assist to all presentations : * Multi-Language Dashboards, [[|John Minkjan]] * Oracle BI [...]

Densification with OBIEE logical Sql (Sparse to dense data)

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

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 To be able to save an Ibot, you must have performed the [[dat:obiee:bi_scheduler:obiee_scheduler_configuration|initial [...]

OBIEE and Apex Integration

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

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

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 ?

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.