Sample Formula for the ConsolidatedData Member
Assuming that Market is a sparse dimension and that Working is a base version, here is a sample formula for the ConsolidatedData member:
IF(@ISLev("Market",0))
IF(@ISLev("Entity",0))
IF (@ISLev("Period", 0))
IF(NOT (@ismbr(@relative("Sandboxes",0))))
BaseData;
ELSE
IF (SandboxData== #MISSING )
IF(@ISCHILD("Sandboxes_Working"))
"Working"->BaseData;
ENDIF
ELSE
SandboxData;
ENDIF
ENDIF
ENDIF
ENDIF
ENDIF