Category Archives: Nicolas Gerard
OBIEE and Apex Integration
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 [...]
Obiee – Period to period comparison with the analytical function Lag/Lead
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 [...]
Obiee – A special subject area to handle the dashboard parameters prompts
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 [...]
Obiee – How to suppress detail rows of a master group in a pivot view ?
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.
Obiee – How to mix string and number data type in one column and get a sum ?
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
But If you write a function, on this way, you get a error message. Here is how to do to avoid it.
