Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE: Adding Sub Totals To value 'Rows' and not on values in measures in PIVOT table

Received Response
467
Views
5
Comments
Mr Merc
Mr Merc Rank 2 - Community Beginner
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

I Have an OBIEE 11g pivot table structured like below. The requirement is to add subtotals to Daily Movement and MTD colunm , without adding it to the Measure

pastedImage_0.png

The Config of the PIvot table is as per below..

pastedImage_3.png

Is this possible in OBIEE ?? The request was to replace and SSRS report where this was possible , but am stuck

Please  HELP

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ummm what are those two *measures* doing in the "Rows" section?! Look to the right. There's a "Measures" section. Measures go there. Measures aren't attributes. And if you use them as attributes...well then you don't get subtotals because - you have guessed it - attributes aren't measures and measures aren't attributes.

    The tool does exactly what you tell it to do.

  • Mr Merc
    Mr Merc Rank 2 - Community Beginner

    HI Christian

    The two columns i have put in the rows section, have filters for the latest day. If i put them in the measures column , then will sum , but repeat for each day , and add blanks.

    I want them to sum the Movements with out repeating for each day, hence i put them there.

    If i put on measures column, it will repeat for each day and that is the problem.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Again: The tool does what it is supposed to do. You are expecting the wrong thing. This isn't Excel where you write any formula or text you want inot any cell on the sheet. This is an HTML-rendered Pivot table, so there actually are conceptual and structural rules that appy.

  • Mr Merc
    Mr Merc Rank 2 - Community Beginner

    Hi ,

    Thanks for the feedback, i understand the concept. Just thought it was possible as it seems to be in SSRS.

    Will look for a work around .. to satisfy the requirement

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    As Christian already stated, this cannot be done like this in OBIEE, the design isn't correct. 

    It seems you want to provide the user with the details so they can validate the figures that are in the attributes section.

    (In my opinion) Properly designed dashboards show only high level data which can be drilled down to see more detail.

    That would be Daily Movement, MTD and Total YTD (not broken down by date) for this report.

    So, put the detailed figures per date in a separate report that opens through an action link from the main 'High level' report.

    HTH, Let me know what you think of this suggestion.