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

how to hide grand total column fake measure column

Received Response
123
Views
14
Comments
User_4PJSW
User_4PJSW Rank 1 - Community Starter
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

Hi,

We have a analysis in obıee 12 c ,and we use one column that contain sting value relevant result of differences between two measures column .I share below column formula.

When We did this our column type change aggregated column so in wiew section this column display in grand total.

how can we hide this column in grand total row?

Also ı share below screenshots.

pastedImage_0.png

pastedImage_1.png

We are wainting your help

Regards,

«1

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    In your screenshot above, change the Aggregation Rule (Totals Row) from Server Determined  to None.

  • User_4PJSW
    User_4PJSW Rank 1 - Community Starter

    Hi Joel, Thanks for reply,

    When I change aggregation rule to none, none of data come in column

    Regards,

  • Gianni Ceresa
    Gianni Ceresa Mod

    What Joel posted perfectly works based on what you described in a standard context.

    If it isn't working for you it's time to do an effort: invest more time in the question, posting all the relevant bits to allows people to give you possible solutions because right now it's 20% of info given and 80% of guessing...

    Remember we don't see your subject areas, we don't have or know your business models: what is obvious and implicit for you needs to be made explicit.

  • Joel
    Joel Rank 8 - Analytics Strategist

    I've just seen that the OP @1000122 mentioned that the column is a "fake measure". From the column formula in the original screenshot, this column doesn't actually appear to be a measure.

  • Gianni Ceresa
    Gianni Ceresa Mod

    When you write a formula involving a measure OBIEE keeps the resulting column as a "measure" type, so that's the expect behaviour if, has OP said, the calculation is done on measures.

    And obviously the totals being the same measures at a different level the calculation of this column still apply there.

    My question would more be: why the aggregation rule is set by default to "Server Determined" ?

    Sounds like weird "measures" already at the RPD level and therefore requires the "Server Determined".

    But well .... just guessing ...

  • User_4PJSW
    User_4PJSW Rank 1 - Community Starter

    Hi Ceresa ,

    'Server determined' is not default option,When  ı try to change data type to char, I test that.

    Also like you said  ,column behave like a measure  because of contain measure column,

    but is it possible not to sum this column ,Or hide grand total of this column?

    Regars,

  • Joel
    Joel Rank 8 - Analytics Strategist

    but from your screenshot, your CAST & CASE statement in your column formula returns a CHAR so what type of aggregation are you trying to do on a CHAR column?

  • User_4PJSW
    User_4PJSW Rank 1 - Community Starter

    Hi,

    I do not want to describe aggregation rule , but when I set the aggregation rule none none of data comes?

    If it is not possible , ıs there a way to hide this grand total value using formating??

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

    I tried to stay away from this thread but it's so weird and convoluted that I need to set some things straight here:

    1.) The logical column which is the basis for that calculation - is it a dimensional attribute in a logical dimension or a measure in a logical fact table or a fact-vase attribute (which would be just wrong to begin with).

    This question is key.

    2.) Have you already tried to implement that logic in the RPD?

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi Christian, (and Gianni, Joel),
    It sounds like he's producing a pivot table.  Setting the aggregation to None in a pivot table has always made my data disappear, too.  For me, it only works as you describe in a Table view.

    Jerry