Skip to main content
J
JShoemaker
Contributor
July 19, 2024

Data Management Global Time

  • July 19, 2024
  • 2 replies
  • 0 views

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!

    2 replies

    T_Kress
    OneStream Employee
    T_KressOneStream Employee
    OneStream Employee
    July 19, 2024

    You could try something like this:

     

    T#MonthPrior1(|GlobalTime|)

     

      J
      jbrem
      Contributor
      January 28, 2025

      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.  

      R
      rhankey
      Newcomer
      January 29, 2025

      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.

      J
      jbrem
      Contributor
      January 29, 2025

      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