| Line 210... |
Line 210... |
| 210 |
</Level>
|
210 |
</Level>
|
| 211 |
<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
211 |
<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
| 212 |
</Level>
|
212 |
</Level>
|
| 213 |
</Hierarchy>
|
213 |
</Hierarchy>
|
| 214 |
</Dimension>
|
214 |
</Dimension>
|
| - |
|
215 |
<Dimension type="StandardDimension" name="Affiliate">
|
| - |
|
216 |
<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
|
| - |
|
217 |
<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
| - |
|
218 |
</Level>
|
| - |
|
219 |
</Hierarchy>
|
| - |
|
220 |
</Dimension>
|
| 215 |
<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
221 |
<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
| 216 |
</Measure>
|
222 |
</Measure>
|
| 217 |
<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
|
223 |
<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
|
| 218 |
</Measure>
|
224 |
</Measure>
|
| 219 |
<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
|
225 |
<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
|