Hello,
I am creating an analysis to display a (parent-child) hierarchical column. I am wondering if there is a way to display a prompted member and its children as a default.
I am using selection steps to dinamically select the starting member of the hierarchy based on a prompt value. Consider that the value of such prompt will be assigned through a "Go To URL" Data Action.
My goal is to always display the selected member plus it's level 1 children.
In this image I have the prompt filtering the starting member, and my goal is to always display the selected member and its childer, as show here:
I tried in many ways (different selection steps options, saving report customization) but when I change the starting member, the hierarchy always starts with only the selected member and not his childen. I noticed that with cache and saved customization this happens, but only inside my session and for members that I manually selected and drilled. I would like this to be the standard behaviour for all users.
Has anyone achieved this in OAC? Thanks!