| 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 |