SAP Design Studio: adjust data range

[system]

Hi,

is it possible to adjust the data range inside SAP Design Studio? I have the following problem:

I get a lot of data by a query (Bex). For example: production output per week. So, the result looks like this:

Do i have to adjust the query or could i change the selection inside Design Studio? For example: Just show me the last 10 weeks based on the current week.

---

Robert1980 (BOB member since 2015-05-28)

[system]

Hi,

You can set a filter on your datasource.

DS_1.setFilterExt("0FISCPER", "008.2014 - 03.2015");

To get only the 2 last month, you’ll need some code.
To get today’s date:

APPLICATION.getInfo().dateNowInternalFormat;

Another way is to use an exit client variable in your bex query (CMOD transaction).

---

Fylim (BOB member since 2015-08-20)