I am trying to copy all the values under dimension to single member.
Here is the scenario
U11211 -> "PR023" = @Relative("All units",0) -> @Relative("All_Project",0);
But this thing aren't working , the error message it says
"Cannot calculate dimension member [U11211] with restricted member [All units] Rule"
Any ideas how to approach this?
You didn't post your full code. What that error message says to me that you've All Units in the FIX statement.
You cannot do this, it'll result in another error.
U11211 -> "PR023" = "All units" -> "All_Project",0;
This will give you the sum of all Units -> All projects into U11211 -> PR023