Data Management Global Time

Question

Hi all, I thought this was easy but not sure what I am missing. I have a current data management job that is running off this parameter and works just fine.&nbsp;
Scenario=[Actual], Time=[|GlobalTime|]. I have tried [|GlobalPrior1|] with no luck
I am trying to get the prior month so I have tried&nbsp;Scenario=[Actual], Time=[|GlobalTimePrior1|] but that is an invalid sub variable, is there another syntax to use on this? I know you can with t# in cube views but this is the DM job. Thanks in advance!

T_Kress · Answer

You could try something like this:
&nbsp;
T#MonthPrior1(|GlobalTime|)
&nbsp;

jbrem · Answer

I have the same issue.&nbsp; It seems that there must be some type of limitations on what can be set in the DM job, but I can't find any details.&nbsp; I've tried different combinations but so far have been unsuccessful finding a way to have it automatically run for prior period.&nbsp;&nbsp;

rhankey · Answer

What was wrong with Teresa's suggestion of using T#MonthPrior1(|GlobalTime|)?

And, of course, if you can't find or are unaware of a built-in function or variable that gives what you want, you can always get whatever you would like from an XFBR() rule.

jbrem · Answer

Nothing wrong with the suggestion at all.&nbsp; I'm still learning and it just seems that there are certain areas where this works and where it doesn't.&nbsp; I would love to be able to understand why that is or if there is something I am just looking at incorrectly.&nbsp; If there are special circumstances around using this, it would be helpful if I could find those.&nbsp; &nbsp;&nbsp;

JShoemaker · Answer

Nothing wrong at all but the DM step will not accept that syntax. I ended up using an XFBR variable and it worked just fine.&nbsp;

Forum Discussion

Data Management Global Time

Related Content

Globals object and Data Management steps / sequences

Data management Sequence

Global Options Dashboard

Remove text from entities in Data Management

Run Data Managment as an admin?