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