Creating a dimension with multiple hierarchies
You can use the Dimension Write
method to
create a dimension with multiple hierarchies.
Request
In this example, replace \t with a horizontal tabulator.
<Alea:Document xmlns:Alea="http://www.misag.com">
<Alea:Request RequestID="4" Class="Dimension" Method="Write">
<Alea:Dimension Name="Org" FirstBatch="true" LastBatch="true" >
<Alea:Description>D212</Alea:Description>
<Alea:Hierarchy Name="Org as of 2014">
<Alea:Elements>N\tFire Department
N\tPolice Department
N\tWaste Removal
N\tDriver License
C\tEmergency
!\tEmergency\tFire Department\t1
!\tEmergency\tPolice Department\t1
C\tStandard
!\tStandard\tWaste Removal\t1
!\tStandard\tDriver License\t1
C\tAll
!\tAll\tEmergency\t1
!\tAll\tStandard\t1</Alea:Elements>
</Alea:Hierarchy>
<Alea:Hierarchy Name="Org as of 2015">
<Alea:Elements>N\tFire Department
N\tPolice Department
N\tWaste Removal
N\tDriver License 2015
C\tAll
!\tALL\tFire Department\t1
!\tALL\tPolice Department\t1
!\tALL\tWaste Removal\t1
!\tALL\tDriver License 2015\t1</Alea:Elements>
</Alea:Hierarchy>
<Alea:Properties>
<Alea:DefaultHierarchy Name="Org as of 2015"/>
<Alea:DefaultMember Name="Police Department" Hierarchy="Org as of 2015"/>
</Alea:Properties>
</Alea:Dimension>
</Alea:Request>
</Alea:Document>
Answer
<Alea:Document xmlns:Alea="http://www.misag.com">
<Alea:Request RequestID="4">
<Alea:Return>
<Alea:Dimension Name="Org">
<Alea:Hierarchy Name="Org as of 2014"/>
<Alea:Hierarchy Name="Org as of 2015"/>
</Alea:Dimension>
</Alea:Return>
</Alea:Request>
</Alea:Document>