Skip to Content

SAP Lumira Designer 2.1 SP0 - Range of values filter on DS

Mar 10 at 03:01 PM


avatar image


I'm trying to select a range of values on a dataset.

The user should select a date and then I would like to get every day of the week of the selected date.

The ideal way to accomplish this would be to filter the dates by range, I wanted to accomplish this using a DIMENSION_FILTER object but it doesn't let you set the ranges by code.

Any idea up there?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mustafa Bensan Mar 11 at 07:11 AM

Hi Pablo,

As I understand it you would like the user to select a date from which you would like to then derive the first and last days of the week that the selected date falls in, for the purposes of specifying a filter range between the first and last day of the week. Unfortunately, this cannot be achieved with the Dimension Filter component. Furthermore, Lumira Designer 2.1 does not have any built-in date functions that would allow you to calculate the range as desired via scripting. You could try the following approach though:

1. Use the standard Date Field component to allow the user to select a date;

2. Use the Design Studio Community SDK Simple Date Object Component to calculate the desired date range based on the date selected in step 1.



10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Mar 10 at 03:02 PM

Hello Pablo - it sounds like you may want to set up something like Cascading Filters; see and also this blog

Is your data source BW?

10 |10000 characters needed characters left characters exceeded