validity of my architecture with master data

[former_member215107]

Hi Everybody,

I want to load specific indicators for an airline company

like:

• Number_Of_Flights

• Number_Of_Employees

• Number_Of_Complaints

Each of these data depend on Time and a specific Characteristic.

We are:

Number_Of_Flights which depends of COUNTRY characteristic

Number_Of_Employees which depends of COST_CENTER characteristic

Number_Of_Complaints which depends of SEGMENTATION characteristic.

I would like to create a characteristic GENERIC which contents in

master data the following characteristics:

- COUNTRY

- COST_CENTER

- SEGMENTATION

So, i will obtain in my infocube the following structure:

Number_Of_Flights | GENERIC | TIME_MONTH --> KFigure

Number_Of_Employees | GENERIC | TIME_MONTH --> KFigure

Number_Of_Complaints | GENERIC | TIME_MONTH --> KFigure

Then, for the characteristic Number_Of_*, i would like

to add Characteristic "DEPEND_ON" which contains the string:

"COUNTRY" --> it means that depend on COUNTRY characteristic

"COST_CENTER" --> it means that depend on COST_CENTER characteristic

"SEGMENTATION" --> it means that depend on SEGMENTATION characteristic

After you, my logic is correct ?

Thanks for your help,

Rodolphe.

[former_member215107 · Accepted solution]

I begin to understand your response ...

But How can i create a SKF ?

If i want to introduce another key figure "Fuel Litres" the next month,

can i add the criterion ZFUELCONSUMED in standard SKF Type without Problem ?

And last Question, SKF can be used wihth Integrated Planning ?

Thanks

Rodolphe.

[Former Member · Accepted solution]

SKF - yes you can create your own! It's just another infoobject - have a look at skf and skftype in the 0CO application area

Yes to the new objects you just add a new master data entry into it

[former_member215107]

Hi Simon,

thanks for your response.

I try to understand but what is "Statistical Key Figure" ?

Thanks

[Former Member]

A statistical key figure is a SAP term and process

It is used in R3 to hold data like - no of employees, no of trips, machine hours etc (ie exactly the type of things you are after)

It allows you to have one key figure - and use the infoobject statstical key figure as a partitioning characteristic - rather than have three seprate key figures

The use of this is that key figures are in effect columns - and what happens if you want to say introduce another key figure - like Fuel Litres consumed?

[Former Member]

I understand .. but first question:

How are you expecting the data to be displayed?

Do you want everything in one report?

If so how are you going to disaggregate the No of Flights into the cost centre and segmentation?

ie your "Generic" infoobject

For a BW perspective there is no need for the generic object

If what you say is correct then you just have one object called Segmentation which has a compound of country and cost centre

(ie the key to the object now becomes country, cost centre, segment)

I would then create another infoobject - maybe the standard SKF Type (Statistical Key Figure) which will hold three master data entries:

ZNOFLIGHT

ZNOEMP

ZCOMPLAINTS

Then in your infocube you put in:

SEGMENT (which will inherit the two infoobjects of Country and cost centre)

SKFTYPE

with a key figure of SKF