| CATALOG_NAME | SCHEMA_NAME | CUBE_NAME | MEASURE_NAME | MEASURE_UNIQUE_NAME | MEASURE_CAPTION | MEASURE_GUID | MEASURE_AGGREGATOR | DATA_TYPE | NUMERIC_PRECISION | NUMERIC_SCALE | MEASURE_UNITS | DESCRIPTION | EXPRESSION | MEASURE_IS_VISIBLE | LEVELS_LIST | MEASURE_NAME_SQL_COLUMN_NAME | MEASURE_UNQUALIFIED_CAPTION | MEASUREGROUP_NAME | MEASURE_DISPLAY_FOLDER | DEFAULT_FORMAT_STRING |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adventure Works DW | null | Adventure Works | Internet Sales Amount | [Measures].[Internet Sales Amount] | Internet Sales Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Sales Amount | Internet Sales Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Order Quantity | [Measures].[Internet Order Quantity] | Internet Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Internet Order Quantity | Internet Order Quantity | Internet Sales | null | #,# | |
| Adventure Works DW | null | Adventure Works | Internet Extended Amount | [Measures].[Internet Extended Amount] | Internet Extended Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Extended Amount | Internet Extended Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Tax Amount | [Measures].[Internet Tax Amount] | Internet Tax Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Tax Amount | Internet Tax Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Freight Cost | [Measures].[Internet Freight Cost] | Internet Freight Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Freight Cost | Internet Freight Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Total Product Cost | [Measures].[Internet Total Product Cost] | Internet Total Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Total Product Cost | Internet Total Product Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Standard Product Cost | [Measures].[Internet Standard Product Cost] | Internet Standard Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Standard Product Cost | Internet Standard Product Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Order Count | [Measures].[Internet Order Count] | Internet Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Internet Order Count | Internet Order Count | Internet Orders | null | #,# | |
| Adventure Works DW | null | Adventure Works | Customer Count | [Measures].[Customer Count] | Customer Count | null | 8 | 3 | 10 | -1 | null | null | true | null | Customer Count | Customer Count | Internet Customers | null | #,# | |
| Adventure Works DW | null | Adventure Works | Reseller Sales Amount | [Measures].[Reseller Sales Amount] | Reseller Sales Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Sales Amount | Reseller Sales Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Order Quantity | [Measures].[Reseller Order Quantity] | Reseller Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Reseller Order Quantity | Reseller Order Quantity | Reseller Sales | null | #,# | |
| Adventure Works DW | null | Adventure Works | Reseller Extended Amount | [Measures].[Reseller Extended Amount] | Reseller Extended Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Extended Amount | Reseller Extended Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Tax Amount | [Measures].[Reseller Tax Amount] | Reseller Tax Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Tax Amount | Reseller Tax Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Freight Cost | [Measures].[Reseller Freight Cost] | Reseller Freight Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Freight Cost | Reseller Freight Cost | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Discount Amount | [Measures].[Discount Amount] | Discount Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Discount Amount | Discount Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Total Product Cost | [Measures].[Reseller Total Product Cost] | Reseller Total Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Total Product Cost | Reseller Total Product Cost | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Standard Product Cost | [Measures].[Reseller Standard Product Cost] | Reseller Standard Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Standard Product Cost | Reseller Standard Product Cost | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Order Count | [Measures].[Reseller Order Count] | Reseller Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Reseller Order Count | Reseller Order Count | Reseller Orders | null | #,# | |
| Adventure Works DW | null | Adventure Works | Order Quantity | [Measures].[Order Quantity] | Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Order Quantity | Order Quantity | Sales Summary | null | #,# | |
| Adventure Works DW | null | Adventure Works | Extended Amount | [Measures].[Extended Amount] | Extended Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Extended Amount | Extended Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Standard Product Cost | [Measures].[Standard Product Cost] | Standard Product Cost | null | 1 | 5 | 16 | -1 | null | null | true | null | Standard Product Cost | Standard Product Cost | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Total Product Cost | [Measures].[Total Product Cost] | Total Product Cost | null | 1 | 5 | 16 | -1 | null | null | true | null | Total Product Cost | Total Product Cost | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Sales Amount | [Measures].[Sales Amount] | Sales Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Sales Amount | Sales Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Tax Amount | [Measures].[Tax Amount] | Tax Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Tax Amount | Tax Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Freight Cost | [Measures].[Freight Cost] | Freight Cost | null | 1 | 5 | 16 | -1 | null | null | true | null | Freight Cost | Freight Cost | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Order Count | [Measures].[Order Count] | Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Order Count | Order Count | Sales Orders | null | #,# | |
| Adventure Works DW | null | Adventure Works | Sales Amount Quota | [Measures].[Sales Amount Quota] | Sales Amount Quota | null | 1 | 6 | 19 | 4 | null | null | true | null | Sales Amount Quota | Sales Amount Quota | Sales Targets | null | Currency | |
| Adventure Works DW | null | Adventure Works | Amount | [Measures].[Amount] | Amount | null | 15 | 5 | 16 | -1 | null | null | true | null | Amount | Amount | Financial Reporting | null | Currency | |
| Adventure Works DW | null | Adventure Works | Average Rate | [Measures].[Average Rate] | Average Rate | null | 10 | 5 | 16 | -1 | null | null | true | null | Average Rate | Average Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Adventure Works | End of Day Rate | [Measures].[End of Day Rate] | End of Day Rate | null | 14 | 5 | 16 | -1 | null | null | true | null | End of Day Rate | End of Day Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Adventure Works | Internet Gross Profit | [Measures].[Internet Gross Profit] | Internet Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] | true | null | Internet Gross Profit | Internet Gross Profit | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Gross Profit Margin | [Measures].[Internet Gross Profit Margin] | Internet Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] ) / [Measures].[Internet Sales Amount] | true | null | Internet Gross Profit Margin | Internet Gross Profit Margin | Internet Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Internet Average Unit Price | [Measures].[Internet Average Unit Price] | Internet Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Unit Price] / [Measures].[Internet Transaction Count] | true | null | Internet Average Unit Price | Internet Average Unit Price | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Average Sales Amount | [Measures].[Internet Average Sales Amount] | Internet Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] / [Measures].[Internet Order Count] | true | null | Internet Average Sales Amount | Internet Average Sales Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Internet Ratio to All Products | [Measures].[Internet Ratio to All Products] | Internet Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] / ( Root( [Product] ), [Measures].[Internet Sales Amount] ) | true | null | Internet Ratio to All Products | Internet Ratio to All Products | Internet Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Internet Ratio to Parent Product | [Measures].[Internet Ratio to Parent Product] | Internet Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Internet Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Internet Sales Amount] ) End | true | null | Internet Ratio to Parent Product | Internet Ratio to Parent Product | Internet Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Growth in Customer Base | [Measures].[Growth in Customer Base] | Growth in Customer Base | null | 127 | 12 | 65535 | -1 | null | Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then "NA" When IsEmpty ( ( [Date].[Fiscal].CurrentMember.PrevMember, [Measures].[Customer Count] ) ) Then Null Else ( ( [Date].[Fiscal].CurrentMember, [Measures].[Customer Count] ) - ( [Date].[Fiscal].PrevMember, [Measures].[Customer Count] ) ) / ( [Date].[Fiscal].PrevMember,[Measures].[Customer Count] ) End | true | null | Growth in Customer Base | Growth in Customer Base | Internet Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Reseller Gross Profit | [Measures].[Reseller Gross Profit] | Reseller Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Sales Amount] - [Measures].[Reseller Total Product Cost] | true | null | Reseller Gross Profit | Reseller Gross Profit | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Gross Profit Margin | [Measures].[Reseller Gross Profit Margin] | Reseller Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Reseller Sales Amount] - [Measures].[Reseller Total Product Cost] ) / [Measures].[Reseller Sales Amount] | true | null | Reseller Gross Profit Margin | Reseller Gross Profit Margin | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Reseller Average Unit Price | [Measures].[Reseller Average Unit Price] | Reseller Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Unit Price] / [Measures].[Reseller Transaction Count] | true | null | Reseller Average Unit Price | Reseller Average Unit Price | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Average Sales Amount | [Measures].[Reseller Average Sales Amount] | Reseller Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Sales Amount] / [Measures].[Reseller Order Count] | true | null | Reseller Average Sales Amount | Reseller Average Sales Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Adventure Works | Reseller Ratio to All Products | [Measures].[Reseller Ratio to All Products] | Reseller Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Sales Amount] / ( Root( [Product] ), [Measures].[Reseller Sales Amount] ) | true | null | Reseller Ratio to All Products | Reseller Ratio to All Products | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Reseller Ratio to Parent Product | [Measures].[Reseller Ratio to Parent Product] | Reseller Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Reseller Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Reseller Sales Amount] ) End | true | null | Reseller Ratio to Parent Product | Reseller Ratio to Parent Product | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Discount Percentage | [Measures].[Discount Percentage] | Discount Percentage | null | 127 | 12 | 65535 | -1 | null | [Measures].[Discount Amount] / [Measures].[Reseller Sales Amount] | true | null | Discount Percentage | Discount Percentage | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Adventure Works | Average Unit Price | [Measures].[Average Unit Price] | Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Unit Price] / [Measures].[Transaction Count] | true | null | Average Unit Price | Average Unit Price | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Average Sales Amount | [Measures].[Average Sales Amount] | Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Sales Amount] / [Measures].[Order Count] | true | null | Average Sales Amount | Average Sales Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Gross Profit | [Measures].[Gross Profit] | Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Sales Amount] - [Measures].[Total Product Cost] | true | null | Gross Profit | Gross Profit | Sales Summary | null | Currency | |
| Adventure Works DW | null | Adventure Works | Gross Profit Margin | [Measures].[Gross Profit Margin] | Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Sales Amount] - [Measures].[Total Product Cost] ) / [Measures].[Sales Amount] | true | null | Gross Profit Margin | Gross Profit Margin | Sales Summary | null | Percent | |
| Adventure Works DW | null | Adventure Works | Expense to Revenue Ratio | [Measures].[Expense to Revenue Ratio] | Expense to Revenue Ratio | null | 127 | 12 | 65535 | -1 | null | IIf ( IsEmpty ( [Measures].[Sales Amount] ), Null, ( [Measures].[Amount], [Account].[Accounts].[Account Level 03].&[58] ) / [Measures].[Sales Amount] ) | true | null | Expense to Revenue Ratio | Expense to Revenue Ratio | Sales Summary | null | Percent | |
| Adventure Works DW | null | Adventure Works | Ratio to All Products | [Measures].[Ratio to All Products] | Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Sales Amount] / ( Root( [Product] ), [Measures].[Sales Amount] ) | true | null | Ratio to All Products | Ratio to All Products | Sales Summary | null | Percent | |
| Adventure Works DW | null | Adventure Works | Ratio to Parent Product | [Measures].[Ratio to Parent Product] | Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Sales Amount] ) End | true | null | Ratio to Parent Product | Ratio to Parent Product | Sales Summary | null | Percent | |
| Adventure Works DW | null | Channel Sales | Reseller Sales Amount | [Measures].[Reseller Sales Amount] | Reseller Sales Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Sales Amount | Reseller Sales Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Order Quantity | [Measures].[Reseller Order Quantity] | Reseller Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Reseller Order Quantity | Reseller Order Quantity | Reseller Sales | null | #,# | |
| Adventure Works DW | null | Channel Sales | Reseller Extended Amount | [Measures].[Reseller Extended Amount] | Reseller Extended Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Extended Amount | Reseller Extended Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Tax Amount | [Measures].[Reseller Tax Amount] | Reseller Tax Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Tax Amount | Reseller Tax Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Freight Cost | [Measures].[Reseller Freight Cost] | Reseller Freight Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Freight Cost | Reseller Freight Cost | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Discount Amount | [Measures].[Discount Amount] | Discount Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Discount Amount | Discount Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Total Product Cost | [Measures].[Reseller Total Product Cost] | Reseller Total Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Total Product Cost | Reseller Total Product Cost | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Standard Product Cost | [Measures].[Reseller Standard Product Cost] | Reseller Standard Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Standard Product Cost | Reseller Standard Product Cost | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Order Count | [Measures].[Reseller Order Count] | Reseller Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Reseller Order Count | Reseller Order Count | Reseller Orders | null | #,# | |
| Adventure Works DW | null | Channel Sales | Average Rate | [Measures].[Average Rate] | Average Rate | null | 10 | 5 | 16 | -1 | null | null | true | null | Average Rate | Average Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Channel Sales | End of Day Rate | [Measures].[End of Day Rate] | End of Day Rate | null | 14 | 5 | 16 | -1 | null | null | true | null | End of Day Rate | End of Day Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Channel Sales | Discount Percentage | [Measures].[Discount Percentage] | Discount Percentage | null | 127 | 12 | 65535 | -1 | null | [Measures].[Discount Amount] / [Measures].[Reseller Sales Amount] | true | null | Discount Percentage | Discount Percentage | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Channel Sales | Reseller Ratio to Parent Product | [Measures].[Reseller Ratio to Parent Product] | Reseller Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Reseller Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Reseller Sales Amount] ) End | true | null | Reseller Ratio to Parent Product | Reseller Ratio to Parent Product | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Channel Sales | Reseller Ratio to All Products | [Measures].[Reseller Ratio to All Products] | Reseller Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Sales Amount] / ( Root( [Product] ), [Measures].[Reseller Sales Amount] ) | true | null | Reseller Ratio to All Products | Reseller Ratio to All Products | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Channel Sales | Reseller Average Sales Amount | [Measures].[Reseller Average Sales Amount] | Reseller Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Sales Amount] / [Measures].[Reseller Order Count] | true | null | Reseller Average Sales Amount | Reseller Average Sales Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Average Unit Price | [Measures].[Reseller Average Unit Price] | Reseller Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Unit Price] / [Measures].[Reseller Transaction Count] | true | null | Reseller Average Unit Price | Reseller Average Unit Price | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Channel Sales | Reseller Gross Profit Margin | [Measures].[Reseller Gross Profit Margin] | Reseller Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Reseller Sales Amount] - [Measures].[Reseller Total Product Cost] ) / [Measures].[Reseller Sales Amount] | true | null | Reseller Gross Profit Margin | Reseller Gross Profit Margin | Reseller Sales | null | Percent | |
| Adventure Works DW | null | Channel Sales | Reseller Gross Profit | [Measures].[Reseller Gross Profit] | Reseller Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Reseller Sales Amount] - [Measures].[Reseller Total Product Cost] | true | null | Reseller Gross Profit | Reseller Gross Profit | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Sales Amount | [Measures].[Internet Sales Amount] | Internet Sales Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Sales Amount | Internet Sales Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Order Quantity | [Measures].[Internet Order Quantity] | Internet Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Internet Order Quantity | Internet Order Quantity | Internet Sales | null | #,# | |
| Adventure Works DW | null | Direct Sales | Internet Extended Amount | [Measures].[Internet Extended Amount] | Internet Extended Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Extended Amount | Internet Extended Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Tax Amount | [Measures].[Internet Tax Amount] | Internet Tax Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Tax Amount | Internet Tax Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Freight Cost | [Measures].[Internet Freight Cost] | Internet Freight Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Freight Cost | Internet Freight Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Total Product Cost | [Measures].[Internet Total Product Cost] | Internet Total Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Total Product Cost | Internet Total Product Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Standard Product Cost | [Measures].[Internet Standard Product Cost] | Internet Standard Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Standard Product Cost | Internet Standard Product Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Order Count | [Measures].[Internet Order Count] | Internet Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Internet Order Count | Internet Order Count | Internet Orders | null | #,# | |
| Adventure Works DW | null | Direct Sales | Customer Count | [Measures].[Customer Count] | Customer Count | null | 8 | 3 | 10 | -1 | null | null | true | null | Customer Count | Customer Count | Internet Customers | null | #,# | |
| Adventure Works DW | null | Direct Sales | Average Rate | [Measures].[Average Rate] | Average Rate | null | 10 | 5 | 16 | -1 | null | null | true | null | Average Rate | Average Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Direct Sales | End of Day Rate | [Measures].[End of Day Rate] | End of Day Rate | null | 14 | 5 | 16 | -1 | null | null | true | null | End of Day Rate | End of Day Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Direct Sales | Growth in Customer Base | [Measures].[Growth in Customer Base] | Growth in Customer Base | null | 127 | 12 | 65535 | -1 | null | Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then "NA" When IsEmpty ( ( [Date].[Fiscal].CurrentMember.PrevMember, [Measures].[Customer Count] ) ) Then Null Else ( ( [Date].[Fiscal].CurrentMember, [Measures].[Customer Count] ) - ( [Date].[Fiscal].PrevMember, [Measures].[Customer Count] ) ) / ( [Date].[Fiscal].PrevMember,[Measures].[Customer Count] ) End | true | null | Growth in Customer Base | Growth in Customer Base | Internet Sales | null | Percent | |
| Adventure Works DW | null | Direct Sales | Internet Ratio to Parent Product | [Measures].[Internet Ratio to Parent Product] | Internet Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Internet Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Internet Sales Amount] ) End | true | null | Internet Ratio to Parent Product | Internet Ratio to Parent Product | Internet Sales | null | Percent | |
| Adventure Works DW | null | Direct Sales | Internet Ratio to All Products | [Measures].[Internet Ratio to All Products] | Internet Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] / ( Root( [Product] ), [Measures].[Internet Sales Amount] ) | true | null | Internet Ratio to All Products | Internet Ratio to All Products | Internet Sales | null | Percent | |
| Adventure Works DW | null | Direct Sales | Internet Average Sales Amount | [Measures].[Internet Average Sales Amount] | Internet Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] / [Measures].[Internet Order Count] | true | null | Internet Average Sales Amount | Internet Average Sales Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Average Unit Price | [Measures].[Internet Average Unit Price] | Internet Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Unit Price] / [Measures].[Internet Transaction Count] | true | null | Internet Average Unit Price | Internet Average Unit Price | Internet Sales | null | Currency | |
| Adventure Works DW | null | Direct Sales | Internet Gross Profit Margin | [Measures].[Internet Gross Profit Margin] | Internet Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] ) / [Measures].[Internet Sales Amount] | true | null | Internet Gross Profit Margin | Internet Gross Profit Margin | Internet Sales | null | Percent | |
| Adventure Works DW | null | Direct Sales | Internet Gross Profit | [Measures].[Internet Gross Profit] | Internet Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] | true | null | Internet Gross Profit | Internet Gross Profit | Internet Sales | null | Currency | |
| Adventure Works DW | null | Finance | Amount | [Measures].[Amount] | Amount | null | 15 | 5 | 16 | -1 | null | null | true | null | Amount | Amount | Financial Reporting | null | Currency | |
| Adventure Works DW | null | Finance | Average Rate | [Measures].[Average Rate] | Average Rate | null | 10 | 5 | 16 | -1 | null | null | true | null | Average Rate | Average Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Finance | End of Day Rate | [Measures].[End of Day Rate] | End of Day Rate | null | 14 | 5 | 16 | -1 | null | null | true | null | End of Day Rate | End of Day Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Mined Customers | Internet Sales Amount | [Measures].[Internet Sales Amount] | Internet Sales Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Sales Amount | Internet Sales Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Order Quantity | [Measures].[Internet Order Quantity] | Internet Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Internet Order Quantity | Internet Order Quantity | Internet Sales | null | #,# | |
| Adventure Works DW | null | Mined Customers | Internet Extended Amount | [Measures].[Internet Extended Amount] | Internet Extended Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Extended Amount | Internet Extended Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Tax Amount | [Measures].[Internet Tax Amount] | Internet Tax Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Tax Amount | Internet Tax Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Freight Cost | [Measures].[Internet Freight Cost] | Internet Freight Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Freight Cost | Internet Freight Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Total Product Cost | [Measures].[Internet Total Product Cost] | Internet Total Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Total Product Cost | Internet Total Product Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Standard Product Cost | [Measures].[Internet Standard Product Cost] | Internet Standard Product Cost | null | 1 | 6 | 19 | 4 | null | null | true | null | Internet Standard Product Cost | Internet Standard Product Cost | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Order Count | [Measures].[Internet Order Count] | Internet Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Internet Order Count | Internet Order Count | Internet Orders | null | #,# | |
| Adventure Works DW | null | Mined Customers | Customer Count | [Measures].[Customer Count] | Customer Count | null | 8 | 3 | 10 | -1 | null | null | true | null | Customer Count | Customer Count | Internet Customers | null | #,# | |
| Adventure Works DW | null | Mined Customers | Average Rate | [Measures].[Average Rate] | Average Rate | null | 10 | 5 | 16 | -1 | null | null | true | null | Average Rate | Average Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Mined Customers | End of Day Rate | [Measures].[End of Day Rate] | End of Day Rate | null | 14 | 5 | 16 | -1 | null | null | true | null | End of Day Rate | End of Day Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Mined Customers | Internet Gross Profit | [Measures].[Internet Gross Profit] | Internet Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] | true | null | Internet Gross Profit | Internet Gross Profit | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Gross Profit Margin | [Measures].[Internet Gross Profit Margin] | Internet Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] ) / [Measures].[Internet Sales Amount] | true | null | Internet Gross Profit Margin | Internet Gross Profit Margin | Internet Sales | null | Percent | |
| Adventure Works DW | null | Mined Customers | Internet Average Unit Price | [Measures].[Internet Average Unit Price] | Internet Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Unit Price] / [Measures].[Internet Transaction Count] | true | null | Internet Average Unit Price | Internet Average Unit Price | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Average Sales Amount | [Measures].[Internet Average Sales Amount] | Internet Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] / [Measures].[Internet Order Count] | true | null | Internet Average Sales Amount | Internet Average Sales Amount | Internet Sales | null | Currency | |
| Adventure Works DW | null | Mined Customers | Internet Ratio to All Products | [Measures].[Internet Ratio to All Products] | Internet Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Internet Sales Amount] / ( Root( [Product] ), [Measures].[Internet Sales Amount] ) | true | null | Internet Ratio to All Products | Internet Ratio to All Products | Internet Sales | null | Percent | |
| Adventure Works DW | null | Mined Customers | Internet Ratio to Parent Product | [Measures].[Internet Ratio to Parent Product] | Internet Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Internet Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Internet Sales Amount] ) End | true | null | Internet Ratio to Parent Product | Internet Ratio to Parent Product | Internet Sales | null | Percent | |
| Adventure Works DW | null | Mined Customers | Growth in Customer Base | [Measures].[Growth in Customer Base] | Growth in Customer Base | null | 127 | 12 | 65535 | -1 | null | Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then "NA" When IsEmpty ( ( [Date].[Fiscal].PrevMember, [Measures].[Customer Count] ) ) Then Null Else ( [Measures].[Customer Count] - ( [Date].[Fiscal].PrevMember, [Measures].[Customer Count] ) ) / ( [Date].[Fiscal].PrevMember,[Measures].[Customer Count] ) End | true | null | Growth in Customer Base | Growth in Customer Base | Internet Sales | null | Percent | |
| Adventure Works DW | null | Sales Summary | Order Quantity | [Measures].[Order Quantity] | Order Quantity | null | 1 | 3 | 10 | -1 | null | null | true | null | Order Quantity | Order Quantity | Sales Summary | null | #,# | |
| Adventure Works DW | null | Sales Summary | Extended Amount | [Measures].[Extended Amount] | Extended Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Extended Amount | Extended Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Standard Product Cost | [Measures].[Standard Product Cost] | Standard Product Cost | null | 1 | 5 | 16 | -1 | null | null | true | null | Standard Product Cost | Standard Product Cost | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Total Product Cost | [Measures].[Total Product Cost] | Total Product Cost | null | 1 | 5 | 16 | -1 | null | null | true | null | Total Product Cost | Total Product Cost | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Sales Amount | [Measures].[Sales Amount] | Sales Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Sales Amount | Sales Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Tax Amount | [Measures].[Tax Amount] | Tax Amount | null | 1 | 5 | 16 | -1 | null | null | true | null | Tax Amount | Tax Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Freight Cost | [Measures].[Freight Cost] | Freight Cost | null | 1 | 5 | 16 | -1 | null | null | true | null | Freight Cost | Freight Cost | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Order Count | [Measures].[Order Count] | Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Order Count | Order Count | Sales Orders | null | #,# | |
| Adventure Works DW | null | Sales Summary | Average Rate | [Measures].[Average Rate] | Average Rate | null | 10 | 5 | 16 | -1 | null | null | true | null | Average Rate | Average Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Sales Summary | End of Day Rate | [Measures].[End of Day Rate] | End of Day Rate | null | 14 | 5 | 16 | -1 | null | null | true | null | End of Day Rate | End of Day Rate | Exchange Rates | null | #,#.00 | |
| Adventure Works DW | null | Sales Summary | Ratio to Parent Product | [Measures].[Ratio to Parent Product] | Ratio to Parent Product | null | 127 | 12 | 65535 | -1 | null | Case When [Product].[Product Model Categories].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount] / ( [Product].[Product Model Categories].CurrentMember.Parent, [Measures].[Sales Amount] ) End | true | null | Ratio to Parent Product | Ratio to Parent Product | Sales Summary | null | Percent | |
| Adventure Works DW | null | Sales Summary | Ratio to All Products | [Measures].[Ratio to All Products] | Ratio to All Products | null | 127 | 12 | 65535 | -1 | null | [Measures].[Sales Amount] / ( Root( [Product] ), [Measures].[Sales Amount] ) | true | null | Ratio to All Products | Ratio to All Products | Sales Summary | null | Percent | |
| Adventure Works DW | null | Sales Summary | Expense to Revenue Ratio | [Measures].[Expense to Revenue Ratio] | Expense to Revenue Ratio | null | 127 | 12 | 65535 | -1 | null | IIf ( IsEmpty ( [Measures].[Sales Amount] ), Null, ( [Measures].[Amount], [Account].[Accounts].[Account Level 03].&[58] ) / [Measures].[Sales Amount] ) | true | null | Expense to Revenue Ratio | Expense to Revenue Ratio | Sales Summary | null | Percent | |
| Adventure Works DW | null | Sales Summary | Gross Profit Margin | [Measures].[Gross Profit Margin] | Gross Profit Margin | null | 127 | 12 | 65535 | -1 | null | ( [Measures].[Sales Amount] - [Measures].[Total Product Cost] ) / [Measures].[Sales Amount] | true | null | Gross Profit Margin | Gross Profit Margin | Sales Summary | null | Percent | |
| Adventure Works DW | null | Sales Summary | Gross Profit | [Measures].[Gross Profit] | Gross Profit | null | 127 | 12 | 65535 | -1 | null | [Measures].[Sales Amount] - [Measures].[Total Product Cost] | true | null | Gross Profit | Gross Profit | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Average Sales Amount | [Measures].[Average Sales Amount] | Average Sales Amount | null | 127 | 12 | 65535 | -1 | null | [Measures].[Sales Amount] / [Measures].[Order Count] | true | null | Average Sales Amount | Average Sales Amount | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Summary | Average Unit Price | [Measures].[Average Unit Price] | Average Unit Price | null | 127 | 12 | 65535 | -1 | null | [Measures].[Unit Price] / [Measures].[Transaction Count] | true | null | Average Unit Price | Average Unit Price | Sales Summary | null | Currency | |
| Adventure Works DW | null | Sales Targets | Reseller Sales Amount | [Measures].[Reseller Sales Amount] | Reseller Sales Amount | null | 1 | 6 | 19 | 4 | null | null | true | null | Reseller Sales Amount | Reseller Sales Amount | Reseller Sales | null | Currency | |
| Adventure Works DW | null | Sales Targets | Reseller Order Count | [Measures].[Reseller Order Count] | Reseller Order Count | null | 8 | 3 | 65535 | -1 | null | null | true | null | Reseller Order Count | Reseller Order Count | Reseller Orders | null | #,# | |
| Adventure Works DW | null | Sales Targets | Sales Amount Quota | [Measures].[Sales Amount Quota] | Sales Amount Quota | null | 1 | 6 | 19 | 4 | null | null | true | null | Sales Amount Quota | Sales Amount Quota | Sales Targets | null | Currency |