cancel
Showing results for 
Search instead for 
Did you mean: 

Dinamyc Date in Datasphere Fact view (input parameter)

osudfuegd
Explorer
0 Kudos

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
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

RichT
Explorer

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
Product and Topic Expert
Product and Topic Expert

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
Explorer
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.