Forum Discussion

ethanmgomes's avatar
ethanmgomes
New Contributor II
2 years ago
Solved

Reference a parameter in a different workspace than default

I am executing a Copy Data Management step which references a literal parameter (NOT in Default workspace) to get the scenario value. However, I am receiving an "Invalid Parameter" error when trying to use the parameter even though I confirmed the parameter is named correctly and has a value. 

However, when I created the same parameter in the Default workspace, the Data Management step executed successfully. 

In a Data Management step, is there a way to denote which workspace the parameter should be coming from? I tried something like: workspace_name.|!Scenario_parameter!| but no luck. Is there any documentation on this? 

Data Management

8 Replies

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Adding some context: 
    Click on Workspaces, then the workspace the parameter belongs to:

     

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    ethanmgomes   If you're on version 7, using an XFBR will probably be the way to get to a parameter in a different workspace.

    Workspaces are a work in progress and not fully integrated in version 7 so we do some workarounds to get what they provide sometimes. 

    • ethanmgomes's avatar
      ethanmgomes
      New Contributor II
      2 years ago

      Hey Robb, I am on version 8.1

      Agree that XFBR will get the job done, but is there any method currently to differentiate which workspace is used when calling a parameter. 

  • jarrod's avatar
    jarrod
    New Contributor III
    7 months ago

    we have exactly the same issue where we would like to hold global formatting parameters in a global workspace - using the shared workspace name on the Workspace settings allows this to work. I suspect if you upgraded to v8.4 and can create DM Jobs in your workspace you might be able to resolve your issue.

    • TGG_Alex's avatar
      TGG_Alex
      Contributor
      4 months ago

      jarrod- I don't believe this to be resolved in v8.4 but could be the specific use case we have.

      If the parameter is for formatting and referenced in a CubeView, the above settings seem to work ok - even in 7.4.2.  However, if the CubeView is then nested into a dashboard, then the cross Workspace reference does not appear to be resolved.  As a potential work around, it seems that a BR might be able to do this.

      Not sure if others have alternate suggestions.

       

      • Tyler_Dawson's avatar
        Tyler_Dawson
        New Contributor III
        13 days ago

        We ran into this exact same issue today on v8.5. The parameter worked fine on a cube view, but not in a nested dashboard in a different workspace. I found an article on OneCommunity that solved the issue for us (OneCommunity isn't letting me add the link right now, but it is titled "How to access the parameter (present outside default workspace) in Cube view").

        Looks like you just need to set the workspace with the parameter you want to use to "Is Shareable Workspace" of True and then you can use the workspace name in your parameter. So if you have a formatting parameter named Total_Cell in a workspace named "Formatting", you would use |!Formatting.Total_Cell!| instead of |!Total_Cell!| and it should work. This worked for us.