<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt"><div style="" class="">Hi,</div><div style="" class="">I'm using mondrian 3.3.0.14703. I have a shared dimension as follows:</div><div style="" class=""><br style="" class=""></div><div style="font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;" class=""><span style="color: rgb(221, 144, 47);"> <span style="color: rgb(205, 35, 44);"><Dimension name="Branch"><br style="" class=""> <Hierarchy name="StateCity" primaryKey="BRANCH_ID" hasAll="true" allMemberName="All"><br style="" class=""> <Table schema="BIDWH" name="COR_DM_BRANCH" /><br style="" class=""><br style=""
class=""> <Level name="State" column="STATE_ID" captionColumn="STATE_NAME" uniqueMembers="true" internalType="long"/><br style="" class=""> <Level name="City" column="CITY_ID" captionColumn="CITY_NAME" uniqueMembers="true" internalType="long"/><br style="" class=""> <Level name="Branch" column="BRANCH_ID" captionColumn="BRANCH_NAME" uniqueMembers="true" internalType="long"/><br style="" class=""> </Hierarchy><br style="" class=""><br style="" class=""> <Hierarchy name="BranchGroup" primaryKey="BRANCH_ID" hasAll="true" allMemberName="All"><br style="" class=""> <Table schema="BIDWH" name="COR_DM_BRANCHGROUP" /><br style=""
class=""><br style="" class=""> <Level name="BranchGroup" column="BRANCHGROUP_ID" captionColumn="BRANCHGROUP_NAME" uniqueMembers="true" internalType="long" /><br style="" class=""> </Hierarchy><br style="" class=""> </Dimension></span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class=""><br style="" class=""></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class="">So when I execute an MDX, a sample member returned for this dimension is [Branch.StateCity].[6578].[13091].[1185058062]. When user wants to use this member in a
report, its complete name (e.g. [Branch.StateCity].[6578].[13091].[1185058062]) is saved in the report.</div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class=""><br style="" class=""></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class="">But when the city and state of that branch is changed (e.g. [Branch.StateCity].[12777].[13091].[1185058062]), the saved report can't be executed, because mondrian can't find the old member.</div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class=""><br></div><div style="color: rgb(0, 0,
0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class="">What can I do?</div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class="">Please remember that I saved the fully qualified name of old member in a report.<br></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal" class=""> </div></div></body></html>