FIlter Dimension based on another datasource

[former_member272256]

Hi Experts,
I need your help to find a solution for my requirement.

I need to filter a datasource based on it dimension. The values that need to be filtered has be extracted from another datasource.

eg: I two data source were I need to filter DS_2 based on the values in DS_1.

Now we need to pass DS_1 Names to DS_2 filter.

After Filter we need to get the DS_2 Names are A,B,C,D,E,F.

Please help me on this. Let me know if I am not clear with requirement.

Thanks!

Regards,

Ramesh Jothimani

[MustafaBensan]

Hi Ramesh,

A couple of questions:

1. What type of data sources are you using, BW, HANA or Universe?

2. Are you applying any filters to DS_1?

Regards,

Mustafa.

[former_member272256]

Hi Mustafa,

DS is based on BEx query. We don't have any filter for DS_1.
Simply we need to retrieve the Names from DS_1 and need to filter DS_2.

Thanks!

Regards,

Ramesh Jothimani

[Former Member]

Hi,

Edit Initial View 'DS_1'

Drag and drop Dimension "NAME" in filter area .

Right click on "NAME" in filter area Filter Members --> Values with Posted Data .

On "Start Up" write below code .

var Dim1_Values = DS_1.getMembers("NAME", 1000);

DS_2.setFilter("NAME", Dim1_Values);

It worked for my Datasource .