MondrianTestOracle.xml in mondrian-olap-1.3.0

- old
+ new
@@ -124,6 +124,46 @@
       caption="Gewinn-Wachstum">
     <CalculatedMemberProperty name="FORMAT_STRING" value="0.0%"/>
   </CalculatedMember>
 </Cube>
 
+<Cube name="Warehouse">
+  <Table name="WAREHOUSE"/>
+  <DimensionUsage name="Time" source="Time" foreignKey="TIME_ID"/>
+  <DimensionUsage name="Product" source="Product" foreignKey="PRODUCT_ID"/>
+  <Measure aggregator="sum" column="UNITS_SHIPPED" formatString="#,##0" name="Units Shipped"/>
+  <Measure aggregator="sum" column="STORE_INVOICE" formatString="#,##0.00" name="Store Invoice"/>
+  <Measure name="Products with units shipped" aggregator="distinct-count" formatString="#,###">
+    <MeasureExpression>
+      <SQL dialect="generic">
+CASE WHEN UNITS_SHIPPED IS NOT NULL THEN PRODUCT_ID END
+      </SQL>
+    </MeasureExpression>
+  </Measure>
+</Cube>
+
+<VirtualCube name="Sales and Warehouse">
+  <VirtualCubeDimension name="Customers" cubeName="Sales"/>
+  <VirtualCubeDimension name="Gender" cubeName="Sales"/>
+  <VirtualCubeDimension name="Product"/>
+  <VirtualCubeDimension name="Time"/>
+  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Unit Sales]"/>
+  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Cost]"/>
+  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Sales]"/>
+  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Sales Count]"/>
+  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Customer Count]"/>
+  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Units Shipped]"/>
+  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Store Invoice]"/>
+  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Products with units shipped]"/>
+</VirtualCube>
+
+<Role name="Canada manager">
+  <SchemaGrant access="none">
+    <CubeGrant access="all" cube="Sales">
+      <HierarchyGrant access="custom" hierarchy="[Customers]">
+        <MemberGrant access="all" member="[Customers].[Canada]"/>
+      </HierarchyGrant>
+    </CubeGrant>
+  </SchemaGrant>
+</Role>
+
 </Schema>