How to replace script function for calendar week

Hello,

in v11 we use an AppStudio Script to define the current calendar week and write this value into the variable gv_DWEEK. Here the function of the script in v11:

if datepart("ww",date(),2,2) < 10 then
SetGlobalVariable "gv_DWEEK", "[DWEEK].[All].[0"&datepart("ww",date(),2,2)&"]"
else
SetGlobalVariable "gv_DWEEK", "[DWEEK].[All].["&datepart("ww",date(),2,2)&"]"
end if

In v12 scripting is no longer available, so we have to replace this function. How can I do that? Do I need an APE script, or is this something that can be done directly in the report action?

Best regards, Daniela

Find more posts tagged with

Infor EPM Discussions

Comments

florian-konath

Hi Daniela,

I suppose the week should be set while opening the report or after pressing a button. Thus you can either use a report or the button action with the following formula, since at least in v11 there is no possibility to derive the CW automatically:

="[DWEEK].[All].["&RIGHT("00"&(TODAY()-DATE(YEAR(TODAY()); 1; 1)-WEEKDAY(TODAY();2)+WEEKDAY(DATE(YEAR(TODAY()); 1; 1);2))/7+IF(WEEKDAY(DATE(YEAR(TODAY()); 1; 4);2)-WEEKDAY(DATE(YEAR(TODAY()); 1; 1);2)>0;1;0);2)&"]"

This is based on the ISO logic that CW 1 includes the 4th of January. Now it would give you CW 0 for the first two days in January 2022, I don't know how your model handles this. In v12 you could also use stepwise calculation while relying on the previous results for variables.

Best regards,

Florian

Nick Gladkov

I would add that we can now put "[DWEEK].[All].["&RIGHT("00"&(TODAY()-DATE(YEAR(TODAY()); 1; 1)-WEEKDAY(TODAY();2)+WEEKDAY(DATE(YEAR(TODAY()); 1; 1);2))/7+IF(WEEKDAY(DATE(YEAR(TODAY()); 1; 4);2)-WEEKDAY(DATE(YEAR(TODAY()); 1; 1);2)>0;1;0);2)&"]"

into custom function like FindWeekFunction() and use a short version everywhere where it is needed.

gottesheim-daniela

Hello Florian,

thanks for the formula. I've already tried it and it works as expected.

Best regards, Daniela

gottesheim-daniela

Hello Nick,

thanks for the input to store it as a custom function. At the moment I need the variable to be initialized just once on our welcome page. But I'll keep it in mind for further/similar requirements.

Best regards, Daniela

Filip Kosnac

Hallo Daniela,
if this week number calculation is initialized when user logs in, you could also set the variable as log-on action via right-click menu on the report catalog, instead of report load action on a dedicated report, as i assume, this variable does not need to change regularly during the session user is logged in. Even if, then you can update the variable via some action on the report.

0904080939293831.xls

gottesheim-daniela

Hello Filip,

thanks for the input. I didn't know that actions can be defined directly for an alias. This would be a good way to initialize variables indipendent from a report.

Best regards, Daniela

HRT - IDM Integration_ Early Adopter biweekly calls-20241001_110200-Meeting Recording.mp4

gottesheim-daniela

Hello Filip,

thanks for the input. I didn't know that it is possible to define actions directly on the alias, but that would be quite helpful to initialize variables indipendent from a report.

Best regards, Daniela

Gelangens_Anlage_Entwurf.pdf

Copyright © 2025 Infor. All rights reserved.