Monthly Archives: August 2010

OBIEE 11g (11.1.1.x) is ready for download

Standard

Folks,

first of all thanks to forum friends..

Most awaiting OBIEE 11g software is available on oracle site.

Here we go..!!

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

All the best.. !!!

🙂

Advertisements

OBIEE Cross Tab with missing cells data in database (or) Suppressing Null values in OBIEE Pivot

Standard

Hello Folks,

After long time… 🙂

Well, I’m using Pivot view to show some column values across in cross tab. And, some other column in rows part of pivot.

For column and rows combination if measure value present in database it shows, if not it displays blank value (null).

You can’t suppress this null even by using ifnull(measure, 0)

Work around I found:

This will not show zero, instead strikethrough (-), which is acceptable and meaningful.

Here we go..!!

  • Here is scenario based screenshot. Makred cells are null and no data in database for particular row & column combination values.

  • Go to column properties > Conditional Format of measure column
  • Add Action > Measure Column and add the following filter (isnull) as shown

  • In Edit Format window, select and apply Strikethrough from the Effects option dropdown.

  • Here is the result

Blanks are replaced with hyphen ().

Thanks Everybody,

Kishore