Master data !!

[Former Member]

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

[Former Member]

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

[Private_Member_9643]

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

[Former Member]

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

[Former Member]

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