AnsweredAssumed Answered

Mondrian and Slowly Changing Dimension Type 2

Question asked by ashdam dourden on Feb 7, 2018
Latest reply on Feb 23, 2018 by ashdam dourden

I have been searching an example of XML for an Slowly changing dimension type 2 in Mondrian since the solution I have gives duplicated results.

 

Mi dimension code:

 

<Dimension name="Dealer" type="StandardDimension" >
     <Hierarchy name="Zone-Dealer" hasAll="true" allMemberName="All" primaryKey="DEALER_ID" type="Integer" >
     <Table name="D_DEALER" />
          <Level name="Zone" column="ZONE_ID" nameColumn="ZONE_DESCRIPTION" ordinalColumn="ZONE_ID" type="String" uniqueMembers="true"/>
          <Level name="Dealer" column="DEALER_ID" nameColumn="DEALER_DESCRIPTION" ordinalColumn="DEALER_DESCRIPTION" type="Integer" uniqueMembers="true">/>
     </Hierarchy>
</Dimension>

 

DEALER_ID is the surrogate/techinical key.

DEALER_NK is the natural/business key which is only used in the ETL to lookup with it and a date.

DEALER_DESCRIPTION is shared even if dealer changes its zone.

Outcomes