The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

prash4030's avatar
prash4030
New Contributor III
1 year ago
Solved

Passing scenario as parameter to copy step

hi experts.

i'm trying to use a button on dashboard that calls a DM sequence. in my sequence, i'm calling copy task. Basically, i'm trying to copy data using DM step where i want to pass scenario as parameter. here is the configuration.

How to pass parameter to copy task from sequence? 

 

button configuration:

Sequence - parameter definition 

copy step:

 

Data Management
  • victortei's avatar
    victortei
    1 year ago

    Hi prash4030,

    Please clear your section on parameter substitutions in your data management sequence.

    This should do the deal. You can also trigger the Data Management Sequence directly from the DM to validate this is working.

     If this is working, it would prompt for your input on the ScenarioFrom and ScenarioTo. Something like this:

    Then, finally, just try it from the Dashboard to make sure this is working properly.

    Hope this helps!

     

     

8 Replies

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    Try by keeping all your parameter names the same.  In the above screen shot I see it as the following in the button:

    • ParamCopyScenarioFrom
    • ParamCopyScenarioTo

     

    But in the DM Sequence they are:

    • ScenarioFrom
    • ScenarioTo

     

    I would keep the parameter names consistent between the BR, Button and DM sequence so they pass through correctly.

    • prash4030's avatar
      prash4030
      New Contributor III
      1 year ago

      hi,

      thank you for your reply. i tried making them consistent, still no luck. in DM sequence, where i've defined parameter name, what should i write in value? i have kept this as blank, i am thinking value will flow from button click action?

      • victortei's avatar
        victortei
        New Contributor III
        1 year ago

        prash4030,

        As T_Kress said, try to use the same name everywhere to track it more easily. From your screen, it seems you're not assigning a value to the parameter in the Sequence. Try to do the following:

        In your button, it will be something like this:

        ParamCopyScenarioFrom=|!ParamCopyScenarioFrom!|, ParamCopyScenarioTo=|!ParamCopyScenarioTo!|

        In your Sequence:

        Parameter = ParamCopyScenarioFrom
Value = |!ParamCopyScenarioFrom!|

Parameter = ParamCopyScenarioTo
Value = |!ParamCopyScenarioTo!|

        In your Copy Step:

        |!ParamCopyScenarioFrom!|
|!ParamCopyScenarioTo!|

        Please, let us know how it goes