YTD and Delivered Variables

[Former Member]

Can anyone give their experience and advice on the below questions.

We need to see data, ie sales, regarding YTD. We want to publish these reports via Information Broadcasting. So we have to utilize exit variables that can calculate the range without user intervention.

For example, if we are dealing with Fiscal Year/Period there is 0FYTCFP (Cumulated up to current fiscal year/period). This variable denotes an interval from period 1 of the current fiscal year to the current fiscal year period.

If we use this variable, essentially all we have to do is activate this variable and include it in the query definition (filter)? Can someone verify this for me?

Another example is if we are dealing with Calendar Month then there is 0CYTCM (Cumulated up to current month). This variable denotes an interval from month 1 of the current calendar year to the current calendar month.

In this case, would you do the same as mentioned above for activating and placing in query definition?

Thank you

[edwin_harpino · Accepted solution]

hi Mark,

yes you can use that variables in your query,

and you mean how to activate the variables from business content ? rsa1->business content->left panel 'object types', middle panel choose query elements->variables, choose that 2 variables and 'transfer' and install.

hope this helps.

[former_member188975]

Hi Mark,

You are correct. Once the variables have been activated, you can drag the relevant char into the query definition (filter, free chars or rows - as per reqt) and restrict them with the variable.

Hope this helps...