[Mondrian] Changing Levels in a Hierarchy of a Dimension

m.xinu mehdi_xinu at yahoo.com
Sat Apr 26 10:32:39 EDT 2014

I'm using mondrian I have a shared dimension as follows:

    <Dimension name="Branch">
        <Hierarchy name="StateCity" primaryKey="BRANCH_ID" hasAll="true" allMemberName="All">
            <Table schema="BIDWH" name="COR_DM_BRANCH" />

            <Level name="State" column="STATE_ID" captionColumn="STATE_NAME" uniqueMembers="true" internalType="long"/>
            <Level name="City" column="CITY_ID" captionColumn="CITY_NAME" uniqueMembers="true" internalType="long"/>
            <Level name="Branch" column="BRANCH_ID" captionColumn="BRANCH_NAME" uniqueMembers="true" internalType="long"/>

        <Hierarchy name="BranchGroup" primaryKey="BRANCH_ID" hasAll="true" allMemberName="All">
            <Table schema="BIDWH" name="COR_DM_BRANCHGROUP" />

            <Level name="BranchGroup" column="BRANCHGROUP_ID" captionColumn="BRANCHGROUP_NAME" uniqueMembers="true" internalType="long" />

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.

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.

What can I do?
Please remember that I saved the fully qualified name of old member in a report.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140426/49066b4f/attachment.html 

More information about the Mondrian mailing list