LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  {{^CurrentDate^}} in file name - BRX not working

    Employee
    Posted 03-22-2010 16:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: leekennett

    Hi,

    So I used the built in variable for CurrentDate within my output file names so I know when it was run.

    I've found that when you export the graph to a BRX it substitutes the {{^CurrentDate^}} field with the date the BRX was generated and all subsequent files have the same value.

    I looked within the BRX file and it specifically has the date embedded in the file and it's no longer the sysdate.

    Is there anything I can do about this?


  • 2.  RE: {{^CurrentDate^}} in file name - BRX not working

    Employee
    Posted 03-22-2010 19:25

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    For use in a BRX, you should do this..
    Change your parameter to {{*DataDate*}}

    Then in unix,
    export p_DataDate=`date +%Y-%m-%d`


    The {{**}} means "get the parameter from unix"

    You can pick pretty much any name here you want, and you can send multiple parameters from unix into a graph using this message.


  • 3.  RE: {{^CurrentDate^}} in file name - BRX not working

    Employee
    Posted 03-23-2010 10:08

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    You could also use the date() function which returns the current date if you do not supply any parameters. But note that depending on the context, it likely better to go with Stony's solution much of the time because this allows one to re-execute the graph manually with exactly the same values.