| Line 88... |
Line 88... |
| 88 |
</Level>
|
88 |
</Level>
|
| 89 |
</Hierarchy>
|
89 |
</Hierarchy>
|
| 90 |
</Dimension>
|
90 |
</Dimension>
|
| 91 |
<Dimension type="StandardDimension" name="Delivery Difference">
|
91 |
<Dimension type="StandardDimension" name="Delivery Difference">
|
| 92 |
<Hierarchy name="Delivery Difference" hasAll="true" allMemberName="All">
|
92 |
<Hierarchy name="Delivery Difference" hasAll="true" allMemberName="All">
|
| 93 |
<Level name="Delivery Difference" table="orderfulfillment" column="actual_estimate_diff" ordinalColumn="actual_estimate_diff" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
93 |
<Level name="Delivery Difference" table="orderfulfillment" column="actual_estimate_diff" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 94 |
<KeyExpression>
|
94 |
<KeyExpression>
|
| 95 |
<SQL dialect="generic">
|
95 |
<SQL dialect="generic">
|
| 96 |
case when actual_estimate_diff <0 then -1 when actual_estimate_diff =0 then 0 when actual_estimate_diff<5 then actual_estimate_diff when actual_estimate_diff>=5 then 6 else 7 end </SQL>
|
96 |
case when actual_estimate_diff <0 then -1 when actual_estimate_diff =0 then 0 when actual_estimate_diff<5 then actual_estimate_diff when actual_estimate_diff>=5 then 6 else 7 end </SQL>
|
| 97 |
</KeyExpression>
|
97 |
</KeyExpression>
|
| 98 |
<NameExpression>
|
98 |
<NameExpression>
|
| 99 |
<SQL dialect="generic">
|
99 |
<SQL dialect="generic">
|
| 100 |
case when actual_estimate_diff <0 then 'Before Time' when actual_estimate_diff =0 then 'On Time' when actual_estimate_diff<5 then concat('Delayed by ', actual_estimate_diff, ' days') when actual_estimate_diff>=5 then 'Delayed by 5 or more days' else '-' end </SQL>
|
100 |
case when actual_estimate_diff <0 then 'Before Time' when actual_estimate_diff =0 then 'On Time' when actual_estimate_diff<5 then concat('Delayed by ', convert(actual_estimate_diff, char), ' days') when actual_estimate_diff>=5 then 'Delayed by 5 or more days' else '-' end </SQL>
|
| 101 |
</NameExpression>
|
101 |
</NameExpression>
|
| 102 |
</Level>
|
102 |
</Level>
|
| 103 |
</Hierarchy>
|
103 |
</Hierarchy>
|
| 104 |
</Dimension>
|
104 |
</Dimension>
|
| 105 |
<Dimension type="StandardDimension" name="Logistics Provider">
|
105 |
<Dimension type="StandardDimension" name="Logistics Provider">
|
| Line 118... |
Line 118... |
| 118 |
</Level>
|
118 |
</Level>
|
| 119 |
</Hierarchy>
|
119 |
</Hierarchy>
|
| 120 |
</Dimension>
|
120 |
</Dimension>
|
| 121 |
<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment Mode">
|
121 |
<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment Mode">
|
| 122 |
<Hierarchy name="Payment Mode" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
|
122 |
<Hierarchy name="Payment Mode" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
|
| 123 |
<Table name="paymentmethod" alias="">
|
123 |
<Table name="paymentmethod">
|
| 124 |
</Table>
|
124 |
</Table>
|
| 125 |
<Level name="Payment Mode" column="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
125 |
<Level name="Payment Mode" column="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
| 126 |
<KeyExpression>
|
126 |
<KeyExpression>
|
| 127 |
<SQL dialect="generic">
|
127 |
<SQL dialect="generic">
|
| 128 |
case when gateway in ('ebs', 'hdfc', 'cheque') then 'prepaid' else gateway end </SQL>
|
128 |
case when gateway in ('ebs', 'hdfc', 'cheque') then 'prepaid' else gateway end </SQL>
|