Code: Select all
{StrToMember("[Version].["+[}elementAttributes_sys.Clients].(StrToMember("[sys.Clients].["+username+"]"), [}elementAttributes_sys.Clients].[Default Version])+"]")}
Code: Select all
{StrToMember("[Version].["+[}elementAttributes_sys.Clients].(StrToMember("[sys.Clients].["+username+"]"), [}elementAttributes_sys.Clients].[Default Version])+"]")}
What we are doing is using a version dimension where some versions are "active" and the rules calculate on those versions and other versions that are static. For the active versions, different user bases working in, so the users select which version they wish to default work in and all their views, and some TI's, automatically use that default version.Failed to Filter members.
Could not execute MDX expression.
Unknown error.