Please Help Data Model Design

[Former Member]

Hello,

I have to design a data model with following points from clients.

The flow is from Datasource to DSO to Infosource in between and then to cube.

No changes to be done until DSO.

Now i have a master data object called 0employee which is having its attributes 0orgunit and 0person.

0Person is time dependent master object which is having its attribute called 0gender.

Now i have to use 0employee, 0orgunit and 0gender only in cube for reporting.

So my clients says to use 0employee in infosource level and in cube transfer rule type use read master from 0employee into object 0orgunit. My doubt is is this possible when i use 0employee in infosource as well as in cube to read master data?

Also 0employee should compulsary be matched to source object from DSO? Am i right?

Now my question is how to read 0gender from 0person? 0person should not be use in my flow. What i am thinking is use second infosource include 0person object and read master data for 0person from 0employee of first infosource into second infosource and then finally in cube transfer rule type i read master data for 0gender from 0person. Is this possible?

Also my client says 0PERSON is a time depended and you've to put the due date. For Data from actual year it would be current day, and for the "historical" ones use field_x an auxillary field in the InfoSource might help there. What this means how to do this?

My client says rather then doing above steps define 0orgunit and 0gender as navigational attribute in cube. But how is this possible? Does it mean just check box in cube navi attribute drill down? And i might find Navi attributes for 0orgunit and 0person to check but where will i find 0gender as it is attribute of 0person?

My final requirement is to have 0employee, 0orgunit and 0gender in cube for reporting.

Please help.

Syed Zabi

[former_member199691]

Hi,

You have 0employee coming from your data source and

0employee ->has attributes-> 0orgunit and 0person

0person ->has attribute> 0gender (which is time dependent)

In your flow you should not have any rule till DSO level. From Data Source to DSO, keep 1:1 mapping for all the fields.

Now from DSO to Infosoure, write the rule to read 0person from 0employee master data. From Infosource to Cube, you should again have 1:1 mapping.

Now in your cube, you should mark 0orgunit and 0gender as navigation attributes. Now you can use 0employee, 0orgunit and 0gender for reporting. As 0gender is time dependent attribute of 0person, so you need to define Key Date at query level for which you can define a fix date or may use a customer exit variable so that 0gender is displayed in the report as per the time dependency.

Another option for you is to use 0gender in Infosource and Cube, for this you will have to read 0employee master data and 0person master data to get 0gender. While writing the logic for 0gender from DSO to Infosource, you will have to use a date coming in the flow to read 0gender from 0person. If you go with this option, you will not need to use Key Date at query level as you already have 0gender in the cube as per the time dependency.

Regards,

Gaurav

[Former Member]

Hi,

This is response for gaurav. Anyone who reads please help me on this thread.

0employee and 0person are no where used in datasource until DSO.

I will have to use these two fields from infosource level.

And 0person is time dependent not 0gender.

Please help me. Clients want me to do this way only and find solution.

Regards

Syed

[mr_v]

Hi,

Have you ever installed data flow for cube 0PA_C01 from business content?

I would suggest u to install data flow for 0PA_C01. This will cleat your doubts.

U should have only PERNR in datasouce. And 0EMPLOYEE in infosource. thats it. U should get many things like orgunit, ohrpostion, operson and so on.

U can use as many as infosources to read master data.

I assume u have dataflow Datasiurce -> Infosource -> DSO -> Infocube

Let me know if u have any further questions that does not solve after installing 0PA_C01 data flow ?.