AnsweredAssumed Answered

Unable to convert mondrian 4 schema file to mondrain 3.x schema file

Question asked by TUSHAR MALI on Dec 11, 2018
Latest reply on Dec 23, 2018 by TUSHAR MALI

1. We have Mondrian 4 schema file (Cube file .xml) , which is created in Mondrian 4, but the Mondrian Schema workbench(It is a beta version) currently not available. Now we are using stable version of Mondrian Schema Workbench (3.6.1) so we want to read and modify the Mondrian 4 schema file in Mondrian Schema Workbench (3.6.1) .

We use IvySE plugin but unable to succeed.

2. Is there any way to downgrade the schema file version (i.e. Mondrian 4.0 to Mondrian 3.6.1)?

3. Is any adaptor/plugin to convert schema file  (i.e. Mondrian 4.0 to Mondrian 3.6.1) ?

What we have :

1. Mondrian 4 schema file.(Cube file .xml)

2. Mondrian 3.6.1 Pentaho Schema Workbench (PSW)

 

<?xml version="1.0" encoding="UTF-8"?>
<Schema name="sales" metamodelVersion="4.0">
  <PhysicalSchema>
  <Table name="sales" />
  </PhysicalSchema>
  <Cube name="Sales">
  <Dimensions>
  <Dimension name="City" key="City">
  <Attributes>
  <Attribute name="City" keyColumn="city" hasHierarchy="false" />
  </Attributes>
  <Hierarchies>
  <Hierarchy name="City" hasAll="true">
  <Level attribute="City" />
  </Hierarchy>
  </Hierarchies>
  </Dimension>
  <Dimension name="Store" key="Store">
  <Attributes>
  <Attribute name="Store" keyColumn="store" hasHierarchy="false" />
  </Attributes>
  <Hierarchies>
  <Hierarchy name="Store" hasAll="true">
  <Level attribute="Store" />
  </Hierarchy>
  </Hierarchies>
  </Dimension>
  </Dimensions>
  <MeasureGroups>
  <MeasureGroup name="Sales" table="sales">
  <Measures>
  <Measure name="Units sold" column="unitssold" aggregator="sum" formatString="#,###" />
  </Measures>
  <DimensionLinks>
  <ForeignKeyLink dimension="City" foreignKeyColumn="city" />
  <ForeignKeyLink dimension="Store" foreignKeyColumn="store" />
  </DimensionLinks>
  </MeasureGroup>
  </MeasureGroups>
  </Cube>
</Schema>

 

Thanks and Advance.

Outcomes