| Line 159... |
Line 159... |
| 159 |
<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
|
159 |
<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
|
| 160 |
<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
|
160 |
<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
|
| 161 |
<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
161 |
<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 162 |
<KeyExpression>
|
162 |
<KeyExpression>
|
| 163 |
<SQL dialect="generic">
|
163 |
<SQL dialect="generic">
|
| 164 |
case when pickupStoreId = 0 then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
164 |
case when pickupStoreId is null then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
| 165 |
</KeyExpression>
|
165 |
</KeyExpression>
|
| 166 |
<NameExpression>
|
166 |
<NameExpression>
|
| 167 |
<SQL dialect="generic">
|
167 |
<SQL dialect="generic">
|
| 168 |
case when pickupStoreId = 0 then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
168 |
case when pickupStoreId is null then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
| 169 |
</NameExpression>
|
169 |
</NameExpression>
|
| 170 |
</Level>
|
170 |
</Level>
|
| 171 |
<Level name="StoreId" table="sales" column="pickupStoreId" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
171 |
<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 172 |
</Level>
|
172 |
</Level>
|
| 173 |
</Hierarchy>
|
173 |
</Hierarchy>
|
| 174 |
</Dimension>
|
174 |
</Dimension>
|
| 175 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
175 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
| 176 |
</Measure>
|
176 |
</Measure>
|
| Line 347... |
Line 347... |
| 347 |
<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
|
347 |
<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
|
| 348 |
<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
|
348 |
<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
|
| 349 |
<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
349 |
<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 350 |
<KeyExpression>
|
350 |
<KeyExpression>
|
| 351 |
<SQL dialect="generic">
|
351 |
<SQL dialect="generic">
|
| 352 |
case when pickupStoreId = 0 then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
352 |
case when pickupStoreId is null then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
| 353 |
</KeyExpression>
|
353 |
</KeyExpression>
|
| 354 |
<NameExpression>
|
354 |
<NameExpression>
|
| 355 |
<SQL dialect="generic">
|
355 |
<SQL dialect="generic">
|
| 356 |
case when pickupStoreId = 0 then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
356 |
case when pickupStoreId is null then 'HomeDelivery' else 'Store Pickup' end </SQL>
|
| 357 |
</NameExpression>
|
357 |
</NameExpression>
|
| 358 |
</Level>
|
358 |
</Level>
|
| 359 |
<Level name="StoreId" table="sales" column="pickupStoreId" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
359 |
<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 360 |
</Level>
|
360 |
</Level>
|
| 361 |
</Hierarchy>
|
361 |
</Hierarchy>
|
| 362 |
</Dimension>
|
362 |
</Dimension>
|
| 363 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
363 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
| 364 |
</Measure>
|
364 |
</Measure>
|