Category Archives: Nicolas Gerard
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: [[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 [...]
Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer
[[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_getting_started_11g.jpg|}}]] [[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|Oracle Warehouse Builder 11g: Getting Started by Robert Griesemer]] – ISBN 1847195741 Packt Publishing offer me the chance to review this book and I want to thank them as the author Robert Griesemer because writing a book is never an easy task. The book is a step by step tutorial offering to construct [...]
OBI Forum Live Second Edition
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 [...]
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 [...]
