Documentation for OLAP Database Adventure Works DW

+Molap Dimension Promotion

+Molap Dimension Product

+Molap Dimension Customer

+Molap Dimension Geography

+Molap Dimension Reseller

+Molap Dimension Sales Territory

+Molap Dimension Employee

+Molap Dimension Scenario

+Molap Dimension Department

+Molap Dimension Organization

+Molap Dimension Account

+Molap Dimension Date

+Molap Dimension Source Currency

+Molap Dimension Sales Reason

+Rolap Dimension Reseller Sales Order Details

+Rolap Dimension Internet Sales Order Details

+Molap Dimension Clustered Customers

+Molap Dimension Subcategory Basket Analysis

+Molap Dimension Sales Channel

+Molap Dimension Destination Currency

+Rolap Dimension Sales Summary Order Details

+ Cubes (2):

+Cube Adventure Works

Created: 24/04/2006 8:53:09, Last processed: 24/04/2006 8:56:34.

Default measure: [Measures].[Reseller Sales Amount]

MeasureGroups (11):

MeasureGroup Internet Sales Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:11, Estimated Size (Kb): 29624, Estimated rows: 1013
- Internet_Sales_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:27, Estimated Size (Kb): 78893, Estimated rows: 2677
- Internet_Sales_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:30, Estimated Size (Kb): 982846, Estimated rows: 32265
- Internet_Sales_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:25, Estimated Size (Kb): 1139359, Estimated rows: 32265
- Fact Internet Sales, StorageMode: Molap, Type: Data, LastProcessed: 31/12/1699 1:00:00, Estimated Size (Kb): 0, Estimated rows: 0
MeasureGroup Internet Orders Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:16, Estimated Size (Kb): 32637, Estimated rows: 0
- Internet_Orders_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:27, Estimated Size (Kb): 86898, Estimated rows: 0
- Internet_Orders_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:29, Estimated Size (Kb): 754967, Estimated rows: 0
- Internet_Orders_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:30, Estimated Size (Kb): 880901, Estimated rows: 0
MeasureGroup Internet Customers Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:27, Estimated Size (Kb): 10307, Estimated rows: 0
- Customers_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:27, Estimated Size (Kb): 27960, Estimated rows: 0
- Customers_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:26, Estimated Size (Kb): 526739, Estimated rows: 0
- Customers_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:20, Estimated Size (Kb): 595948, Estimated rows: 0
MeasureGroup Sales Reasons Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:16, Estimated Size (Kb): 1034, Estimated rows: 0
MeasureGroup Reseller Sales Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:18, Estimated Size (Kb): 303424, Estimated rows: 4138
- Reseller_Sales_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:26, Estimated Size (Kb): 800508, Estimated rows: 16676
- Reseller_Sales_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:30, Estimated Size (Kb): 1222548, Estimated rows: 26758
- Reseller_Sales_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:32, Estimated Size (Kb): 672020, Estimated rows: 13283
MeasureGroup Reseller Orders Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:30, Estimated Size (Kb): 139092, Estimated rows: 0
- Reseller_Orders_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:31, Estimated Size (Kb): 328968, Estimated rows: 0
- Reseller_Orders_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:33, Estimated Size (Kb): 478717, Estimated rows: 0
- Reseller_Orders_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:17, Estimated Size (Kb): 273968, Estimated rows: 0
MeasureGroup Sales Summary Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:26, Estimated Size (Kb): 80076, Estimated rows: 5151
- Total_Sales_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:29, Estimated Size (Kb): 441629, Estimated rows: 19353
- Total_Sales_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:26, Estimated Size (Kb): 1144891, Estimated rows: 51201
- Total_Sales_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:15, Estimated Size (Kb): 1118390, Estimated rows: 51201
MeasureGroup Sales Orders Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:22, Estimated Size (Kb): 133608, Estimated rows: 0
- Total_Orders_2002, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:29, Estimated Size (Kb): 332065, Estimated rows: 0
- Total_Orders_2003, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:29, Estimated Size (Kb): 831869, Estimated rows: 0
- Total_Orders_2004, StorageMode: Molap, Type: Data, LastProcessed: 24/04/2006 8:56:15, Estimated Size (Kb): 801437, Estimated rows: 0
MeasureGroup Sales Targets Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:16, Estimated Size (Kb): 1496, Estimated rows: 0
MeasureGroup Financial Reporting Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:20, Estimated Size (Kb): 373438, Estimated rows: 39409
MeasureGroup Exchange Rates Created: 24/04/2006 8:53:09, Last processed 24/04/2006 8:56:34, 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/04/2006 8:56:17, Estimated Size (Kb): 289241, Estimated rows: 0

Translations:

Spanish (Spain)
French (France)

+Cube Mined Customers

Created: 24/04/2006 8:53:24, Last processed: 24/04/2006 8:57:29.

Default measure: [Measures].[Internet Sales Amount]

MeasureGroups (5):

Linked MeasureGroup Internet Sales Created: 24/04/2006 8:53:24, Last processed 24/04/2006 8:57:29, 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/04/2006 8:53:24, Last processed 24/04/2006 8:57:29, 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/04/2006 8:53:24, Last processed 24/04/2006 8:57:29, 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/04/2006 8:53:24, Last processed 24/04/2006 8:57:29, 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/04/2006 8:53:24, Last processed 24/04/2006 8:57:29, 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:

Spanish (Spain)
French (France)

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

Documentation for OLAP Database Adventure Works DW

+ DataSources (1):

+ DataSource Adventure Works DW

+ DataSourceViews (3):

+DataSourceView Adventure Works DW

Data Tables

+DataSourceView Clustered Customers

Data Tables

+DataSourceView Subcategory Basket Analysis

Data Tables

+ Dimensions (21)

+Molap Dimension Promotion

Attributes (8):

Hierarchies (1):

Translations:

+Molap Dimension Product

Attributes (22):

Hierarchies (5):

Translations:

+Molap Dimension Customer

Attributes (21):

Hierarchies (1):

Translations:

+Molap Dimension Geography

Attributes (5):

Hierarchies (1):

Translations:

+Molap Dimension Reseller

Attributes (17):

Hierarchies (4):

Translations:

+Molap Dimension Sales Territory

Attributes (3):

Hierarchies (1):

Translations:

+Molap Dimension Employee

Attributes (26):

Hierarchies (1):

Translations:

+Molap Dimension Scenario

Attributes (1):

Hierarchies (0):

Translations:

+Molap Dimension Department

Attributes (2):

Hierarchies (0):

Translations:

+Molap Dimension Organization

Attributes (3):

Hierarchies (0):

Translations:

+Molap Dimension Account

Attributes (4):

Hierarchies (0):

Translations:

+Molap Dimension Date

Attributes (18):

Hierarchies (2):

Translations:

+Molap Dimension Source Currency

Attributes (2):

Hierarchies (0):

Translations:

+Molap Dimension Sales Reason

Attributes (2):

Hierarchies (1):

Translations:

+Rolap Dimension Reseller Sales Order Details

Attributes (5):

Hierarchies (1):

Translations:

+Rolap Dimension Internet Sales Order Details

Attributes (5):

Hierarchies (1):

Translations:

+Molap Dimension Clustered Customers

Attributes (3):

Hierarchies (0):

Translations:

+Molap Dimension Subcategory Basket Analysis