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 also found a copy of this entry in the wiki : OBIEE - Dimension fragmentation design to add an automatic filter with the choice of a column
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” …
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 :
You may want to view the data in 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 time series calculations as the lag/lead function, is that the data are not dense.
This article show the capability of the OBIEE logical sql to densify the data. To know more about the Obiee logical Sql, you can also read the good post of Venkatakrishnan.
The sample example come from this article : Database - Data Densification (sparse to dense data) and the sql below is a translation in OBIEE logical sql of the densification solution with cross and right outer join.
Continue reading “Densification with OBIEE logical Sql (Sparse to dense data)” …
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 :
Continue reading “Obiee - How to configure the Mail server of Oracle BI Scheduler/Delivers” …
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.
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” …
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 :
The advantages of this solutions are that :
Continue reading “Obiee - A special subject area to handle the dashboard parameters prompts” …
You have detail row of a group in a pivot table that you want suppress as this :
We have two solutions :
if "promo category" = internet then suppress the value
Continue reading “Obiee - How to suppress detail rows of a master group in a pivot view ?” …
Sometimes, you want to mix number and string data type in one column because you want to send a conditional message :
For instance, :
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 ?” …
GerardNico.com is proudly powered by
DokuWiki and
WordPress
Entries (RSS)
and Comments (RSS).
18 queries. 2.861 seconds.
Copirat Nicolas GERARD | 2008 - 2009
| Valid XHTML (Except Aria)
| XFN | 
|
| Log in