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

Please Help Data Model Design


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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 11, 2011 at 03:16 AM


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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 11, 2011 at 03:34 AM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      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.



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.