Forum Discussion

hbindu's avatar
hbindu
New Contributor III
4 months ago

Getting an error when calling an assemblies from DM step

I have an Assembly which is compiling without errors. The Assembly type is DashboardStringFunction. I called the assembly from DM step in the Time Filter:

XFBR(Worspace.PS_Allocation_Rules.PS_Allocation.PS_XFBR_Allocation, MultiSelectTime, Allocation_MonthsToCopy=[|!Allocation_MonthsToCopy!|])

When I execute the step, I am getting below error:

Error processing Data Management Step 'Allocations_AllAccountBkt_Step'. Invalid parameter. Time Filter, #ERROR: XFBR[Worspace.PS_Allocation_Rules.PS_Allocation.PS_XFBR_Allocation, MultiSelectTime, Allocation_MonthsToCopy=[2023]].

I am calling the function as per the reference material:

XFBR(Workspace.WorkspaceName.AssemblyName.FileName, FunctionName)

Appreciate your inputs

XFBR
  • JackLacava's avatar
    JackLacava
    4 months ago

    Works for me on version 8.4.

    Make sure your function returns a string starting with T# (because it's a Filter). Maybe test it on a dummy cubeview first, to verify it actually returns what you expect (the Workspace might have to be set to Shareable for that to work).

     

     

  • Cosimo's avatar
    Cosimo
    Contributor II
    4 months ago

    I could be wrong but I don't think you need to include ValidateEmployStatusSelectedEmployee within the XFBR. Try this?

    XFBR(PS_XFBR_Allocation, MultiSelectTime, Allocation_MonthsToCopy=[|!Allocation_MonthsToCopy!|])

    • hbindu's avatar
      hbindu
      New Contributor III
      4 months ago

      if the XFBRstring is created within assemblies then I think we will have to call it like: XFBR(Workspace.WorkspaceName.AssemblyName.FileName, FunctionName). This is based on the reference guide.

       

       

  • aricgresko's avatar
    aricgresko
    Contributor III
    4 months ago

    Could it be as simple as misspelling "Workspace" at the beginning of your XFBR?

    Error processing Data Management Step 'Allocations_AllAccountBkt_Step'. Invalid parameter. Time Filter, #ERROR: XFBR[Worspace.PS_Allocation_Rules.PS_Allocation.PS_XFBR_Allocation, MultiSelectTime, Allocation_MonthsToCopy=[2023]].

    • hbindu's avatar
      hbindu
      New Contributor III
      4 months ago

      My bad, I fixed it, but pasted the old error msg. After fixing the workspace, still getting the same error.

      'Allocations_AllAccountBkt_Step'. Invalid parameter. Time Filter, #ERROR: XFBR[Workspace.PS_Allocation_Rules.PS_Allocation.PS_XFBR_Allocation, MultiSelectTime, Allocation_MonthsToCopy=[2023]].

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    4 months ago

    Works for me on version 8.4.

    Make sure your function returns a string starting with T# (because it's a Filter). Maybe test it on a dummy cubeview first, to verify it actually returns what you expect (the Workspace might have to be set to Shareable for that to work).

     

     

    • hbindu's avatar
      hbindu
      New Contributor III
      4 months ago

      I am on 8.2.2 and I tried hardcoding the return value, still getting the same error.

      • JackLacava's avatar
        JackLacava
        Honored Contributor
        4 months ago

        If you've tested with a Cube View using the same syntax, and it returns the right filter there, you will have to talk to Support, as it might be a release-specific bug.