Thursday, May 29, 2008

OBIEE Pivot table Measure label

One of those things you have to be reminded of how it works.


If you have this request:

You will get a default table view like this:

Let's put it in a pivot table:

Switch the measure label box with the region:

It becomes even more intressting wen we bring the measure label box to row pane:



Till Next Time

11 comments:

Pablo Bryan said...

And how do you sort a pivot table? for example if you add a total column and you want to sort your rows based on that total? I have been looking how to do this and haven't been able to.

John Minkjan said...

Try playing aroun with a (hidden) TOPN column over your measure:
TOPN((sum("Sales Measures".Dollars by Products.Brand)),1000)

regards

John

dodaka said...

John,
I created a pivot table and I want to set page breaks, because the resultset is returning too many rows. Is there a way to set a page break on the rows? or if not, is there a way to set up a vertical sliding bar on the page?
Thanks in advance.
Aram Dodakian

John Minkjan said...

Try playing around with:
FLOOR(RCOUNT(1) /10)

It not ideal, but it can be a start.

regards

Anonymous said...

John,

Have a stacked pivot table with various dimensions on columns such as month and scenario.

How in the above example can I return actual, budget and variance for one month but only budget for the YTD? I can make the column blank by putting a CASE WHEN in the formula but the pivot still includes the column, even though blank.

Any help appreciated.

Thanks

Unknown said...

see i have a some doubt that i how icreate a levels in the reports can u give me a solution thrugh the quote

Raghu said...

I want to remove the "Blue Cell" which is the column heading for "measure label" want to either put text or want to change background color to white from front and not changing them in the CSS files ,Any Idea?
Thanks

Unknown said...

hello, how do you combine two pivot tables with different filters into one report

Anonymous said...

This is nice john it resolved my problem

Sujana said...

Hi all,

I have a pivot table requirement where I have to display the values and % total of few measures in OBIEE 10g.
Assuming there are 3 measure fields Measure1, Measure2, Measure3 from a fact table, below is the format

_"Measure Name"______|___"Values"______|_____"% Total"_______
< measure1 field name> | | <% Total of measure 1>
< measure2 field name> | | <% Total of measure 2>
< measure3 field name> | | <% Total of measure 3>
__________________________________________________________
Grand Total___________|___Total Value____|________ 100%

First row are the titles of the columns.
First Column gives the measure entity name/label, second and third columns give the corresponding Measure's value and % of Total.
I could get the "Values" column work, but could not get the '% Total' to come up in the Pivot.

Is there a better way of implementing this if not a Pivot?

Anonymous said...

Is there a way to rename different pivot table views we added to composite view.