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

Master data !!

Hello experts!!

In my understanding i think that master data is the one which changes slowly and has attributes.NOw tell me one thing what if it doesnt have any attributes??THen its not master data?

For eg: my columns are employee id (which has attribute employee name) and then employee designation and employee name. so when i making infoobject for employee name in the Master data tab Should i uncheck Master Data option and just check With text option??and if yes then why?I am sure that in case of Employee id Master data check box shld be checked as well as with text box also..as it has attributes.

SO,can anyone please tell me where to uncheck that WITH MASTER DATA option check box and where no to..

Thanks.Buzz

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2005 at 01:54 PM

    The option marks indicate that a table will be created. The 'with master data' option means that a table will be created to hold the data that is coming in during extraction (etc.). Even if it is only an ID and no attributes such a table can be handy. The SID codes are determined based on the masterdata table.

    In some cases you could decide that you need a characteristic but you do not want to save it in the database. Perhaps because you just need it to transfer data from extract structure to infosource. In such a case you would not need a master data table.

    I can't remember that I ever deselected the 'with master data' option.

    Message was edited by: T. Jans-Beken

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2005 at 02:08 PM

    Hallo

    In BW masterdata is meant as Attribute - Text and Hoerarchy. in BW the IO is the Central Element and it is used to mapp data.

    According to your example, then you can create the Employe with Text (to map description) and attribute (to map employe designation). of course first you need to map employe desingation and you need to build another IO which could only attribute if you want to use this information only as display information.

    I hope this can help you

    Mike

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2005 at 02:16 PM

    HI,

    Master Data is not only attributes, it consist of Attributes, Texts and Hierarchies.

    Attributes are the details behind the characterstics. So if you have any characterstic(which is a attribute of some other characterstic) for which you want to define some attributes, you can select it as Master data, else you can only define Text data. Its your choice and as per requirement.

    Hope it helps you.

    Regards,

    Kamaljeet Singh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2005 at 08:12 AM

    Hi,

    Actually, master data mean attributes.

    COnsider the following combinations of texts and master data.

    <b>1. No master data, no texts</b>.

    Only key field (which is defined as IO's type and length) of the IO is present. This IO is used in transfer or communication structures, and in ODS and cubes just for holding a code. You cannot load into such an IO any master data or texts.

    Example: Employee ID = '123456'.

    <b>2. No master data, there are texts</b>.

    If you have texts for an IO, then you can show these texts in queries along with key field of the IO.

    Example: Employee ID = '123456',

    Short Text = 'Buzzme'.

    <b>3. There are master data, there are texts</b>.

    You can show these display attributes in queries along with key field of the IO.

    But, if you make an attribute as navigational (or include this attribute separatly into dataprovider as a char), you'll be able to drilldown a query on this attribute.

    Example: Employee ID = '123456',

    Short Text = 'Buzzme',

    Department = '345'.

    <b>4. There are master data, no texts</b>.

    You don't need texts, just a link betwee two IOs.

    Example: Company Code = '123456',

    Currency = '840'.

    Best regards,

    Eugene

    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.