Documentation for OLAP Database Adventure Works DW

1. Data Sources
   1. Adventure Works DW
2. Data Source Views
   1. Adventure Works DW
   2. Clustered Customers
   3. Subcategory Basket Analysis
3. Dimensions
   1. Promotion
   2. Product
   3. Customer
   4. Geography
   5. Reseller
   6. Sales Territory
   7. Employee
   8. Scenario
   9. Department
   10. Organization
   11. Account
   12. Date
   13. Source Currency
   14. Sales Reason
   15. Reseller Sales Order Details
   16. Internet Sales Order Details
   17. Clustered Customers
   18. Subcategory Basket Analysis
   19. Sales Channel
   20. Destination Currency
   21. Sales Summary Order Details
4. Cubes
   1. Adventure Works
   2. Mined Customers

DataSources (1):

DataSource Adventure Works DW

DataSourceViews (3):

DataSourceView Adventure Works DW

Data Tables

• dbo_DimCustomer
• dbo_DimEmployee
• dbo_DimGeography
• dbo_DimPromotion
• dbo_DimReseller
• dbo_DimTime
• FactSalesQuota
• dbo_DimAccount
• dbo_DimDepartmentGroup
• dbo_DimProductCategory
• dbo_DimSalesTerritory
• dbo_DimScenario
• dbo_FactFinance
• dbo_DimSalesReason
• dbo_FactInternetSalesReason
• dbo_FactCurrencyRate
• dbo_DimCurrency
• dbo_DimProductSubcategory
• dbo_DimOrganization
• dbo_vAssocSeqLineItems
• dbo_vAssocSeqOrders
• dbo_vTargetMail
• dbo_vTimeSeries
• dbo_DimProduct
• dbo_FactInternetSales
• dbo_FactResellerSales
• FactSalesSummary
• DimDestinationCurrency

DataSourceView Clustered Customers

Data Tables

• DIMENSION_CONTENT_ROWSET

DataSourceView Subcategory Basket Analysis

Data Tables

• DIMENSION_CONTENT_ROWSET

Dimensions (21)

Molap Dimension Promotion

Attributes (8):

• Key Attribute Promotion, Type: Promotion
• Regular Attribute Discount Percent, Type: Regular
• Regular Attribute Max Quantity, Type: QtyRangeHigh
• Regular Attribute Promotion Type, Type: Regular
• Regular Attribute Min Quantity, Type: QtyRangeLow
• Regular Attribute Promotion Category, Type: Regular
• Regular Attribute End Date, Type: DateEnded
• Regular Attribute Start Date, Type: DateStart

Hierarchies (1):

• Hierarchy Promotions
  1. Level Promotion Category, Attribute Promotion Category, HideOption Never
  2. Level Promotion Type, Attribute Promotion Type, HideOption OnlyChildWithParentName
  3. Level Promotion Name, Attribute Promotion, HideOption OnlyChildWithParentName

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Product

Attributes (22):

• Key Attribute Product, Type: Product
• Regular Attribute Standard Cost, Type: Regular
• Regular Attribute Category, Type: ProductCategory
• Regular Attribute Color, Type: Regular
• Regular Attribute Safety Stock Level, Type: Regular
• Regular Attribute Reorder Point, Type: Regular
• Regular Attribute List Price, Type: Regular
• Regular Attribute Size, Type: Regular
• Regular Attribute Size Range, Type: Regular
• Regular Attribute Weight, Type: Regular
• Regular Attribute Days to Manufacture, Type: Regular
• Regular Attribute Dealer Price, Type: Regular
• Regular Attribute Class, Type: Regular
• Regular Attribute Style, Type: Regular
• Regular Attribute Model Name, Type: Regular
• Regular Attribute Product Line, Type: Regular
• Regular Attribute Subcategory, Type: Regular
• Regular Attribute Status, Type: ScdStatus
• Regular Attribute Start Date, Type: ScdStartDate
• Regular Attribute End Date, Type: ScdEndDate
• Regular Attribute Product Key, Type: Regular
• Regular Attribute Large Photo, Type: Regular

Hierarchies (5):

• Hierarchy Product Model Categories
  1. Level Category, Attribute Category, HideOption Never
  2. Level Subcategory, Attribute Subcategory, HideOption Never
  3. Level Model Name, Attribute Model Name, HideOption Never
• Hierarchy Product Categories
  1. Level Category, Attribute Category, HideOption Never
  2. Level Subcategory, Attribute Subcategory, HideOption Never
  3. Level Product Name, Attribute Product, HideOption Never
• Hierarchy Manufacture Time
  1. Level Days to Manufacture, Attribute Days to Manufacture, HideOption Never
  2. Level Subcategory, Attribute Subcategory, HideOption Never
• Hierarchy Product Model Lines
  1. Level Product Line, Attribute Product Line, HideOption Never
  2. Level Model Name, Attribute Model Name, HideOption Never
• Hierarchy Stock Level
  1. Level Safety Stock Level, Attribute Safety Stock Level, HideOption Never
  2. Level Product, Attribute Product, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Customer

Attributes (21):

• Key Attribute Customer, Type: Customers
• Regular Attribute Postal Code, Type: PostalCode
• Regular Attribute Country, Type: Country
• Regular Attribute State-Province, Type: StateOrProvince
• Regular Attribute Birth Date, Type: Date
• Regular Attribute City, Type: City
• Regular Attribute Date of First Purchase, Type: Date
• Regular Attribute Phone, Type: PersonContact
• Regular Attribute Email Address, Type: PersonContact
• Regular Attribute Yearly Income, Type: Regular
• Regular Attribute Total Children, Type: Regular
• Regular Attribute Number of Cars Owned, Type: Regular
• Regular Attribute Number of Children At Home, Type: Regular
• Regular Attribute Education, Type: Regular
• Regular Attribute Occupation, Type: Regular
• Regular Attribute Marital Status, Type: Regular
• Regular Attribute Gender, Type: Regular
• Regular Attribute Home Owner, Type: Regular
• Regular Attribute Commute Distance, Type: Regular
• Regular Attribute Commute Distance Sort, Type: Regular
• Regular Attribute Address, Type: Address

Hierarchies (1):

• Hierarchy Customer Geography
  1. Level Country, Attribute Country, HideOption Never
  2. Level State-Province, Attribute State-Province, HideOption NoName
  3. Level City, Attribute City, HideOption Never
  4. Level Postal Code, Attribute Postal Code, HideOption Never
  5. Level Full Name, Attribute Customer, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Geography

Attributes (5):

• Regular Attribute City, Type: City
• Regular Attribute State-Province, Type: StateOrProvince
• Regular Attribute Country, Type: Country
• Regular Attribute Postal Code, Type: PostalCode
• Key Attribute Geography Key, Type: Regular

Hierarchies (1):

• Hierarchy Geography
  1. Level Country, Attribute Country, HideOption Never
  2. Level State-Province, Attribute State-Province, HideOption NoName
  3. Level City, Attribute City, HideOption Never
  4. Level Postal Code, Attribute Postal Code, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Reseller

Attributes (17):

• Key Attribute Reseller, Type: Channel
• Regular Attribute Product Line, Type: Regular
• Regular Attribute Phone, Type: Regular
• Regular Attribute Last Order Year, Type: Regular
• Regular Attribute Business Type, Type: Regular
• Regular Attribute First Order Year, Type: Regular
• Regular Attribute Number of Employees, Type: Regular
• Regular Attribute Year Opened, Type: Regular
• Regular Attribute Annual Sales, Type: Regular
• Regular Attribute Annual Revenue, Type: Regular
• Regular Attribute Bank Name, Type: Regular
• Regular Attribute Min Payment Amount, Type: Regular
• Regular Attribute Min Payment Type, Type: Regular
• Regular Attribute Order Frequency, Type: Regular
• Regular Attribute Order Month, Type: Regular
• Regular Attribute Geography Key, Type: Regular
• Regular Attribute Address, Type: Address

Hierarchies (4):

• Hierarchy Reseller Type
  1. Level Business Type, Attribute Business Type, HideOption Never
  2. Level Reseller Name, Attribute Reseller, HideOption Never
• Hierarchy Reseller Bank
  1. Level Bank Name, Attribute Bank Name, HideOption Never
  2. Level Reseller Name, Attribute Reseller, HideOption Never
• Hierarchy Reseller Order Frequency
  1. Level Order Frequency, Attribute Order Frequency, HideOption Never
  2. Level Reseller Name, Attribute Reseller, HideOption Never
• Hierarchy Reseller Order Month
  1. Level Order Month, Attribute Order Month, HideOption Never
  2. Level Reseller Name, Attribute Reseller, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Sales Territory

Attributes (3):

• Key Attribute Sales Territory Region, Type: Regular
• Regular Attribute Sales Territory Country, Type: Country
• Regular Attribute Sales Territory Group, Type: Regular

Hierarchies (1):

• Hierarchy Sales Territory
  1. Level Sales Territory Group, Attribute Sales Territory Group, HideOption Never
  2. Level Sales Territory Country, Attribute Sales Territory Country, HideOption OnlyChildWithParentName
  3. Level Sales Territory Region, Attribute Sales Territory Region, HideOption OnlyChildWithParentName

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Employee

Attributes (26):

• Key Attribute Employee, Type: Regular
• Regular Attribute Department Name, Type: Regular
• Regular Attribute Sales Person Flag, Type: Regular
• Regular Attribute Title, Type: Regular
• Regular Attribute Hire Date, Type: Date
• Regular Attribute Sick Leave Hours, Type: Regular
• Regular Attribute Birth Date, Type: Regular
• Regular Attribute Vacation Hours, Type: Regular
• Regular Attribute Login ID, Type: Regular
• Regular Attribute Base Rate, Type: Regular
• Regular Attribute Email Address, Type: PersonContact
• Regular Attribute Pay Frequency, Type: Regular
• Regular Attribute Phone, Type: PersonContact
• Regular Attribute Salaried Flag, Type: Regular
• Regular Attribute Emergency Contact Name, Type: Regular
• Regular Attribute Emergency Contact Phone, Type: Regular
• Regular Attribute Gender, Type: Regular
• Regular Attribute Marital Status, Type: Regular
• Regular Attribute Sales Territory Key, Type: Regular
• Regular Attribute SSN, Type: Regular
• Regular Attribute Manager SSN, Type: Regular
• Parent Attribute Employees, Type: Person
• Regular Attribute Status, Type: ScdStatus
• Regular Attribute Start Date, Type: ScdStartDate
• Regular Attribute End Date, Type: ScdEndDate
• Regular Attribute Hire Year, Type: Years

Hierarchies (1):

• Hierarchy Employee Department
  1. Level Department Name, Attribute Department Name, HideOption Never
  2. Level Title, Attribute Title, HideOption Never
  3. Level Full Name, Attribute Employee, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Scenario

Attributes (1):

• Key Attribute Scenario, Type: Scenario

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Department

Attributes (2):

• Parent Attribute Departments, Type: Regular
• Key Attribute Department, Type: Regular

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Organization

Attributes (3):

• Parent Attribute Organizations, Type: OrgTitle
• Key Attribute Organization, Type: Regular
• Regular Attribute Currency Code, Type: CurrencyIsoCode

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Account

Attributes (4):

• Parent Attribute Accounts, Type: Account
• Key Attribute Account, Type: AccountName
• Regular Attribute Account Type, Type: AccountType
• Regular Attribute Account Number, Type: AccountNumber

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Date

Attributes (18):

• Regular Attribute Fiscal Year, Type: FiscalYears
• Key Attribute Date, Type: Date
• Regular Attribute Calendar Quarter, Type: Quarters
• Regular Attribute Fiscal Quarter, Type: FiscalQuarters
• Regular Attribute Calendar Semester, Type: HalfYears
• Regular Attribute Fiscal Semester, Type: FiscalHalfYears
• Regular Attribute Day of Week, Type: DayOfWeek
• Regular Attribute Day Name, Type: Days
• Regular Attribute Day of Month, Type: DayOfMonth
• Regular Attribute Day of Year, Type: DayOfYear
• Regular Attribute Week of Year, Type: WeekOfYear
• Regular Attribute Month Name, Type: Months
• Regular Attribute Calendar Year, Type: Years
• Regular Attribute Fiscal Semester of Year, Type: FiscalHalfYearOfYear
• Regular Attribute Calendar Semester of Year, Type: HalfYearOfYear
• Regular Attribute Fiscal Quarter of Year, Type: FiscalQuarterOfYear
• Regular Attribute Calendar Quarter of Year, Type: QuarterOfYear
• Regular Attribute Month of Year, Type: Regular

Hierarchies (2):

• Hierarchy Fiscal
  1. Level Fiscal Year, Attribute Fiscal Year, HideOption Never
  2. Level Fiscal Semester, Attribute Fiscal Semester, HideOption Never
  3. Level Fiscal Quarter, Attribute Fiscal Quarter, HideOption Never
  4. Level Month, Attribute Month Name, HideOption Never
  5. Level Date, Attribute Date, HideOption Never
• Hierarchy Calendar
  1. Level Calendar Year, Attribute Calendar Year, HideOption Never
  2. Level Calendar Semester, Attribute Calendar Semester, HideOption Never
  3. Level Calendar Quarter, Attribute Calendar Quarter, HideOption Never
  4. Level Month, Attribute Month Name, HideOption Never
  5. Level Date, Attribute Date, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Source Currency

Attributes (2):

• Key Attribute Source Currency Code, Type: CurrencyIsoCode
• Regular Attribute Source Currency, Type: CurrencySource

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Sales Reason

Attributes (2):

• Key Attribute Sales Reason, Type: Regular
• Regular Attribute Sales Reason Type, Type: Regular

Hierarchies (1):

• Hierarchy Sales Reasons
  1. Level Sales Reason Type, Attribute Sales Reason Type, HideOption Never
  2. Level Sales Reason, Attribute Sales Reason, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Rolap Dimension Reseller Sales Order Details

Attributes (5):

• Key Attribute Reseller Sales Order, Type: Regular
• Regular Attribute Carrier Tracking Number, Type: Regular
• Regular Attribute Customer PO Number, Type: Regular
• Regular Attribute Sales Order Number, Type: Regular
• Regular Attribute Sales Order Line, Type: Regular

Hierarchies (1):

• Hierarchy Reseller Sales Orders
  1. Level Order Number, Attribute Sales Order Number, HideOption Never
  2. Level Order Line, Attribute Reseller Sales Order, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Rolap Dimension Internet Sales Order Details

Attributes (5):

• Key Attribute Internet Sales Order, Type: Regular
• Regular Attribute Carrier Tracking Number, Type: Regular
• Regular Attribute Customer PO Number, Type: Regular
• Regular Attribute Sales Order Number, Type: Regular
• Regular Attribute Sales Order Line, Type: Regular

Hierarchies (1):

• Hierarchy Internet Sales Orders
  1. Level Order Number, Attribute Sales Order Number, HideOption Never
  2. Level Internet Sales Order, Attribute Internet Sales Order, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Clustered Customers

Attributes (3):

• Regular Attribute Attribute Name, Type: Regular
• Parent Attribute Customer Clusters, Type: Regular
• Key Attribute Node Unique Name, Type: Regular

Hierarchies (0):

Translations:

1. French (France)
2. Spanish (Spain)

Molap Dimension Subcategory Basket Analysis

Attributes (3):

• Regular Attribute Attribute Name, Type: Regular
• Parent Attribute Subcategory Baskets, Type: Regular
• Key Attribute Node Unique Name, Type: Regular

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Sales Channel

Attributes (1):

• Key Attribute Sales Channel, Type: Regular

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Molap Dimension Destination Currency

Attributes (2):

• Regular Attribute Destination Currency, Type: CurrencyDestination
• Key Attribute Destination Currency Code, Type: CurrencyIsoCode

Hierarchies (0):

Translations:

1. Spanish (Spain)
2. French (France)

Rolap Dimension Sales Summary Order Details

Attributes (5):

• Key Attribute Sales Order, Type: Regular
• Regular Attribute Carrier Tracking Number, Type: Regular
• Regular Attribute Customer PO Number, Type: Regular
• Regular Attribute Sales Order Number, Type: Regular
• Regular Attribute Sales Order Line, Type: Regular

Hierarchies (1):

• Hierarchy Sales Orders
  1. Level Order Number, Attribute Sales Order Number, HideOption Never
  2. Level Order Line, Attribute Sales Order Line, HideOption Never

Translations:

1. Spanish (Spain)
2. French (France)

Cubes (2):

Cube Adventure Works

MeasureGroups (11):

• MeasureGroup Internet Sales Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 60398
  

  Measures (9):

  • Measure Internet Sales Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.SalesAmount, MeasureExpression: [Internet Sales Amount] / [Average Rate]
  • Measure Internet Order Quantity, AggregationFunction: Sum, DataType: Integer, FormatString #,#, DataSource: dbo_FactInternetSales.OrderQuantity
  • Measure Internet Extended Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.ExtendedAmount, MeasureExpression: [Internet Extended Amount] / [Average Rate]
  • Measure Internet Tax Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.TaxAmt, MeasureExpression: [Internet Tax Amount] / [Average Rate]
  • Measure Internet Freight Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.Freight, MeasureExpression: [Internet Freight Cost] / [Average Rate]
  • Measure Internet Unit Price, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.UnitPrice, MeasureExpression: [Internet Unit Price] / [Average Rate]
  • Measure Internet Total Product Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.TotalProductCost, MeasureExpression: [Internet Total Product Cost] / [Average Rate]
  • Measure Internet Standard Product Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactInternetSales.ProductStandardCost, MeasureExpression: [Internet Standard Product Cost] / [Average Rate]
  • Measure Internet Transaction Count, AggregationFunction: Count, DataType: Integer, FormatString #,#, DataSource: Count(%0)
  
  
  Mapping of cube dimensions onto dimensions:
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Internet Sales Order Details -> Internet Sales Order Details
  • Sales Reason -> Sales Reason
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Customer -> Customer
  • Source Currency -> Source Currency
  • Destination Currency -> Destination Currency
  
  
  Partitions (5):
  • Internet_Sales_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:11 AM, Estimated Size (Kb): 29642, Estimated rows: 1013
  • Internet_Sales_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:27 AM, Estimated Size (Kb): 78911, Estimated rows: 2677
  • Internet_Sales_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:30 AM, Estimated Size (Kb): 982882, Estimated rows: 32265
  • Internet_Sales_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:25 AM, Estimated Size (Kb): 1139395, Estimated rows: 32265
  • Fact Internet Sales, StorageMode: Molap, Type: Data, LastProcessed: 31/Dec/99 1:00:00 AM, Estimated Size (Kb): 0, Estimated rows: 0
  
  
• MeasureGroup Internet Orders Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (1):

  • Measure Internet Order Count, AggregationFunction: DistinctCount, DataType: Integer, FormatString #,#, DataSource: dbo_FactInternetSales.SalesOrderNumber
  
  
  Mapping of cube dimensions onto dimensions:
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Internet Sales Order Details -> Internet Sales Order Details
  • Sales Reason -> Sales Reason
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Customer -> Customer
  • Source Currency -> Source Currency
  
  
  Partitions (4):
  • Internet_Orders_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:16 AM, Estimated Size (Kb): 32637, Estimated rows: 0
  • Internet_Orders_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:27 AM, Estimated Size (Kb): 86898, Estimated rows: 0
  • Internet_Orders_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:29 AM, Estimated Size (Kb): 754967, Estimated rows: 0
  • Internet_Orders_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:30 AM, Estimated Size (Kb): 880901, Estimated rows: 0
  
  
• MeasureGroup Internet Customers Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (1):

  • Measure Customer Count, AggregationFunction: DistinctCount, DataType: Integer, FormatString #,#, DataSource: dbo_FactInternetSales.CustomerKey
  
  
  Mapping of cube dimensions onto dimensions:
  • Customer -> Customer
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Internet Sales Order Details -> Internet Sales Order Details
  • Sales Reason -> Sales Reason
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Source Currency -> Source Currency
  
  
  Partitions (4):
  • Customers_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:27 AM, Estimated Size (Kb): 10307, Estimated rows: 0
  • Customers_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:27 AM, Estimated Size (Kb): 27960, Estimated rows: 0
  • Customers_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:26 AM, Estimated Size (Kb): 526739, Estimated rows: 0
  • Customers_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:20 AM, Estimated Size (Kb): 595948, Estimated rows: 0
  
  
• MeasureGroup Sales Reasons Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (1):

  • Measure Sales Reason Count, AggregationFunction: Count, DataType: Integer, FormatString #, DataSource: Count(%0)
  
  
  Mapping of cube dimensions onto dimensions:
  • Sales Reason -> Sales Reason
  • Internet Sales Order Details -> Internet Sales Order Details
  
  
  Partitions (1):
  • Internet_Sales_Reasons, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:16 AM, Estimated Size (Kb): 1034, Estimated rows: 0
  
  
• MeasureGroup Reseller Sales Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 60855
  

  Measures (11):

  • Measure Reseller Sales Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.SalesAmount, MeasureExpression: [Reseller Sales Amount] / [Average Rate]
  • Measure Reseller Order Quantity, AggregationFunction: Sum, DataType: Integer, FormatString #,#, DataSource: dbo_FactResellerSales.OrderQuantity
  • Measure Reseller Extended Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.ExtendedAmount, MeasureExpression: [Reseller Extended Amount] / [Average Rate]
  • Measure Reseller Tax Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.TaxAmt, MeasureExpression: [Reseller Tax Amount] / [Average Rate]
  • Measure Reseller Freight Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.Freight, MeasureExpression: [Reseller Freight Cost] / [Average Rate]
  • Measure Discount Amount, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: dbo_FactResellerSales.DiscountAmount, MeasureExpression: [Discount Amount] / [Average Rate]
  • Measure Reseller Unit Price, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.UnitPrice, MeasureExpression: [Reseller Unit Price] / [Average Rate]
  • Measure Unit Price Discount Percent, AggregationFunction: None, DataType: Double, FormatString Percent, DataSource: dbo_FactResellerSales.UnitPriceDiscountPct
  • Measure Reseller Total Product Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.TotalProductCost, MeasureExpression: [Reseller Total Product Cost] / [Average Rate]
  • Measure Reseller Standard Product Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: dbo_FactResellerSales.ProductStandardCost, MeasureExpression: [Reseller Standard Product Cost] / [Average Rate]
  • Measure Reseller Transaction Count, AggregationFunction: Count, DataType: Integer, FormatString #,#, DataSource: Count(%0)
  
  
  Mapping of cube dimensions onto dimensions:
  • Employee -> Employee
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Reseller -> Reseller
  • Reseller Sales Order Details -> Reseller Sales Order Details
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Geography -> Geography
  • Source Currency -> Source Currency
  • Destination Currency -> Destination Currency
  
  
  Partitions (4):
  • Reseller_Sales_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:18 AM, Estimated Size (Kb): 303451, Estimated rows: 4138
  • Reseller_Sales_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:26 AM, Estimated Size (Kb): 800535, Estimated rows: 16676
  • Reseller_Sales_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:30 AM, Estimated Size (Kb): 1222575, Estimated rows: 26758
  • Reseller_Sales_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:32 AM, Estimated Size (Kb): 672047, Estimated rows: 13283
  
  
• MeasureGroup Reseller Orders Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (1):

  • Measure Reseller Order Count, AggregationFunction: DistinctCount, DataType: Integer, FormatString #,#, DataSource: dbo_FactResellerSales.SalesOrderNumber
  
  
  Mapping of cube dimensions onto dimensions:
  • Reseller -> Reseller
  • Employee -> Employee
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Geography -> Geography
  • Reseller Sales Order Details -> Reseller Sales Order Details
  • Source Currency -> Source Currency
  
  
  Partitions (4):
  • Reseller_Orders_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:30 AM, Estimated Size (Kb): 139083, Estimated rows: 0
  • Reseller_Orders_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:31 AM, Estimated Size (Kb): 328959, Estimated rows: 0
  • Reseller_Orders_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:33 AM, Estimated Size (Kb): 478708, Estimated rows: 0
  • Reseller_Orders_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:17 AM, Estimated Size (Kb): 273959, Estimated rows: 0
  
  
• MeasureGroup Sales Summary Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 121253
  

  Measures (9):

  • Measure Order Quantity, AggregationFunction: Sum, DataType: Integer, FormatString #,#, DataSource: FactSalesSummary.OrderQuantity
  • Measure Unit Price, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.UnitPrice, MeasureExpression: [Unit Price] / [Average Rate]
  • Measure Extended Amount, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.ExtendedAmount, MeasureExpression: [Extended Amount] / [Average Rate]
  • Measure Standard Product Cost, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.ProductStandardCost, MeasureExpression: [Standard Product Cost] / [Average Rate]
  • Measure Total Product Cost, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.TotalProductCost, MeasureExpression: [Total Product Cost] / [Average Rate]
  • Measure Sales Amount, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.SalesAmount, MeasureExpression: [Sales Amount] / [Average Rate]
  • Measure Tax Amount, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.TaxAmt, MeasureExpression: [Tax Amount] / [Average Rate]
  • Measure Freight Cost, AggregationFunction: Sum, DataType: Double, FormatString Currency, DataSource: FactSalesSummary.Freight, MeasureExpression: [Freight Cost] / [Average Rate]
  • Measure Transaction Count, AggregationFunction: Count, DataType: Integer, FormatString #,#, DataSource: Count(%0)
  
  
  Mapping of cube dimensions onto dimensions:
  • Sales Summary Order Details -> Sales Summary Order Details
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Sales Channel -> Sales Channel
  • Source Currency -> Source Currency
  • Destination Currency -> Destination Currency
  
  
  Partitions (4):
  • Total_Sales_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:26 AM, Estimated Size (Kb): 80094, Estimated rows: 5151
  • Total_Sales_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:29 AM, Estimated Size (Kb): 441647, Estimated rows: 19353
  • Total_Sales_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:26 AM, Estimated Size (Kb): 1144909, Estimated rows: 51201
  • Total_Sales_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:15 AM, Estimated Size (Kb): 1118408, Estimated rows: 51201
  
  
• MeasureGroup Sales Orders Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (1):

  • Measure Order Count, AggregationFunction: DistinctCount, DataType: Integer, FormatString #,#, DataSource: FactSalesSummary.SalesOrderNumber
  
  
  Mapping of cube dimensions onto dimensions:
  • Sales Summary Order Details -> Sales Summary Order Details
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Product -> Product
  • Promotion -> Promotion
  • Sales Territory -> Sales Territory
  • Sales Channel -> Sales Channel
  • Source Currency -> Source Currency
  
  
  Partitions (4):
  • Total_Orders_2001, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:22 AM, Estimated Size (Kb): 133590, Estimated rows: 0
  • Total_Orders_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:29 AM, Estimated Size (Kb): 332047, Estimated rows: 0
  • Total_Orders_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:29 AM, Estimated Size (Kb): 831851, Estimated rows: 0
  • Total_Orders_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:15 AM, Estimated Size (Kb): 801419, Estimated rows: 0
  
  
• MeasureGroup Sales Targets Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (1):

  • Measure Sales Amount Quota, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: FactSalesQuota.SalesAmountQuota
  
  
  Mapping of cube dimensions onto dimensions:
  • Employee -> Employee
  • Date -> Date
  • Sales Territory -> Sales Territory
  
  
  Partitions (1):
  • Sales_Quotas, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:16 AM, Estimated Size (Kb): 1514, Estimated rows: 0
  
  
• MeasureGroup Financial Reporting Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 39409
  

  Measures (1):

  • Measure Amount, AggregationFunction: ByAccount, DataType: Double, FormatString Currency, DataSource: dbo_FactFinance.Amount
  
  
  Mapping of cube dimensions onto dimensions:
  • Scenario -> Scenario
  • Organization -> Organization
  • Department -> Department
  • Account -> Account
  • Date -> Date
  • Destination Currency -> Destination Currency
  
  
  Partitions (1):
  • Finance, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:20 AM, Estimated Size (Kb): 373438, Estimated rows: 39409
  
  
• MeasureGroup Exchange Rates Created: 24/Apr/06 8:53:09 AM, Last processed 24/Apr/06 8:56:34 AM, Estimated rows: 0
  

  Measures (2):

  • Measure Average Rate, AggregationFunction: AverageOfChildren, DataType: Double, FormatString #,#.00, DataSource: dbo_FactCurrencyRate.AverageRate
  • Measure End of Day Rate, AggregationFunction: LastNonEmpty, DataType: Double, FormatString #,#.00, DataSource: dbo_FactCurrencyRate.EndOfDayRate
  
  
  Mapping of cube dimensions onto dimensions:
  • Date -> Date
  • Destination Currency -> Destination Currency
  
  
  Partitions (1):
  • Currency_Rates, StorageMode: Molap, Type: Data, LastProcessed: 24/Apr/06 8:56:17 AM, Estimated Size (Kb): 289223, Estimated rows: 0
  
  

Translations:

1. Spanish (Spain)
2. French (France)

Cube Mined Customers

MeasureGroups (5):

• Linked MeasureGroup Internet Sales Created: 24/Apr/06 8:53:24 AM, Last processed 24/Apr/06 8:57:29 AM, Estimated rows: 0
  

  Measures (9):

  • Linked Measure Internet Sales Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Sales Amount 2, MeasureExpression: [Internet Sales Amount] / [Average Rate]
  • Linked Measure Internet Order Quantity, AggregationFunction: Sum, DataType: Integer, FormatString #,#, DataSource: Order Quantity 2
  • Linked Measure Internet Extended Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Extended Amount 2, MeasureExpression: [Internet Extended Amount] / [Average Rate]
  • Linked Measure Internet Tax Amount, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Tax Amt 2, MeasureExpression: [Internet Tax Amount] / [Average Rate]
  • Linked Measure Internet Freight Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Freight 2, MeasureExpression: [Internet Freight Cost] / [Average Rate]
  • Linked Measure Internet Unit Price, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Unit Price 2, MeasureExpression: [Internet Unit Price] / [Average Rate]
  • Linked Measure Internet Total Product Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Total Product Cost 2, MeasureExpression: [Internet Total Product Cost] / [Average Rate]
  • Linked Measure Internet Standard Product Cost, AggregationFunction: Sum, DataType: Currency, FormatString Currency, DataSource: Product Standard Cost 2, MeasureExpression: [Internet Standard Product Cost] / [Average Rate]
  • Linked Measure Internet Transaction Count, AggregationFunction: Count, DataType: Integer, FormatString #,#, DataSource: Product Key
  
  
  Mapping of cube dimensions onto dimensions:
  • Promotion -> Promotion
  • Product -> Product
  • Customer -> Customer
  • Sales Territory -> Sales Territory
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Source Currency -> Source Currency
  • Internet Sales Order Details -> Internet Sales Order Details
  • Sales Reason -> Sales Reason
  • Destination Currency -> Destination Currency
  • Clustered Customers -> Clustered Customers
  • Subcategory Basket Analysis -> Subcategory Basket Analysis
  
  
  Partitions (0):
  
  
• Linked MeasureGroup Internet Orders Created: 24/Apr/06 8:53:24 AM, Last processed 24/Apr/06 8:57:29 AM, Estimated rows: 0
  

  Measures (1):

  • Linked Measure Internet Order Count, AggregationFunction: DistinctCount, DataType: Integer, FormatString #,#, DataSource: Sales Order Number
  
  
  Mapping of cube dimensions onto dimensions:
  • Promotion -> Promotion
  • Product -> Product
  • Customer -> Customer
  • Sales Territory -> Sales Territory
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Source Currency -> Source Currency
  • Internet Sales Order Details -> Internet Sales Order Details
  • Sales Reason -> Sales Reason
  • Clustered Customers -> Clustered Customers
  • Subcategory Basket Analysis -> Subcategory Basket Analysis
  
  
  Partitions (0):
  
  
• Linked MeasureGroup Internet Customers Created: 24/Apr/06 8:53:24 AM, Last processed 24/Apr/06 8:57:29 AM, Estimated rows: 0
  

  Measures (1):

  • Linked Measure Customer Count, AggregationFunction: DistinctCount, DataType: Integer, FormatString #,#, DataSource: Customer Key
  
  
  Mapping of cube dimensions onto dimensions:
  • Promotion -> Promotion
  • Product -> Product
  • Customer -> Customer
  • Sales Territory -> Sales Territory
  • Date -> Date
  • Ship Date -> Date
  • Delivery Date -> Date
  • Source Currency -> Source Currency
  • Internet Sales Order Details -> Internet Sales Order Details
  • Sales Reason -> Sales Reason
  • Clustered Customers -> Clustered Customers
  • Subcategory Basket Analysis -> Subcategory Basket Analysis
  
  
  Partitions (0):
  
  
• Linked MeasureGroup Sales Reasons Created: 24/Apr/06 8:53:24 AM, Last processed 24/Apr/06 8:57:29 AM, Estimated rows: 0
  

  Measures (1):

  • Linked Measure Sales Reason Count, AggregationFunction: Count, DataType: Integer, FormatString #, DataSource: Fact Internet Sales Reason - Count
  
  
  Mapping of cube dimensions onto dimensions:
  • Sales Reason -> Sales Reason
  • Internet Sales Order Details -> Internet Sales Order Details
  
  
  Partitions (0):
  
  
• Linked MeasureGroup Exchange Rates Created: 24/Apr/06 8:53:24 AM, Last processed 24/Apr/06 8:57:29 AM, Estimated rows: 0
  

  Measures (2):

  • Linked Measure Average Rate, AggregationFunction: AverageOfChildren, DataType: Double, FormatString #,#.00, DataSource: Average Rate
  • Linked Measure End of Day Rate, AggregationFunction: LastNonEmpty, DataType: Double, FormatString #,#.00, DataSource: End Of Day Rate
  
  
  Mapping of cube dimensions onto dimensions:
  • Date -> Date
  • Destination Currency -> Destination Currency
  
  
  Partitions (0):
  
  

Translations:

1. Spanish (Spain)
2. French (France)

This documentation is generated by ASDoc Free Edition V0.91 Beta. For updates or new releases, check http://www.u2u.be.