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 12c Running Sum of Total in Pivot Table view

Received Response
42
Views
2
Comments
PinakiB- Oracle-Oracle
PinakiB- Oracle-Oracle Rank 3 - Community Apprentice
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

Hi Team,

Customer needs to calculate "Running Sum of Total " in Pivot table view in OBIEE 12c. To get this they tried a lot, but unable to know how to build it. We checked it internally, but didn't find any way as of now. Is there any way to build this metric?

Customer needs to build "Running Sum Total"  in Pivot Table view in OBIEE (please check the attached sheet with yellow background).

Answers

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

    Short answer: No you can't have that "yellow line"

    Longer answer: That's not how pivot tables work. OBI calculates and renders whole grids of data in tables and pivots. Not cells. That's what you have BIP and Excel for. It's an analytical tool. Not a GUI-tricking and cell-calculating reporting thing.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Your yellow line is YTD measure (level-based at Total Product) ... as has been said this isn't how a pivot table works. 

    Can you show the YTD value by month? absolutely!  A teeny bit of modeling and you'l have it.

    Whomever mocked up that grid needs a little more knowledge of how the tool works before accepting requirements (if this indeed was an actual requirement).