Action links on total

mmajdana1

Hi i am using OBIEE  12.2.1.2.0

I have a detail report from my base report and I access it via action link, I have an option to enable drill on totals.

However, when i tick this the detailed report gives me correct values and it passes al needed parameters but when i click on the Grand Total level (total of whole analysis) it doesnt pass parrameters it just dont pass 

which stores are included  so i have a detail report for all Stores not the one i have in analysis, but  it gives me  good result for particular store when i click on total for that store.

THX, Matija

mmajdana1

@Gianni Ceresa @Christian Berg @Robert Angel  can you help maybe?

Robert Angel

Hi,

the docs note this; - An action link or conditional action link that is on a displayed total or grand total will not pass a parameter outside of related BI content.

I don't think you can get around this without a fairly extensive workaround, like using a union query to create what looks / feels like a total row, but isn't, but on which you could put your action link and get the benefit of the parameters passing properly.

This is my best suggestion, which I really hate from an architectural perspective - when you resort to a union you are probably going down the wrong road - so totally open to better suggestions, anyone any better ideas for this?

[Deleted User]

Couldn't have said it better.

A second view holding that totals "again" and for exclusive use of navigating somewhere is probably the least horrible solution you can go for. UNION is just bleh.