Rev 3437 | Rev 3484 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<Schema name="SalesSchema"><Cube name="SalesCube" cache="true" enabled="true"><Table name="sales"></Table><Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate"><Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id"><Table name="datedim"></Table><Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"></Level><Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never"></Level><Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"></Level><Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="pincode" name="Geography"><Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode"><Table name="pincodesB"></Table><Level name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="status" name="OrderStatus"><Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status"><Table name="orderstatus"></Table><Level name="IsValid" column="isvalid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="Status" column="description" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="item_id" name="Product"><Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id"><Table name="item"></Table><Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="item_id" name="Category"><Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id"><Table name="item"></Table><Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level><Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="price_range" name="Price"><Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id"><Table name="pricerange" schema="" alias=""></Table><Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="payment_method" name="Payment"><Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid"><Table name="paymentmethod"></Table><Level name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level><Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" ordinalColumn="paymentmethodname" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" name="Order Hour"><Hierarchy name="Order Hour" hasAll="true" allMemberName="All"><Level name="Order Hour Range" table="sales" column="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"><KeyExpression><SQL dialect="generic">case when order_hour<6 then 0 when order_hour<12 then 6 when order_hour<15 then 12 when order_hour<18 then 15 else 18 end </SQL></KeyExpression><NameExpression><SQL dialect="generic">case when order_hour<6 then "0am - 6am" when order_hour<12 then "6am - 12pm" when order_hour<15 then "12pm - 15pm" when order_hour<18 then "15pm - 18pm" else "18pm - 24pm" end </SQL></NameExpression><OrdinalExpression><SQL dialect="generic">case when order_hour<6 then 0 when order_hour<12 then 6 when order_hour<15 then 12 when order_hour<18 then 15 else 18 end </SQL></OrdinalExpression></Level><Level name="Order Hour" table="sales" column="order_hour" ordinalColumn="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" foreignKey="customer_id" name="First Source"><Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id"><Table name="user"></Table><Level name="Source" column="source_type" nameColumn="source_type" ordinalColumn="source_type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level><Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" name="Promotion"><Hierarchy name="Promotion" hasAll="true" allMemberName="All"><Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" name="Session Source"><Hierarchy name="Session Source" hasAll="true" allMemberName="All"><Level name="Source" table="sales" column="session_source_type" nameColumn="session_source_type" ordinalColumn="session_source_type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level><Level name="Site" table="sales" column="session_source_url" nameColumn="session_source_url" ordinalColumn="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" name="Affiliate"><Hierarchy name="Affiliate" hasAll="true" allMemberName="All"><Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"></Level></Hierarchy></Dimension><Dimension type="StandardDimension" name="Days To Purchase"><Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All"><Level name="Days To Purchase" table="sales" column="days_to_purchase" ordinalColumn="days_to_purchase" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"><NameExpression><SQL dialect="generic">case when days_to_purchase>30 then '> month' when days_to_purchase>15 then '> 15 days' when days_to_purchase>7 then '> 7 days' when days_to_purchase>2 then '> 2 days' when days_to_purchase>1 then '> 1 day' else 'same day' end </SQL></NameExpression></Level></Hierarchy></Dimension><Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true"></Measure><Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true"></Measure><Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true"></Measure><Measure name="Transfer Price" column="transfer_price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true"></Measure><CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true"></CalculatedMember></Cube></Schema>