Andreas Nobbmann

writing about Oracle Business Intelligence, Hyperion, IBM DB2, IBM Data Warehouse Edition and hopefully more

Vertical Text in OBIEE

Great thing I found out this week. As so often a customer requested something, he wanted a text in a normal Pivot-table to have displayed vertical. While going through the different possibilities in OBIEE it did not come out to be makeable out-of-the-box. So, I looked around in the developers area and found something in the world of CSS. Just one hint before I show you how: this is only running for IE, because Firefox doesn't interpret filters.

 

Create a simple pivot-table and make sure you have the column you want to be displayed in it. When you are in the Pivot result view click on the value formatting of your column and add the following text to your CSS-window :

Writing-mode: tb-rl; filter: flipv fliph;

Your column content could look like that :

image

and your pivot similar to this one :

image

If you now add the above mentioned CSS in your format values screen

image

it looks like that in Microsoft Internet Explorer only.

image

It's not the perfect solution, simply because this is not running for Firefox, but it can help you in some cases, where the customer wants this kind of thing. Of course you can center the text by using the normal CSS- command text-align:center to the above stated CSS.

So long,
Andreas

BTW: as soon as I have a proper solution also for Firefox I'll let you know, am already in discussions with the Firefox-cracks @Trivadis.

Kommentare

Srinivas Malyala sagte:

Nice one, I was suppose to post something like this in my next post but you have grabbed :)

# Juli 17, 2009 8:26

John Minkjan sagte:

Hallo Andreas,

Have a look here:

ccapeng.blogspot.com/.../use-css-to-create-vertical-text.html

regards

John

# Juli 17, 2009 10:09

Andreas Nobbmann sagte:

@Srinivas,

I'm sorry for that, but also I am quite sure there are couple of other things you are faster than me...

@John: thanks, man ! This is great stuff. So for everybody looking for the same solution in Firefox use the link John stated. Thanks again.

So long,

Andreas

# Juli 19, 2009 9:06

Adrian Ward sagte:

Great one Andreas.  this will come in very handy.

# Juli 28, 2009 5:09

Andreas Nobbmann sagte:

Hi Adrian,

thanks, glad you like it.

Have a good one,

Andreas

# Juli 29, 2009 6:31
Kommentar abgeben

(verpflichtend) 

(verpflichtend) 

(optional)

(verpflichtend)