Subversion Repositories SmartDukaan

Rev

Rev 4033 | Rev 5200 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4033 Rev 5161
Line 4... Line 4...
4 
		</Table>
 4 
		</Table>
5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
 5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
 6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
7 
				<Table name="datedim">
 7 
				<Table name="datedim">
8 
				</Table>
 8 
				</Table>
9 
				<Level approxRowCount="2" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
 9 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
- 
 
 10 
				</Level>
- 
 
 11 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
- 
 
 12 
				</Level>
- 
 
 13 
				<Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
- 
 
 14 
				</Level>
- 
 
 15 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
- 
 
 16 
				</Level>
- 
 
 17 
			</Hierarchy>
- 
 
 18 
		</Dimension>
- 
 
 19 
		<Dimension type="TimeDimension" foreignKey="booking_date_id" name="BookingDate">
- 
 
 20 
			<Hierarchy name="BookingDate" hasAll="true" allMemberName="All" primaryKey="date_id">
- 
 
 21 
				<Table name="datedim">
- 
 
 22 
				</Table>
- 
 
 23 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
10 
				</Level>
 24 
				</Level>
11 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
 25 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
12 
				</Level>
 26 
				</Level>
13 
				<Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
 27 
				<Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
14 
				</Level>
 28 
				</Level>
Line 30... Line 44...
30 
		</Dimension>
 44 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
 45 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
32 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
 46 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
33 
				<Table name="orderstatus">
 47 
				<Table name="orderstatus">
34 
				</Table>
 48 
				</Table>
35 
				<Level name="IsValid" column="isvalid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 49 
				<Level name="isValid" column="isValid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
 50 
				</Level>
37 
				<Level name="Status" column="description" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 51 
				<Level name="StatusGroup" column="statusGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
 52 
				</Level>
39 
			</Hierarchy>
 - 
 
40 
		</Dimension>
 - 
 
41 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
 - 
 
42 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
 - 
 
43 
				<Table name="item">
 - 
 
44 
				</Table>
 - 
 
45 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 53 
				<Level name="StatusSubGroup" column="statusSubGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
46 
				</Level>
 54 
				</Level>
47 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 55 
				<Level name="StatusName" column="statusName" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
48 
				</Level>
 - 
 
49 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
50 
				</Level>
 56 
				</Level>
51 
			</Hierarchy>
 57 
			</Hierarchy>
- 
 
 58 
		</Dimension>
- 
 
 59 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
52 
			<Hierarchy name="Product Name" hasAll="true" primaryKey="id">
 60 
			<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
53 
				<Table name="item">
 61 
				<Table name="item">
54 
				</Table>
 62 
				</Table>
55 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 63 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
56 
				</Level>
 64 
				</Level>
57 
				<Level name="Product" column="id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 65 
				<Level name="Product" column="id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
Line 154... Line 162...
154 
				</Table>
 162 
				</Table>
155 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 163 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
156 
				</Level>
 164 
				</Level>
157 
			</Hierarchy>
 165 
			</Hierarchy>
158 
		</Dimension>
 166 
		</Dimension>
159 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 167 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="##,###" aggregator="sum" visible="true">
160 
		</Measure>
 - 
 
161 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 - 
 
162 
		</Measure>
 168 
		</Measure>
163 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 169 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
164 
		</Measure>
 170 
		</Measure>
165 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 171 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
166 
			<MeasureExpression>
 172 
			<MeasureExpression>
Line 168... Line 174...
168 
					transfer_price*quantity				</SQL>
 174 
					transfer_price*quantity				</SQL>
169 
			</MeasureExpression>
 175 
			</MeasureExpression>
170 
		</Measure>
 176 
		</Measure>
171 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
 177 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
172 
		</CalculatedMember>
 178 
		</CalculatedMember>
- 
 
 179 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
- 
 
 180 
		</CalculatedMember>
173 
	</Cube>
 181 
	</Cube>
174 
</Schema>
 182 
</Schema>