cancel
Showing results for 
Search instead for 
Did you mean: 

Executing MAcro in Background

Former Member
0 Kudos

Hi,

We need to execute the macro in the background mode. For this we have defined a activity, assigned the activity in the Planning Job . When i schdule the job in the background the job gets completed, Macro is executed but the output of the macro calculation is not saved.

I get the message in the spool request of the job

Macro xxxxx executed

Data not saved.

How to overcome this ? When the macro is executed in the background mode the data should be saved . Is ther eany possibilities ?

Also let us know is it a mandatory condition that macro has to be executed only in a batch view in the background mode ?

Regards

Valavan.B

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Valavan,

Can't you use TSCOPY to achieve the same?

Thanks and regards,

Murali.

Former Member
0 Kudos

Hi Valavan,

Need little info regarding this issue.

Did you try to run the macro in the foreground, if not do so and check whether the data is saving after the execution of macro and also let me know the version of SCM server you are using.

Best Regards

Raghu Kishore

Former Member
0 Kudos

Raghu,

Macro is working ffine in the fore ground mode.

Its working even in the background mode. Problem is the macro is not gettting saved in the background mode.

We are using version 4.1

Valavan.B

Former Member
0 Kudos

Hello Valavan,

The message 'data not saved' can also be issued if the data has not changed. So if the macro is updating a keyfigure with the same values that are already in this keyfigure, this message will be issued. Can you check if this is the case.

If it is not the case, another common reasons for this problem could be that the macro requires data from the start or default macros'. In foreground, these other macros are executed. In background, they must be assigned to the background job before the macro in question (only if they are needed). Maybe this is the problem?

A 3rd possible reason could be that the keyfigure being populated is an auxiliary keyfigure that does not save (is dynamic). This would explain why in foreground it seems to save but in background it does not.

I hope one of the above answers helps you solve this issue.

Kind regards,

Nadim

Former Member
0 Kudos

Nadim,

Macro is used for sum the values of a KF based on the date. Today its Friday. Macro will calculat the values avakialble in tehe KF from Monday to Thursday.To do this calculation we have developed a Z User funciton and assigned the same in the macro.

No issue in the FG mode. Its working fien and we will be saving the Pl.Book values manually.

When i execute in the BG mode the macro caluclated value is not saved . ITs showing a warning message Data not Saved in the Job Spool request.

Valavan.B

Former Member
0 Kudos

try this please:

create two more macros which wil do a drill down and drill up (internal) - this would not affect any calculations

add this macro after your user macro into a collective macro

now run this collective macro in the background

eSkill
Explorer
0 Kudos

Hi!

As Nadim already stated:

"The message 'data not saved' can also be issued if the data has not changed. So if the macro is updating a keyfigure with the same values that are already in this keyfigure, this message will be issued. Can you check if this is the case."

Did you check this already? E.g. if you first start the macro in dialog and then as a job the job could not change the data...

Have fun!

Carsten

Former Member
0 Kudos

Hey ,

earlier i faced this problem...

kindly check your selection criteria while setting the back ground activities...some times we ignore this setting here...

Former Member
0 Kudos

can you check if the data is really not being saved (switch off the maro if its been set in default mode in the data view and run only the backgroound job)

what kind of function are you executing in the macro? are there other steps that are executed and saved??

Former Member
0 Kudos

Hi,

When i run the macro in the fore ground mode its calculating the values.

When Macro is removed form the Default setting and executed in the background mode its executed but data is not saved.

In the macro iam using a Z user function to sum the values from a KF on a dynamic basis based in the current date.

Valavan.B