7/30/2019 Scribd 1key Figure

1/11

7/30/2019 Scribd 1key Figure

2/11

By the end of this session you could brag

something aboutWhat is a Key Figure in SAP BW ?

What is STAR schema in Data warehouse ?

What is a FACT ?What is a Dimension ?

How is Fact and Dimension related ?

What is Extended STAR or Snowflake schema ?

What is an Index ?

How to define Dimension/Fact ?

7/30/2019 Scribd 1key Figure

3/11

Why Datawarehouse?Why data warehouse is needed when you have all the

information available in your application system or ECC(in SAP)?

Lets walk through an example so that it could make

some sense !!!!

7/30/2019 Scribd 1key Figure

4/11

Initial Requirement Children gets enrolled into different program based on

their eligibility.

Eligibility means family income, social status andphysical and mental health status of the individual..

Requirement is to create enrollment eligibility reportthat provides intelligence to the stakeholders at

different levels of the organization

SoundsSimple!!

7/30/2019 Scribd 1key Figure

5/11

Stake Holders

User S1 - Chief for the Dept.

User D1 - Director of the Office

User SA1 - Statistical Analyst

7/30/2019 Scribd 1key Figure

6/11

After final requirement sessionFinalized report formats

7/30/2019 Scribd 1key Figure

7/11

Generate a report which graphically representsnumber of Recipients by Program for any given month

Also the report should have the capability to slice anddice the data by Calendar months, Federal FiscalCalendar, State Fiscal Calendar at yearly, quarterly andmonthly levels

Show the results by Gender, Race, Ethnicity, County Should display the individual level information of all

the participants

7/30/2019 Scribd 1key Figure

8/11

InfoObjects !!!

Unit

Time

Technical

InfoObjects

Characteristics

Key Figures

Calculated

Restricted

\kfi-gyr \

InfoObjects are the smallest information units in BW and they structure the information needed

to create data targets.

7/30/2019 Scribd 1key Figure

9/11

A Key Figure is a quantifiable value that is normally (cumulative)and answers the question how much? or how many?

What is Key Figure?

Definition from help.sap.com Values or quantities.

Or in our simple terms.

Example : Closing Stock Price, Inventory Levels, Sales revenue, Fixed costs, Sales

quantity, Number of employees

In general Datawarehousing term, an equivalent term for KeyFigure is MEASURE.

7/30/2019 Scribd 1key Figure

10/11

Key Figures

Calculated

Restricted

Key Figure

Persistent Key Figure Dynamic Key Figure

CumulativeKey Figure

Non-CumulativeKey Figure

What is ?--Persistent / Dynamic Key Figure ?-- Cumulative / Non Cumulative Key Figure ?

Key Figures at times be referred to as

Calculated Key Figures can further be grouped as..

7/30/2019 Scribd 1key Figure

11/11

Persistent / Dynamic Key Figures