Forum Discussion

mvalerio24's avatar
mvalerio24
New Contributor III
5 months ago

Error while running an extender Rule calling a Data Management job with XFBR on time filter

I have an XFBR on the time filter on a Data Management step that pulls a list of time. When I run it on the Data Management tab it runs just fine and works. Now when i try to put that on a button to run on a dashboard, I get an error. I have tried using the Execute Data Management Sequence Server Task as well as running it through an extender rule. I am passing the required parameters to the either situation but im still getting an error? Why would it work on the Data Management Tab and not work while running it through a button?

 

 

 

Finance
  • KarlT's avatar
    KarlT
    5 months ago

    Is the p_Forecasted_Months parameter the one you are using for the user selection? If so, try configuring your button like this:

    Then in your DM step use the parameter |!param_fcstMonth!| in your XFBR and BR parameters.

    Regards,

  • KarlT's avatar
    KarlT
    Contributor III
    5 months ago

    Is the p_Forecasted_Months parameter the one you are using for the user selection? If so, try configuring your button like this:

    Then in your DM step use the parameter |!param_fcstMonth!| in your XFBR and BR parameters.

    Regards,

  • rhankey's avatar
    rhankey
    Contributor
    5 months ago

    Change the following line of code

    From: Param.Add("userSelectedMonths",FcstMonths)

    To: Param.Add("p_Forecasted_Months",FcstMonths)

     

      • rhankey's avatar
        rhankey
        Contributor
        5 months ago

        Time to add a debug statement or two in the XFBR rule to see what is being passed in, and what you are returning, as ultimately, OS is saying it didn't resolve to a valid time member filter.