Adventure Works Semantic Model Reference
This documentation is for Kyvos 2026.6.x. To view documentation for other Kyvos versions, click here. |
|---|
All examples in this guide use the Adventure Works sample semantic model. This section provides the complete structural reference needed to understand the queries.
Dimensions and Hierarchies
Date Dimension
[Date]
└── [Date].[Calendar] -- Hierarchy
├── [Date].[Calendar].[Calendar Year] -- Level 0 (All)
├── [Date].[Calendar].[Calendar Semester] -- Level 1
├── [Date].[Calendar].[Calendar Quarter] -- Level 2
├── [Date].[Calendar].[Month] -- Level 3
└── [Date].[Calendar].[Date] -- Level 4 (leaf)
[Date].[Fiscal] -- Alternate fiscal hierarchy
├── [Date].[Fiscal].[Fiscal Year]
├── [Date].[Fiscal].[Fiscal Semester]
├── [Date].[Fiscal].[Fiscal Quarter]
└── [Date].[Fiscal].[Month]
Sample Members: [Date].[Calendar].[Calendar Year].[2012]
[Date].[Calendar].[Calendar Quarter].[Q1 CY 2012]
[Date].[Calendar].[Month].[January 2012]
Product Dimension
[Product]
└── [Product].[Product Categories] -- Hierarchy
├── Level 0: [Product].[Product Categories].[All Products]
├── Level 1: [Product].[Product Categories].[Category]
├── Level 2: [Product].[Product Categories].[Subcategory]
└── Level 3: [Product].[Product Categories].[Product] (leaf)
└── [Product].[Product] --- -- Flat hierarchy
└── [Product].[Product].[Product]
Sample Members:
[Product].[Product Categories].[Category].[Bikes] [Product].[Product Categories].[Category].[Clothing] [Product].[Product Categories].[Category].[Accessories] [Product].[Product Categories].[Category].[Components] [Product].[Product Categories].[Subcategory].[Mountain Bikes] [Product].[Product Categories].[Subcategory].[Road Bikes]Customer Dimension
[Customer]
└── [Customer].[Customer Geography] -- Hierarchy
├── Level 0: [Customer].[Customer Geography].[All Customers]
├── Level 1: [Customer].[Customer Geography].[Country]
├── Level 2: [Customer].[Customer Geography].[State-Province]
├── Level 3: [Customer].[Customer Geography].[City]
└── Level 4: [Customer].[Customer Geography].[Customer] (leaf)
Sample Members:
[Customer].[Customer Geography].[Country].[United States] [Customer].[Customer Geography].[Country].[Australia] [Customer].[Customer Geography].[State-Province].[California]Geography Dimension
[Geography]
└── [Geography].[Geography]
├── [Geography].[Geography].[Country]
├── [Geography].[Geography].[State-Province]
└── [Geography].[Geography].[City]Sales Territory Dimension
[Sales Territory]
└── [Sales Territory].[Sales Territory]
├── [Sales Territory].[Sales Territory].[Sales Territory Group]
├── [Sales Territory].[Sales Territory].[Sales Territory Country]
└── [Sales Territory].[Sales Territory].[Sales Territory Region]Employee Dimension
[Employee]
└── [Employee].[Department]
├── [Employee].[Department].[Department]
└── [Employee].[Department].[Employee]Measures
Measure | Description | Typical Range |
[Measures].[Internet Sales Amount] | Online channel revenue | Primary sales measure |
[Measures].[Internet Order Quantity] | Units ordered online | Integer count |
[Measures].[Internet Unit Price] | Per-unit price for internet sales | Currency |
[Measures].[Reseller Sales Amount] | Channel partner revenue | Large values |
[Measures].[Total Product Cost] | Cost of goods | Used for margin calc |
[Measures].[Sales Amount] | Combined sales (all channels) | Aggregate |
[Measures].[Order Count] | Number of orders | Integer count |
[Measures].[Cash Flow] | Net cash flow | Can be negative |
[Measures].[Gross Profit] | Sales minus cost | Derived |