Diferrent infoobjects, same variable?

[former_member349978]

Is there a way to use a dimension filter selector tied to 0COSTCENTER to also update another data source that uses 0SEND_CCTR (a reference characteristic of 0COSTCENTER)?  I'm using the same hierarchy variable.  I could get all of the 0SEND_CCTR data sources to update when the dimension filter was tied to that, but when I switched it to try to link the filter to the 0COSTCENTER data source, my application died a rather unpleasant death.  Any ideas for how to do the equivalent of a merge/meld variables?

Thanks,

Brian Aldrich

[reiner_hille-doering · Accepted solution]

Hi Brian,

I don't fully umderstand your situation. But Design Studio always merges variables between all data sources in an application. That's the reason for having the setVariableValue API at the APPLICATION object and not at the data source objects.

Reiner.

[former_member349978 · Accepted solution]

Thanks Reiner-

The same variable is used for both 0COSTCENTER and 0SEND_CCTR, but when the value is changed via a dimension filter, only the queries with 0SEND_CCTR are updated.  I haven't been able to force a load of the one query using 0COSTCENTER with the selected value (it keeps the original default value from the first run of the query).  Hope that makes sense...

Brian

[Former Member · Accepted solution]

Hi Brian,

Here is my understanding of you problem:

You have more than 1 Data source.

In some, you have 0COSTCENTER and in some you have 0SEND_CCTR and the hierarchy used in both of them is same.

Now when you apply a dimension filter on 0SEND_CCTR, you want the 0COSTCENTER to be filtered with the same value and this should happen across all the data sources.

For this, as far as i know, there is no standard way. But why dont you use a List Box instead of Dimension filter and write script on its On select property. With a mix of setFilter() on the data sources and getSelectedValue() of List box you can achieve your requirement.

DS_1.setFilter("0COSTCENTER", LISTBOX1.getSelectedValue());

DS_1.setFilter("0SEND_CCTR", LISTBOX1.getSelectedValue());

DS_2.setFilter("0COSTCENTER", LISTBOX1.getSelectedValue());

DS_2.setFilter("0SEND_CCTR", LISTBOX1.getSelectedValue());

DS_3.setFilter("0COSTCENTER", LISTBOX1.getSelectedValue());

DS_3.setFilter("0SEND_CCTR", LISTBOX1.getSelectedValue());

This shall work. I know, this is not a straight forward solution but this is the only workaround which comes in my mind.

Regards,

Piyush