Thursday, January 3, 2013

OBIEE and tiles without Narrative


Posted: 28 Dec 2012 03:25 AM PST
In the past I wrote about OBIEE and Narrative - simple Tile. In the extended Oracle Business Intelligence Samples you can see a tile sample with presentation based on Pivot table:

How was it done?
I created a basic report:

The last column has no meaning, we just need something to be in the measures part. In my case I decided to have a column of NULLs with space as a label.

So I create a Pivot:

And rearrange it:

Now we need to arrange the Product Type and Revenue so each pair will look like a single tile and hide the measures. The last part is the most interesting: how to hide the leftmost part.
So on the rows properties, remove the Display Heading mark, to loose and extra line:

Then select format values for each column.
First the top - product type:
The important parts are: Border, font size and Background Color (I changed to white).

Something similar can be done with the second column (Revenue):
 Pay attention to the border, no bottom.

And now lets deal with the NULL column at the measure. First Format Headings:
White background color and no Border.



Now the Format Measure Values:

Lets minimize it to size of 1 and close the border at the bottom.

So what is left? We have this ugly area at the left. The bottom part of it was solved when we fixed the measure values heading. Now we need to deal with the rest.
 How do we hide it?
This is a style trick.
Add a Static Text to the Analysis. Mark as Contains HTML and paste the following:

<style>.PTCC {   background-color: white;   border-top: white;   border-left: white;}</style>

Now it's perfect:

Naturally Drills and Navigate options work:
When I drill on the Accessories: