Skip to Content
author's profile photo Former Member
Former Member

Balanced Scorecard and its corresponding BW Data Model?

Hi...

I am doing a Strategy Management scenario in SAP SEM and have developed measures.Next, when creating the BW data model i am facing problem in identifying the key figures that i should be using in the cube.I am providing the list of measures, please tell me the base key figures that i should include in the cube. Will be of great help.

Measures:

Economic Profit, Capital Charge Method

Net Operating Profit after Tax

Earnings Before Interest and Tax

Earnings Before Interest, Taxes, Depreciation & Amortization

Shareholder Value Added

Return on Equity

Return on Assets

Internal Rate of Return

Present Value of Investment Projects

Annual Net Income (Balance Sheet)

Asset Turns

Present Value of Investment Projects

Net Sales

Sales Growth

No. of Projects Targeted for Sales Growth

Net Sales from New Customers

Net Sales from New Products

Sales Growth from New Products

Sales Share of New Products

Sales Share of New Customers

Share of Customers' Total Expenditure

Degree of Overlap Own Prod. List / Competition

Share of the Addressed Customer Segments

Share of Customers' Total Expenditure

Sales Growth from New Products

Sales Share of New Customers

Number of Newly Developed Applications

Share of R&D Expense for Applied Research

Share of R&D Expense for Basic Research

Number of Development Teams with Customer Involvement

Share of Customers with Partnership

Number of Development Teams with Customer Involvement

Average Length of Service

Training Investment Per FTE

Training Staffing Factor

Annual Investment in Technologies

Average Length of Service

Employer-Initiated Turnover Rate

Employee-Initiated Turnover Rate

% Employees with Remuneration Related to Goal Achievement

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 02, 2006 at 04:36 AM

    Samik,

    The measure you have given can be classified as

    Finance

    Economic Profit, Capital Charge Method

    Net Operating Profit after Tax

    Earnings Before Interest and Tax

    Earnings Before Interest, Taxes, Depreciation & Amortization

    Shareholder Value Added

    Return on Equity

    Return on Assets

    Internal Rate of Return

    Present Value of Investment Projects

    Annual Net Income (Balance Sheet)

    Asset Turns

    Present Value of Investment Projects

    Net Sales

    Sales Growth

    Customer service

    No. of Projects Targeted for Sales Growth

    Net Sales from New Customers

    Net Sales from New Products

    Sales Growth from New Products

    Sales Share of New Products

    Sales Share of New Customers

    Share of Customers' Total Expenditure

    Degree of Overlap Own Prod. List / Competition

    Share of the Addressed Customer Segments

    Share of Customers' Total Expenditure

    Sales Growth from New Products

    Sales Share of New Customers

    Business Process

    Number of Newly Developed Applications

    Share of R&D Expense for Applied Research

    Share of R&D Expense for Basic Research

    Number of Development Teams with Customer Involvement

    Share of Customers with Partnership

    Number of Development Teams with Customer Involvement

    Internal learning

    Average Length of Service

    Training Investment Per FTE

    Training Staffing Factor

    Annual Investment in Technologies

    Average Length of Service

    Employer-Initiated Turnover Rate

    Employee-Initiated Turnover Rate

    % Employees with Remuneration Related to Goal Achievement

    accordingly look for the base key figures for the same. I would not put a finger to many , but essentially for finance look at FI data - especially GL postings , cost center postings , AR/AP etc

    for Customer Service - CRM data would help , Sales Data - SD - invoices , orders etc

    Internal - HR

    business processes - depends on the system

    Also the key figures for the same depends on the business rather than a generic business model that would fit all. First you will have to study the business process and understand the business rules and operating conditions before proceeding.

    Arun

    Assign points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2007 at 11:26 AM

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.