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!
- Common dimension
When you have multiple Subject Areas, list the common dimensions in the same order across all the Subject Areas
- Time dimension first:
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...)
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...)
In response to an original Idea of Venkat with this blog entry: [[http://www.rittmanmead.com/2010/02/13/oracle-bi-ee-10-1-3-4-1-puzzlers-puzzle-1/|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 [...]
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...)
I’m going to present in the [[http://www.obi-forumlive.nl/|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, [[http://obiee101.blogspot.com|John Minkjan]] * Oracle BI [...]
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 [...]
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 [...]
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 [...]
During [[http://forums.oracle.com/forums/message.jspa?messageID=3403773#3403773|this thread]] on the Obiee forum, [[http://108obiee.blogspot.com/|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 [...]
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 [...]
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.