Skip to main content
E
ethanmgomes
April 18, 2024
Solved

Reference a parameter in a different workspace than default

  • April 18, 2024
  • 4 replies
  • 1 view

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? 

Best answer by Krishna

ethanmgomes  - Enable the below parameter it should work.


Krishna_0-1713455847115.png

 

 

4 replies

R
RobbSalzmann
April 18, 2024

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. 

E
ethanmgomesAuthor
April 18, 2024

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. 

K
KrishnaAnswer
April 18, 2024

ethanmgomes  - Enable the below parameter it should work.


Krishna_0-1713455847115.png

 

 

R
RobbSalzmann
April 18, 2024

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


RobbSalzmann_0-1713456296988.png

 

J
jarrod
December 8, 2024

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.

T
TGG_Alex
February 27, 2025

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.

 

T
Tyler_Dawson
June 10, 2025

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.

Terms & ConditionsAccessibility statement