Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Action links on total
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
Answers
-
@Gianni Ceresa @Christian Berg @Robert Angel can you help maybe?
0 -
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?
0 -
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.
0