| name | value |
|---|---|
| name | Adventure Works |
| description | |
| id | Adventure Works |
| estimated rows | 0 |
| language | 1033 |
| collation | Latin1_General_CI_AS |
| default measure | [Reseller Sales Amount] |
| data source view | AdventureWorksDW |
| created | 8/26/2006 10:06:13 PM |
| last schema update | 8/26/2006 10:06:13 PM |
| last processed | 8/26/2006 10:06:31 PM |
| loaded | True |
| state | Processed |
| cube dimension | database dimension | id |
|---|---|---|
| Adventure Works Customer | Customer | Customer |
| Adventure Works Date | Date | Order Date Key - Dim Time |
| Adventure Works Delivery Date | Date | Delivery Date Key - Dim Time |
| Adventure Works Internet Sales Order Details | Internet Sales Order Details | Internet Sales Order Details |
| Adventure Works Product | Product | Product |
| Adventure Works Reseller | Reseller | Reseller |
| Adventure Works Reseller Geography | Geography | Geography |
| Adventure Works Reseller Sales Order Details | Reseller Sales Order Details | Reseller Sales Order Details |
| Adventure Works Sales Reason | Sales Reason | Sales Reason |
| Adventure Works Ship Date | Date | Ship Date Key - Dim Time |
| Adventure Works Source Currency | Currency | Currency |
| name | description | id | type | state | processing mode | storage mode | estimated rows |
|---|---|---|---|---|---|---|---|
| Adventure Works.Sales Reasons | Sales Reasons | Processed | LazyAggregations | Molap | |||
| Adventure Works.Internet Sales | Internet Sales | Sales | Processed | LazyAggregations | Molap | ||
| Adventure Works.Reseller Sales | Reseller Sales | Sales | Processed | LazyAggregations | Molap | ||
| Adventure Works.Customers | Customers | Processed | LazyAggregations | Molap | |||
| Adventure Works.Currency Rates | Currency Rates | ExchangeRate | Processed | LazyAggregations | Molap |
| name | id | role | read | write |
|---|---|---|---|---|
| Adventure Works.CubePermission | CubePermission | Processors | Allowed | |
| Adventure Works.CubePermission 1 | CubePermission 1 | Writers | Allowed | Allowed |
| Adventure Works.CubePermission 2 | CubePermission 2 | Readers | Allowed |
| name | value |
|---|---|
| silence interval | -PT1S |
| latency | -PT1S |
| silence override interval | -PT1S |
| force rebuild interval | -PT1S |
| aggregation storage | |
| online mode | |
| source type | ProactiveCachingInheritedBinding |
| source notification technique |
| name | object type | level |
|---|---|---|
| AmoAdventureWorks | Database | 1 |
| AdventureWorksDW | DataSourceView | 1 |
| Currency | Dimension | 1 |
| Customer | Dimension | 1 |
| Date | Dimension | 1 |
| Geography | Dimension | 1 |
| Internet Sales Order Details | Dimension | 1 |
| Product | Dimension | 1 |
| Reseller | Dimension | 1 |
| Reseller Sales Order Details | Dimension | 1 |
| Sales Reason | Dimension | 1 |
| name | object type | level |
|---|---|---|
| Adventure Works Customer | CubeDimension | 1 |
| Adventure Works Date | CubeDimension | 1 |
| Adventure Works Delivery Date | CubeDimension | 1 |
| Adventure Works Internet Sales Order Details | CubeDimension | 1 |
| Adventure Works Product | CubeDimension | 1 |
| Adventure Works Reseller | CubeDimension | 1 |
| Adventure Works Reseller Geography | CubeDimension | 1 |
| Adventure Works Reseller Sales Order Details | CubeDimension | 1 |
| Adventure Works Sales Reason | CubeDimension | 1 |
| Adventure Works Ship Date | CubeDimension | 1 |
| Adventure Works Source Currency | CubeDimension | 1 |
| Adventure Works CubePermission | CubePermission | 1 |
| Adventure Works CubePermission 1 | CubePermission | 1 |
| Adventure Works CubePermission 2 | CubePermission | 1 |
| Adventure Works Currency Rates | MeasureGroup | 1 |
| Fact Currency Rate | Partition | 2 |
| Adventure Works Customers | MeasureGroup | 1 |
| Customers_914 | Partition | 2 |
| Customers_549 | Partition | 2 |
| Customers_184 | Partition | 2 |
| Adventure Works Sales Reasons | MeasureGroup | 1 |
| Fact_Internet_Sales_Reason | Partition | 2 |