Dinamyc Date in Datasphere Fact view (input parameter)

[osudfuegd]

Hello SAP community!

I am fairly new in Datasphere.

Is there any way in a graphical fact view to select dinamically a today's date instead to have a default-fixed value?

Despite, I know that in the analytical mode it is possible to map a date to a date picker; I would like this date to not be choosen by the user and to be dinamically calculated as I said.

Thank you!

[Lee]

Hi Cristina

Have you tried with the usage of Time dimensions set up in Space Mgmt and it is reusable in multiple stories/models and allows for enriching the models with granularity on Days, months , years etc.

Regards

Leena Gopinath

[RichT]

If you don't want the user to select the date then you would remove the input parameter and create a dynamic where clause using CURRENT_DATE()

[cardoso]

Hi osudfuegd,

You can use function CURRENT_DATE() in the graphical view.
Use it in calculated columns or Input parameters as you require.

BR.

[osudfuegd]

Thanks Ismael!

It was superhelpful.

Link with this; Is this current date be displayed as the default value in a date picker?

Many Thanks!

[cardoso]

Hi osudfuegd,

In my example there is no pick (I didn't use Input Parameter but just a plain calculated column), but definitely you can play around and adjust on your needs.

BR.