| Line 46... |
Line 46... |
| 46 |
<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
|
46 |
<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
|
| 47 |
<Table name="item">
|
47 |
<Table name="item">
|
| 48 |
</Table>
|
48 |
</Table>
|
| 49 |
<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
49 |
<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 50 |
</Level>
|
50 |
</Level>
|
| 51 |
<Level name="Product" column="id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
51 |
<Level name="Product" column="catalog_item_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 52 |
<NameExpression>
|
52 |
<NameExpression>
|
| 53 |
<SQL dialect="generic">
|
53 |
<SQL dialect="generic">
|
| 54 |
concat(IFNULL(model_name, ''), ' ', IFNULL(model_number, ''), '(', IFNULL(color, ''), ')') </SQL>
|
54 |
concat(IFNULL(model_name, ''), ' ', IFNULL(model_number, '')) </SQL>
|
| 55 |
</NameExpression>
|
55 |
</NameExpression>
|
| 56 |
</Level>
|
56 |
</Level>
|
| - |
|
57 |
<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
| - |
|
58 |
</Level>
|
| 57 |
</Hierarchy>
|
59 |
</Hierarchy>
|
| 58 |
</Dimension>
|
60 |
</Dimension>
|
| 59 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
|
61 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
|
| 60 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
62 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
| 61 |
<Table name="item">
|
63 |
<Table name="item">
|
| Line 212... |
Line 214... |
| 212 |
<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
|
214 |
<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
|
| 213 |
<Table name="item">
|
215 |
<Table name="item">
|
| 214 |
</Table>
|
216 |
</Table>
|
| 215 |
<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
217 |
<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 216 |
</Level>
|
218 |
</Level>
|
| 217 |
<Level name="Product" column="id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
219 |
<Level name="Product" column="catalog_item_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 218 |
<NameExpression>
|
220 |
<NameExpression>
|
| 219 |
<SQL dialect="generic">
|
221 |
<SQL dialect="generic">
|
| 220 |
concat(IFNULL(model_name, ''), ' ', IFNULL(model_number, ''), '(', IFNULL(color, ''), ')') </SQL>
|
222 |
concat(IFNULL(model_name, ''), ' ', IFNULL(model_number, '')) </SQL>
|
| 221 |
</NameExpression>
|
223 |
</NameExpression>
|
| 222 |
</Level>
|
224 |
</Level>
|
| - |
|
225 |
<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
| - |
|
226 |
</Level>
|
| 223 |
</Hierarchy>
|
227 |
</Hierarchy>
|
| 224 |
</Dimension>
|
228 |
</Dimension>
|
| 225 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
|
229 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
|
| 226 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
230 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
| 227 |
<Table name="item">
|
231 |
<Table name="item">
|