| Line 198... |
Line 198... |
| 198 |
case when otg = 1 then 'Yes' else 'No' end </SQL>
|
198 |
case when otg = 1 then 'Yes' else 'No' end </SQL>
|
| 199 |
</NameExpression>
|
199 |
</NameExpression>
|
| 200 |
</Level>
|
200 |
</Level>
|
| 201 |
</Hierarchy>
|
201 |
</Hierarchy>
|
| 202 |
</Dimension>
|
202 |
</Dimension>
|
| - |
|
203 |
<Dimension type="StandardDimension" foreignKey="source" name="OrderSource">
|
| - |
|
204 |
<Hierarchy name="OrderSource" hasAll="true" allMemberName="All">
|
| - |
|
205 |
<Level name="OrderSource" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| - |
|
206 |
<KeyExpression>
|
| - |
|
207 |
<SQL dialect="generic">
|
| - |
|
208 |
case when source = 1 then 'WEBSITE' when source = 2 then 'STORE' when source = 3 then 'AMAZON' end </SQL>
|
| - |
|
209 |
</KeyExpression>
|
| - |
|
210 |
<NameExpression>
|
| - |
|
211 |
<SQL dialect="generic">
|
| - |
|
212 |
case when source = 1 then 'WEBSITE' when source = 2 then 'STORE' when source = 3 then 'AMAZON' end </SQL>
|
| - |
|
213 |
</NameExpression>
|
| - |
|
214 |
</Level>
|
| - |
|
215 |
</Hierarchy>
|
| - |
|
216 |
</Dimension>
|
| 203 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
217 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
| 204 |
</Measure>
|
218 |
</Measure>
|
| 205 |
<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
219 |
<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
| 206 |
</Measure>
|
220 |
</Measure>
|
| 207 |
<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
221 |
<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
| Line 420... |
Line 434... |
| 420 |
case when otg = 1 then 'Yes' else 'No' end </SQL>
|
434 |
case when otg = 1 then 'Yes' else 'No' end </SQL>
|
| 421 |
</NameExpression>
|
435 |
</NameExpression>
|
| 422 |
</Level>
|
436 |
</Level>
|
| 423 |
</Hierarchy>
|
437 |
</Hierarchy>
|
| 424 |
</Dimension>
|
438 |
</Dimension>
|
| - |
|
439 |
<Dimension type="StandardDimension" foreignKey="source" name="OrderSource">
|
| - |
|
440 |
<Hierarchy name="OrderSource" hasAll="true" allMemberName="All">
|
| - |
|
441 |
<Level name="OrderSource" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| - |
|
442 |
<KeyExpression>
|
| - |
|
443 |
<SQL dialect="generic">
|
| - |
|
444 |
case when source = 1 then 'WEBSITE' when source = 2 then 'STORE' when source = 3 then 'AMAZON' end </SQL>
|
| - |
|
445 |
</KeyExpression>
|
| - |
|
446 |
<NameExpression>
|
| - |
|
447 |
<SQL dialect="generic">
|
| - |
|
448 |
case when source = 1 then 'WEBSITE' when source = 2 then 'STORE' when source = 3 then 'AMAZON' end </SQL>
|
| - |
|
449 |
</NameExpression>
|
| - |
|
450 |
</Level>
|
| - |
|
451 |
</Hierarchy>
|
| - |
|
452 |
</Dimension>
|
| 425 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
453 |
<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
|
| 426 |
</Measure>
|
454 |
</Measure>
|
| 427 |
<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
455 |
<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
| 428 |
</Measure>
|
456 |
</Measure>
|
| 429 |
<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|
457 |
<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
|