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 |