Dynamic subset - Reference cube with different Dimensions
Posted: Wed Nov 08, 2023 8:42 am
Hi there
I am am trying to create a subset that needs to reference a cube to get a value - in my case, the Current Week. I have seen examples of referencing other cubes in dynamic subsets, but in this case it does not seem to work. The subset I am trying to create is in the "Weeks" dimension, and I have reduced my Mdx to test the "problem" part as follows:
{[Parameters].[Current Week].[String]}
I get the following error message:
"String": member not found
Any idea why? I am confident that it is not related to incorrect dimensions/elements when referencing the Parameters cube. I even tested with in DBRW formula ( DBRW("modelname:Parameters", "Current Week", "String") which resolves fine in Excel.
Any ideas?
Many thx!
I am am trying to create a subset that needs to reference a cube to get a value - in my case, the Current Week. I have seen examples of referencing other cubes in dynamic subsets, but in this case it does not seem to work. The subset I am trying to create is in the "Weeks" dimension, and I have reduced my Mdx to test the "problem" part as follows:
{[Parameters].[Current Week].[String]}
I get the following error message:
"String": member not found
Any idea why? I am confident that it is not related to incorrect dimensions/elements when referencing the Parameters cube. I even tested with in DBRW formula ( DBRW("modelname:Parameters", "Current Week", "String") which resolves fine in Excel.
Any ideas?
Many thx!