Adding some context:
Click on Workspaces, then the workspace the parameter belongs to:
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.
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.
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.
Genius - did not know you could declare Workspace in the parameter. Makes sense!
Learn one thing new everyday and you'll become wise one day :)
Thx @Tyler.
Cheers,
A.
