Skip to Content
0

FIlter Dimension based on another datasource

Apr 28, 2017 at 05:29 AM

33

avatar image

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

ds.jpg (12.8 kB)
10 |10000 characters needed characters left characters exceeded

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.

0

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nikhil Bhondave Apr 28, 2017 at 11:32 AM
0

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 .

Share
10 |10000 characters needed characters left characters exceeded