[Mondrian] Changing Levels in a Hierarchy of a Dimension
m.xinu
mehdi_xinu at yahoo.com
Sat Apr 26 10:32:39 EDT 2014
Hi,
I'm using mondrian 3.3.0.14703. 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>
<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" />
</Hierarchy>
</Dimension>
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