Schedule Run Controls

[marijnbax2]

Hi All,

Is it possible to schedule the controls (validations) to run (as part of a Data Manager Package?)

Regards, Marijn

[former_member186338 · Accepted solution]

Hi Marijn,

If you are talking about *RUN_PROGRAM VALIDATION then you can schedule DM package with script logic as any other DM package...

Vadim

[marijnbax2 · Accepted solution]

Hi Vadim,

Thanks. I was not aware of this program. However, it's not working. We are on 10 NW. Is running this program similar to clicking the "run controls" button in the controls monitor in the web?

Script: Called CONTROLS.LGF

*RUN_PROGRAM VALIDATION

CATEGORY = %CATEGORY_SET%

CURRENCY = %CURRENCY_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY = %ENT_BAS%]

*ENDRUN_PROGRAM

(these settings are similar to our consolidation / copy opening etc.)

The package error I'm getting is:

/CPMB/MODIFY completed in 0 seconds

/CPMB/VALIDATIONS_LOGIC completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

SELECTION = /BAT_STAT/IFRS/PRIVATEPUBLICATIONS/98908157/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|ACTUAL|DIMENSION:CURRENCY|LC|DIMENSION:ENTITY|AU11|DIMENSION:TIME|2015.12

[Message]

--------------------------------------------------------------

RUN_LOGIC:Business rules are not available

model: IFRS. Package status: ERROR

Package is configured as

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")

TASK(/CPMB/VALIDATIONS_LOGIC,SUSER,%USER%)

TASK(/CPMB/VALIDATIONS_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/VALIDATIONS_LOGIC,SAPP,%APP%)

TASK(/CPMB/VALIDATIONS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/VALIDATIONS_LOGIC,LOGICFILENAME,CONTROLS.LGF)

Do you have any ideas on what could be wrong?

Thanks. Marijn

[former_member186338 · Accepted solution]

I haven't use it myself

But strange line:

OTHER = [ENTITY = %ENT_BAS%]

What do you mean by %ENT_BAS%??

What are your real dimensions names?

[marijnbax2 · Accepted solution]

Well spotted! 

forgot to copy

*XDIM_MEMBERSET ENTITY AS %ENT_BAS% = BAS(%ENTITY_SET%)

but it's still not working. I'll have a play around. Thanks for pointing me in the right direction.

Marijn

[former_member186338 · Accepted solution]

And you select ENTITY|AU11? Already a base member...

[marijnbax2 · Accepted solution]

Yes. but this normally does not matter. A base level member of a base level member is still a base level member 🙂

I have tried to run it for the parent just to be sure but it still errors.

After doing a bit more research it seems that this program has been made obsolete in NW V10.

[former_member186338 · Accepted solution]

"A base level member of a base level member is still a base level member :-)" - in past it was not correct, but now - yes

About chains - you see just a generic chain to run any script logic! You can use DEFAULT_FORMULAS instead... But the PROGRAM VALIDATION is referenced in help and has to be valid.