SAP Lumira Designer - Script to set 2 filters on a single data source

[MateuszTrojanow]

Hello Experts,

I have a problem with scripting filters for 2 dimensions on a single data source.

If I use the following code:

DS_1.setFilter("First Dimension", "2019");
DS_2.setFilter("Second Dimension", "Product A");

The data source is filter only on the Second Dimension.

The First Dimension shows me all members insted of just "2019" (of course only those which happen to have values for "Product A" on the dimension "Second Dimension").

Is there any other way to perform what I'm looking for?

[MateuszTrojanow]

Hi Michael,

Thank you for your observation. Indeed I made a typo. It should have been the same Data Source in the original post (I don't know how to edit it now though)

DS_1.setFilter("First Dimension", "2019");
DS_2.setFilter("Second Dimension", "Product A");

[former_member628317]

Hi Mateusz

Were you able to solve this issue? Were you able to set two filter dimensions in one Datasource?

[michael_tocik5]

Hi

Not sure if you made a typing mistake in your post but you have 2 Datasources not 1.

DS_1.setFilter("First Dimension", "2019");

DS_2.setFilter("Second Dimension", "Product A");