October 29th, 2009 by gerardnico
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 a complete datawarehouse environment from the capture of the data, through their integration to the construction of a cube.
Continue reading “Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer” …
Tags: book, data integration tool, datawarehouse, OWB
Posted in OWB, Uncategorized | No Comments »
May 28th, 2009 by gerardnico
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 :
Continue reading “OBI Forum Live Second Edition” …
Tags: OBIEE
Posted in Uncategorized | 2 Comments »
May 12th, 2009 by gerardnico
Tags: dense, densification, OBIEE, sparse, sql
Posted in OBIEE | 3 Comments »
April 26th, 2009 by gerardnico
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
Continue reading “Obiee - How to configure the Mail server of Oracle BI Scheduler/Delivers” …
Tags: bi_scheduler, OBIEE, smtp
Posted in OBIEE | No Comments »
April 25th, 2009 by gerardnico
You may have sometime to change some data in your application.
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 with one link by vendor that points to the Apex vendor form and that the Apex form show us the data of the vendor.
Continue reading “OBIEE and Apex Integration” …
Tags: apex, OBIEE
Posted in OBIEE | No Comments »
April 17th, 2009 by gerardnico
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.
lag and lead are analytical functions that can be used to get the value of a column in a previous/next row. More …
Attention : Your data must be dense to have a correct result. See the paragraph with sparse data. If you don't have dense data, you can always use the Obiee Ago Function
Continue reading “Obiee - Period to period comparison with the analytical function Lag/Lead” …
Tags: ago, analytic function, OBIEE, time function
Posted in OBIEE | 1 Comment »
April 17th, 2009 by gerardnico
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 want parameter values as for instance the hierarchy level :
The idea behind the scene is :
-
to create a column which is on the top of a dual view (or skinny table) in the physical layer.
-
to create a dummy business model because BI Server requires us to have a minimal of one logical join.
-
to create a special subject area (presentation catalogue) to separate the functional of the parameters columns
-
to be able to choose this column in order to create one or several others parameter prompts.
The advantages of this solutions are that :
-
as you query a skinny table (or dual view), the performance are very good
-
as you use a column, you can translate in other languages the label of the parameter prompt
-
you can add a parameter value without changing the original dashboard prompt
Continue reading “Obiee - A special subject area to handle the dashboard parameters prompts” …
Tags: dashboard prompt, OBIEE
Posted in OBIEE | 4 Comments »
April 10th, 2009 by gerardnico
You have detail row of a group in a pivot table that you want suppress as this :
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. One each column, we must add this conditional statement.
if "promo category" = internet then suppress the value
Continue reading “Obiee - How to suppress detail rows of a master group in a pivot view ?” …
Tags: css, OBIEE, pivot
Posted in OBIEE | No Comments »
April 9th, 2009 by gerardnico
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
If you write a function, on this way as :
CASE WHEN Measures."Count Passed" IS NULL THEN 'No Data' ELSE Measures."Count Passed" END
You will have this error :
[nQSError: 10058] A general error has occurred. [nQSError: 22027] Union of non-compatible types. (HY000)
SQL Issued: SELECT "Business Rule"."Rule Name", CASE WHEN Measures."Count Passed" IS NULL THEN 'No Data'
ELSE Measures."Count Passed" END, Measures."Count Passed" FROM "MDM Vendor"
nQSError: 10058 A general error has occurred. nQSError: 22027 Union of non-compatible types. (HY000)
If you have already used a software as crystal report, you can't mix of course two types of data in one field but you can have two fields one above the other. It's why I have done in this solution.
But with css, we can go further and have a single column.
How ?
Continue reading “Obiee - How to mix string and number data type in one column and get a sum ?” …
Tags: css, OBIEE
Posted in OBIEE | No Comments »
April 9th, 2009 by gerardnico
When you use Toad with a date and a decode statement, you can have the surprise that two different date format appear. Why ?
First Statement : Date Format : 01/11/95
Second Statement : Date Format : 11-01-95
Where and why we have this difference ?
Continue reading “Second part : I hate Null (null, decode, date and toad)” …
Tags: date, decode, null, toad
Posted in Database | No Comments »