Creating a dimension with multiple hierarchies
You can use the Dimension Write
function
to create a dimension with multiple hierarchies.
Request
In this example, replace \t with an actual 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\tPublic Library
C\tEmergency
!\tEmergency\tFire Department\t1
!\tEmergency\tPolice Department\t1
C\tStandard
!\tStandard\tWaste Removal\t1
!\tStandard\tPublic Library\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\tPublic Library 2015
C\tAll
!\tAll\tFire Department\t1
!\tAll\tPolice Department\t1
!\tAll\tWaste Removal\t1
!\tAll\tPublic Library 2015\t1</Alea:Elements>
</Alea:Hierarchy>
<Alea:Properties>
<Alea:DefaultHierarchy Name="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>