Skip to Content

FIlter Dimension based on another datasource

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 28, 2017 at 11:32 AM

    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 .

    Add comment
    10|10000 characters needed characters exceeded