Need help on SAC Parameters for date selection in Data Action

[Sacbiconsultant]

Hi SAC Experts,

Need your help to know how to Create Date "Parameter", where User could select the Year, that would automatically select all the Periods underneath it automatically.

At the moment we created a Parameter however, it does not allow us to select at one go instead one after the other.

Regards,

Sacbiconsultant

[thomas_beck]

Hi @Sacbiconsultant 

You can create a parameter as follows to be able to select any level in the dimension hierarchy e.g. year level:

During execution, users can then select the respective year:

 The parameter can then be used in all Data Action Steps. For Advanced Formulars, as they operate on leaf-level, it is usually necessary to transfer the node (here year level) to the respective leaves:

 For a full reference of Advanced Formula syntax, check https://help.sap.com/doc/5516580733124039b673c530125771b3/2024.15/en-US/index.html#BASEMEMBER

Hope this does help!