Current Date Function in SAC

[former_member645636]

Hi All,

We want to have a filter in our story to take the current date automatically. Whenever I open the story the filter has to take that day's date as filter. Is there any function available in SAC to achieve this.

Regards,

Bhargavi.

[former_member542603 · Accepted solution]

Hi Bhargavi,

- Click on filter under tools.

- Add filter in the filter bar

- Under "Time Filter" select "Current".

- Select the Date Dimension you need to Filter and select "Day" under "Full Period".

This will filter the story for Today's date. Repeat the steps if you have multiple Date Dimensions in the Story.

- Sathya

[former_member411491]

Hi Bhargavi,

At the story level what you can do is to show the current data and Time and the last loaded data and time in the Text box by using dynamic Text functionality, which will indicate the user when the data is refresh last time. So that they can modify the filter accordingly.

If it meets your requirement then well. Otherwise, you can easily achieve it in application designer by writing script.

Steps:

1. Read the Dynamic text box and get the current date using dynamic text function.

2. Apply that filter in particular dimension column in a table.

https://answers.sap.com/questions/12877199/setdimensionfilter-not-working.html

Regards,

SG