Forum Discussion

JShoemaker's avatar
JShoemaker
New Contributor III
7 months ago

Data Management Global Time

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. 

Scenario=[Actual], Time=[|GlobalTime|]. I have tried [|GlobalPrior1|] with no luck

I am trying to get the prior month so I have tried 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!

Data Management
  • T_Kress's avatar
    T_Kress
    Contributor III
    7 months ago

    You could try something like this:

     

    T#MonthPrior1(|GlobalTime|)

     

  • jbrem's avatar
    jbrem
    New Contributor III
    10 days ago

    I have the same issue.  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.  I've tried different combinations but so far have been unsuccessful finding a way to have it automatically run for prior period.  

    • rhankey's avatar
      rhankey
      Contributor
      9 days ago

      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's avatar
        jbrem
        New Contributor III
        9 days ago

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