Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
182
Views
7
Comments
Arjun_Mehta
Arjun_Mehta Rank 1 - Community Starter

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

Answers

  • 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
    Arjun_Mehta Rank 1 - Community Starter

    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

  • 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
    Arjun_Mehta Rank 1 - Community Starter

    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.

    pastedImage_1.png

    My Report structure is as follows:

    I need this Model Name column after Measure Labels.

    Can you suggest any better option to achieve this.

    pastedImage_0.png

    Many Thanks

    Arjun Mehta

  • 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
    Arjun_Mehta Rank 1 - Community Starter

    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
    Sherry George Rank 7 - Analytics Coach

    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