Hello, I have two parameters which are getting set of values from one data cube and which shows one visualization in dashboard.
On selection of these parameters, I wanted to pass selected parameter value to other datacube having Stored Procedure with selected parameter as input.
I tried to use same hierarchy on both datacubes however my 2nd datacube is not receiving selected parameter value…
There is no any hierarchy in datacube…what is way to troubleshoot this?
Appreciate your support.
pass parameter value from one datacube to another datacube in same dashboard
What kind of filter are you using? Is it a value filter or a textbox filter? If both cubes just have implicit dimensions (i.e. no user hierarchy, like you’re describing), then you’ll want to use a textbox filter as you are attempting to pass a string.
First filter is Value filter as it is loading set of values from MetricSet and second is textbox, I tried second/dependent filter as value filter which is getting set as none when I select 1st filter.