Skip to main content
JShoemaker
Contributor
Jul 19, 2024 7:24 PM UTC

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!

    5 replies

    T_Kress
    T_Kress
    Contributor
    Jul 19, 2024 8:07 PM UTC

    You could try something like this:

     

    T#MonthPrior1(|GlobalTime|)

     

      jbrem
      Contributor
      Jan 28, 2025 8:48 PM UTC

      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
      Newcomer
      Jan 29, 2025 8:32 PM UTC

      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
      Contributor
      Jan 29, 2025 8:48 PM UTC

      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.    

      Terms & ConditionsAccessibility statement