on ‎2019 Jul 05 11:20 PM
Hello,
Can anyone help with the Date Range slider issue we are experiencing?
We are trying to use the Calendar Day Date Range slider to control the story charts and tables, however whether we chose Fixed or Dynamic, it only allows for data within 1 single year (year 2018).
We know that there is data for multiple years, because when removing the Date Range slider, the charts update and show data for those years – no filters have been applied.
The model is using a Live Data Connection, from BW.
Below are a few screenshots to demonstrate the issue with the Date Range slider:
Figure 1 – shows the chart without any input controls or filters. We have data for multiple years: 2017, 2018, 2019, 2020, 2021, and 2022

Figure 2 – shows the chart with the Date Range slider, where only 2018 appears:

Figure 3 – shows the same chart where the Data Range slider has been replaced with a page input control, and all the years re-appear:

Thank you,
Igli
Request clarification before answering.
Hello Igli,
Do you succeed to do a range with the 0calday from a bex query ?
We have the same issue ?
Thanks a lot for your answer.
Regards
Fabrice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Igli,
when you create a new story with 0CALDAY in the rows and just use the Table, to you see the data for multiple years ?
Is the BW box "up - to date" according to SAP Note 2541557?
Thanks
Ingo Hilgefort, SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ingo,
Thanks for taking the time to look at my question.
We are using 0CALDAY for Calendar Day.
Igli
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Igli,
in BW, what are the InfoObjects that you use for the Calendar Year / Calendar Day ?
Regards
Ingo Hilgefort, SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.