CATALOG_NAME |
SCHEMA_NAME |
CUBE_NAME |
MEASUREGROUP_NAME |
KPI_NAME |
KPI_CAPTION |
KPI_DESCRIPTION |
KPI_DISPLAY_FOLDER |
KPI_VALUE |
KPI_GOAL |
KPI_STATUS |
KPI_TREND |
KPI_STATUS_GRAPHIC |
KPI_TREND_GRAPHIC |
KPI_WEIGHT |
KPI_CURRENT_TIME_MEMBER |
KPI_PARENT_KPI_NAME |
ANNOTATIONS |
Adventure Works DW |
null |
Adventure Works |
Internet Sales |
Growth in Customer Base |
Growth in Customer Base |
The ratio between the customer count in the current period to that of the previous period. |
Customer Perspective\Expand Customer Base |
[Measures].[Growth in Customer Base] |
[Measures].[Growth in Customer Base Goal] |
[Measures].[Growth in Customer Base Status] |
[Measures].[Growth in Customer Base Trend] |
Road Signs |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Financial Reporting |
Net Income |
Net Income |
Total earnings less operating expenses, taxes, interest, depreciation and other expenses. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Net Income Value] |
[Measures].[Net Income Goal] |
[Measures].[Net Income Status] |
[Measures].[Net Income Trend] |
Road Signs |
Status Arrow - Ascending |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Financial Reporting |
Operating Profit |
Operating Profit |
The difference between revenue and total operating expenses. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Operating Profit Value] |
[Measures].[Operating Profit Goal] |
[Measures].[Operating Profit Status] |
[Measures].[Operating Profit Trend] |
Traffic Light |
Status Arrow - Ascending |
|
null |
Net Income |
|
Adventure Works DW |
null |
Adventure Works |
Financial Reporting |
Operating Expenses |
Operating Expenses |
Business expenses not directly associated with the manufacture of a product or provision of a service. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Operating Expenses Value] |
[Measures].[Operating Expenses Goal] |
[Measures].[Operating Expenses Status] |
[Measures].[Operating Expenses Trend] |
Traffic Light |
Status Arrow - Descending |
|
null |
Operating Profit |
|
Adventure Works DW |
null |
Adventure Works |
Financial Reporting |
Financial Gross Margin |
Financial Gross Margin |
The percentage of every dollar earned that can be used to pay general and administrative expenses. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Financial Gross Margin Value] |
[Measures].[Financial Gross Margin Goal] |
[Measures].[Financial Gross Margin Status] |
[Measures].[Financial Gross Margin Trend] |
Traffic Light |
Status Arrow - Ascending |
|
null |
Operating Profit |
|
Adventure Works DW |
null |
Adventure Works |
Financial Reporting |
Return on Assets |
Return on Assets |
Net income divided by assets. This is an indicator of the profitability and efficiency of a business, and its ability to leverage its assets to generate income. |
Financial Perspective\Grow Revenue |
[Measures].[Return on Assets Value] |
[Measures].[Return on Assets Goal] |
[Measures].[Return on Assets Status] |
[Measures].[Return on Assets Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Sales Summary |
Product Gross Profit Margin |
Product Gross Profit Margin |
Total profit earned as a percentage of sales. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Gross Profit Margin] |
[Measures].[Product Gross Profit Margin Goal] |
[Measures].[Product Gross Profit Margin Status] |
[Measures].[Product Gross Profit Margin Trend] |
Cylinder |
Status Arrow - Ascending |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Financial Reporting |
Financial Variance |
Financial Variance |
The difference between actual and budgeted values for a given account. |
Financial Perspective\Grow Revenue |
[Measures].[Financial Variance Value] |
[Measures].[Financial Variance Goal] |
[Measures].[Financial Variance Status] |
[Measures].[Financial Variance Trend] |
Variance Arrow |
Status Arrow - Descending |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Sales Summary |
Expense to Revenue Ratio |
Expense to Revenue Ratio |
The ratio of operating expenses to gross sales. |
Internal Perspective\Increase Operational Efficiency |
[Measures].[Expense to Revenue Ratio] |
[Measures].[Expense to Revenue Ratio Goal] |
[Measures].[Expense to Revenue Ratio Status] |
[Measures].[Expense to Revenue Ratio Trend] |
Gauge - Descending |
Status Arrow - Descending |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Sales Summary |
Revenue |
Revenue |
Total revenue from operations. |
Financial Perspective\Grow Revenue |
[Measures].[Sales Amount] |
[Measures].[Revenue Goal] |
[Measures].[Revenue Status] |
[Measures].[Revenue Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Reseller Sales |
Channel Revenue |
Channel Revenue |
Revenue realized through the reseller sales channel. |
Financial Perspective\Grow Revenue |
[Measures].[Reseller Sales Amount] |
[Measures].[Sales Amount Quota] |
[Measures].[Channel Revenue Status] |
[Measures].[Channel Revenue Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Adventure Works |
Internet Sales |
Internet Revenue |
Internet Revenue |
Revenue realized through direct sales via the internet. |
Financial Perspective\Grow Revenue |
[Measures].[Internet Sales Amount] |
[Measures].[Internet Revenue Goal] |
[Measures].[Internet Revenue Status] |
[Measures].[Internet Revenue Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Channel Sales |
Reseller Sales |
Channel Revenue |
Channel Revenue |
Revenue realized through the reseller sales channel. |
Financial Perspective\Grow Revenue |
[Measures].[Reseller Sales Amount] |
[Measures].[Sales Amount Quota] |
[Measures].[Channel Revenue Status] |
[Measures].[Channel Revenue Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Direct Sales |
Internet Sales |
Growth in Customer Base |
Growth in Customer Base |
The ratio between the customer count in the current period to that of the previous period. |
Customer Perspective\Expand Customer Base |
[Measures].[Growth in Customer Base] |
[Measures].[Growth in Customer Base Goal] |
[Measures].[Growth in Customer Base Status] |
[Measures].[Growth in Customer Base Trend] |
Road Signs |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Direct Sales |
Internet Sales |
Internet Revenue |
Internet Revenue |
Revenue realized through direct sales via the internet. |
Financial Perspective\Grow Revenue |
[Measures].[Internet Sales Amount] |
[Measures].[Internet Revenue Goal] |
[Measures].[Internet Revenue Status] |
[Measures].[Internet Revenue Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Finance |
Financial Reporting |
Net Income |
Net Income |
Total earnings less operating expenses, taxes, interest, depreciation and other expenses. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Net Income Value] |
[Measures].[Net Income Goal] |
[Measures].[Net Income Status] |
[Measures].[Net Income Trend] |
Road Signs |
Status Arrow - Ascending |
|
null |
|
|
Adventure Works DW |
null |
Finance |
Financial Reporting |
Operating Profit |
Operating Profit |
The difference between revenue and total operating expenses. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Operating Profit Value] |
[Measures].[Operating Profit Goal] |
[Measures].[Operating Profit Status] |
[Measures].[Operating Profit Trend] |
Traffic Light |
Status Arrow - Ascending |
|
null |
Net Income |
|
Adventure Works DW |
null |
Finance |
Financial Reporting |
Operating Expenses |
Operating Expenses |
Business expenses not directly associated with the manufacture of a product or provision of a service. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Operating Expenses Value] |
[Measures].[Operating Expenses Goal] |
[Measures].[Operating Expenses Status] |
[Measures].[Operating Expenses Trend] |
Traffic Light |
Status Arrow - Descending |
|
null |
Operating Profit |
|
Adventure Works DW |
null |
Finance |
Financial Reporting |
Financial Gross Margin |
Financial Gross Margin |
The percentage of every dollar earned that can be used to pay general and administrative expenses. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Financial Gross Margin Value] |
[Measures].[Financial Gross Margin Goal] |
[Measures].[Financial Gross Margin Status] |
[Measures].[Financial Gross Margin Trend] |
Traffic Light |
Status Arrow - Ascending |
|
null |
Operating Profit |
|
Adventure Works DW |
null |
Finance |
Financial Reporting |
Return on Assets |
Return on Assets |
Net income divided by assets. This is an indicator of the profitability and efficiency of a business, and its ability to leverage its assets to generate income. |
Financial Perspective\Grow Revenue |
[Measures].[Return on Assets Value] |
[Measures].[Return on Assets Goal] |
[Measures].[Return on Assets Status] |
[Measures].[Return on Assets Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|
Adventure Works DW |
null |
Finance |
Financial Reporting |
Financial Variance |
Financial Variance |
The difference between actual and budgeted values for a given account. |
Financial Perspective\Grow Revenue |
[Measures].[Financial Variance Value] |
[Measures].[Financial Variance Goal] |
[Measures].[Financial Variance Status] |
[Measures].[Financial Variance Trend] |
Variance Arrow |
Status Arrow - Descending |
|
null |
|
|
Adventure Works DW |
null |
Sales Summary |
Sales Summary |
Product Gross Profit Margin |
Product Gross Profit Margin |
Total profit earned as a percentage of sales. |
Financial Perspective\Maintain Overall Margins |
[Measures].[Gross Profit Margin] |
[Measures].[Product Gross Profit Margin Goal] |
[Measures].[Product Gross Profit Margin Status] |
[Measures].[Product Gross Profit Margin Trend] |
Cylinder |
Status Arrow - Ascending |
|
null |
|
|
Adventure Works DW |
null |
Sales Summary |
Sales Summary |
Expense to Revenue Ratio |
Expense to Revenue Ratio |
The ratio of operating expenses to gross sales. |
Internal Perspective\Increase Operational Efficiency |
[Measures].[Expense to Revenue Ratio] |
[Measures].[Expense to Revenue Ratio Goal] |
[Measures].[Expense to Revenue Ratio Status] |
[Measures].[Expense to Revenue Ratio Trend] |
Gauge - Descending |
Status Arrow - Descending |
|
null |
|
|
Adventure Works DW |
null |
Sales Summary |
Sales Summary |
Revenue |
Revenue |
Total revenue from operations. |
Financial Perspective\Grow Revenue |
[Measures].[Sales Amount] |
[Measures].[Revenue Goal] |
[Measures].[Revenue Status] |
[Measures].[Revenue Trend] |
Cylinder |
Standard Arrow |
|
null |
|
|