Gerardnico - gerardnico.com - Gerardnico
General Information:
Latest News:
Book Review: OBIEE 11g: A Hands-On Tutorial 15 Oct 2012 | 01:29 am
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...
OBIEE – Dimension fragmentation design to add an automatic filter with the choice of a column 14 Feb 2010 | 11:29 am
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 genera...
Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer 29 Oct 2009 | 09:17 pm
[[http://www.packtpub.com/getting-started-with-oracle-warehouse-builder-11g?utm_source=gerardnico.com&utm_medium=bookrev&utm_content=blog&utm_campaign=mdb_001193|{{ :book:oracle_warehouse_builder_gett...
OBI Forum Live Second Edition 29 May 2009 | 06:12 am
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 par...
Densification with OBIEE logical Sql (Sparse to dense data) 12 May 2009 | 08:33 pm
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...
Obiee – How to configure the Mail server of Oracle BI Scheduler/Delivers 27 Apr 2009 | 01:47 am
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 serve...
OBIEE and Apex Integration 26 Apr 2009 | 12:55 am
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 acc...
Obiee – Period to period comparison with the analytical function Lag/Lead 18 Apr 2009 | 09:57 am
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 co...
Obiee – A special subject area to handle the dashboard parameters prompts 18 Apr 2009 | 09:40 am
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 co...
Obiee – How to suppress detail rows of a master group in a pivot view ? 10 Apr 2009 | 10:47 pm
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 dimensio...