Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FR Studio: How to get/display selected Summary from prompt when column formula is for Descendants

User_JH26PAug 16 2022

Hi, any advice greatly appreciated.
Web FRS 11.1.2.4
All formula tried bring back the last child not the summary level selected, selection covers multiple levels so can't use offset/relative. Tried to add prompt to hidden column for summary only but can't reference this from existing columns.
Haven't been able to use User POV as this shows all accounts and can't be limited to selection?
Example column formula: Descendants of Prompt for Account AND Bottom of hierarchy Account.

Added on Aug 16 2022

#business-intelligence-applications, #business-intelligence-foundation, #hyperion, #hyperion-query-and-reporting, #reports

0 comments

336 views