Skip to Content

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

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 20, 2019 at 06:42 PM

    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");

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2019 at 08:28 PM

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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.