Display a Blank/Empty Row in Pivot table(Measure Section) in OBIEE 11g

Arjun_Mehta

Hi All Experts ,

I have a requirement in which user want a Blank row to be displayed at the end of the data of Pivot table.

The purpose of this Row is that he wants to download the report into excel and apply some calculations there hence he is in need of blank column.

Please suggest.

Regards

Arjun Mehta

Gianni Ceresa

The requirement sounds a bit "dumb" as in Excel your user just need to go down or right and he has a empty row/column.

You can add a column and give it a NULL value and you have a empty thing.

Of course it depends totally on how your pivot looks like (because a "measure column" will be repeated for all your attributes and you can't create a not existing attribute on the fly without going into weird unions etc.).

Arjun_Mehta

Hi Gianni,

Thanks for your quick inputs.

Users dont want to take the trouble of adding one row on his part every time he want to use formulae there hence he require the additional Black row.

I tried that option you suggested but getting values like this

Cum Demand is the Null column below.

But instead of 3 rows here in below example I just need single row that is at the Total level only.

My Report structure is as follows:

I need this Model Name column after Measure Labels.

Can you suggest any better option to achieve this.

Regards

Arjun Mehta

Gianni Ceresa

I guess you forgot/missed to upload screenshot or something (or they disappeared).

Arjun_Mehta wrote:Users dont want to take the trouble of adding one row on his part every time....

Please tell that user that he is lazy, and a lazy user using the wrong tool for the wrong need is "dangerous" (yes, I say it and mean it )

Arjun_Mehta

Hi Gianni,

Some how the attachments got lost.

Please see them as below.

Cum Demand is the Null column below.

But instead of 3 rows here in below example I just need single row that is at the Total level only.

My Report structure is as follows:

I need this Model Name column after Measure Labels.

Can you suggest any better option to achieve this.

Many Thanks

Arjun Mehta

Gianni Ceresa

That's what I said: a measure column will be replicated for all the attributes ...

And in addition you have the grant total as well.

OBIEE isn't supposed to manage that requirement, your user being too lazy to make a "right click > insert row" isn't enough to justify to build a weird pivot.

A pivot has some basic rules and replicating all the measures for the available attributes is one of these rules.

Can't SmartView help you more for your need?

If the pivot has a fixed size then the problem is solved in 10 seconds (you will refresh data without touching anything else in the Excel file), if the pivot has a dynamic size you can easily manage that with a macro.

Arjun_Mehta

Thanks Gianni for your valuable inputs.

Although I am not sure about the SmartView and its implementation, will work on it.

Share if you have some useful link or Meta link in this matter.

Cheers !!

Arjun

Sherry George

Oracle Support Document 1665793.1 (Where Can I Find Tutorials and Training  For SmartView And OBIEE 11g?)

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1665793.1