| Line 50... |
Line 50... |
| 50 |
</Level>
|
50 |
</Level>
|
| 51 |
<Level name="Color" column="color" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
51 |
<Level name="Color" column="color" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 52 |
</Level>
|
52 |
</Level>
|
| 53 |
</Hierarchy>
|
53 |
</Hierarchy>
|
| 54 |
</Dimension>
|
54 |
</Dimension>
|
| - |
|
55 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
|
| - |
|
56 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
| - |
|
57 |
<Table name="item" schema="" alias="">
|
| - |
|
58 |
</Table>
|
| - |
|
59 |
<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| - |
|
60 |
</Level>
|
| - |
|
61 |
<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| - |
|
62 |
</Level>
|
| - |
|
63 |
</Hierarchy>
|
| - |
|
64 |
</Dimension>
|
| 55 |
<Measure name="TotalSales" column="unit_price" datatype="Numeric" formatString="##,###.00" aggregator="sum" visible="true">
|
65 |
<Measure name="TotalSales" column="unit_price" datatype="Numeric" formatString="##,###.00" aggregator="sum" visible="true">
|
| 56 |
</Measure>
|
66 |
</Measure>
|
| 57 |
<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
67 |
<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
| 58 |
</Measure>
|
68 |
</Measure>
|
| 59 |
<Measure name="Average Selling price" column="unit_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
|
69 |
<Measure name="Average Selling price" column="unit_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
|