nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

how to hide grand total column fake measure column

User_4PJSW

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.

We are wainting your help

Regards,

Find more posts tagged with

Accepted answers

All comments

Joel Acha

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

User_4PJSW

Hi Joel, Thanks for reply,

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

Regards,

Gianni Ceresa

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 Acha

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

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

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 Acha

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

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]

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

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