The following blog is only for history purpose and is not anymore maintained. The whole style is a mess. Sorry.

Posts Tagged ‘css’

Obiee – How to suppress detail rows of a master group in a pivot view ?

Friday, April 10th, 2009

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 ?

Thursday, April 9th, 2009

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.