I have a dashboard built in WAD that contains several charts. There are several data providers and I have created a few simple dropdowns to apply filters. Here lies my problem:
For one specific characteristic, "business unit", in one data provider the InfoObject is "0material_zgbu"(nav attribute of 0material). In another data provider, the InfoObject is "0prft_ctr_zgbu" (nav attribute of 0prft_ctr).
What is the best way to make the dropdown selection apply a filter to both characteristics? Can I force a dropdown to control two characteristics?
Should I create a hidden dropdown to control the 2nd and somehow pass the selected value to it using code?
Any help or advice will be greatly appreciated.
(fyi.... I am using version 2004s)