obiee 12c table view, rank column, how to get rid of showing rank in grand total row (last row)

rajk5

Hi Gurus,

i have a simple table report. I created a rank column based on the number of emails.

Issue is OBIEE shows a number in rank column for the "Grand Total" row which is at the bottom and we want to get rid of it. Please share any inputs. Thanks

Gianni Ceresa

Set the "Aggregation Rule" for the 'Rank' column to "none".

rajk5

Hi Gianni,

It did not work, i still see the rank number in Grand total row.

rajk5

HI Gianni,

For the "columns & Measures" in "edit table view" i selected as below so that to show totals of measures for each section.

If i select "none" in below, then i don't have any issue.

Please let know if this is causing the issue. Thanks.

Gianni Ceresa

Could you please post all the details?

As you see me guessing what you don't say and you are (hopefully) doing doesn't seem to work.

Remember we don't see your screen, we have no idea what your analysis is like and therefore it's difficult to figure out if you are doing something special or what else.

rajk5

Hi Gianni,

Please see below screen shots.   2nd screen is the actual report and first screen shows where i selected "after" to totals.

In the 2nd screen shot i want to see totals for all measures, but don't want to see any rank number for the "grand total" row (last row)

Hope now you got what i am saying.

Gianni Ceresa

What is the formula of your "Rank" column? (I believe there isn't nothing confidential there inside)

That analysis is a simple one, right? No union or things like that?

What exact version of OBIEE 12c are you using? (in case it behaves differently yours from mine, that cold also be something to look into)

rajk5

Hi Gianni,

Formula for Rank --    TOPN("FACT"."$ Demand Items TY",10 BY "DIM"."SAP Category")

Its a simple report - no unions

OBIEE version -  12.2.1.4.0

Thanks

Gianni Ceresa

That's the difference ...

You talked about RANK and with the RANK() function it works as said above: you set the aggregation at "none" and no value in the grand total row.

TOPN() has a different behaviour.

If you use RANK() and add a filter on it to be <= 10 doesn't it give you the same result but without a number in the grand total row?

rajk5

Hi Gianni,

As you mentioned, i switched formula from TOPN( ) to RANK( ),  and set the aggregation content on RANK column to "NONE" and applied filter on the report column using presentation variable (because we need the flexibility for users to select top 3 ranks or 5 ranks or 10 ranks etc.

But after this i don't see any rank values at all not just for TOTAL row but all other rows as well.

Any inputs on this behaviour please.. Thx.

Gianni Ceresa

Here things depend on your real model in the RPD. It works fine on a a classical sample, so if your model must not be just a simple "standard" one but there are other factors to keep in mind.