Skip to Content

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

Hi.

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?

Thanks!

Pablo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 11, 2018 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.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 10, 2018 at 03:02 PM

    Hello Pablo - it sounds like you may want to set up something like Cascading Filters; see https://archive.sap.com/documents/docs/DOC-33798 and also this blog https://blogs.sap.com/2017/12/21/mysterious-memberlists-in-lumira-designer/

    Is your data source BW?

    Add comment
    10|10000 characters needed characters exceeded