Master Data Logic!

[Former Member]

Hi

Can anyone tell me what is Master Data Concept??

Tell me in clear Idea.

1. What is Direct & Flexible update??

2. How the Master Data object in ODS or Cube is loaded??

3.When we delete master data object which is used in Data Targets, why some data is not deleted?

Thanks

BI Learner

[raghu_ram · Accepted solution]

hii,

InfoSource Types

There are basically two types of InfoSources.

InfoSources with flexible updating

InfoSources with direct updating

In both cases uploaded data is transformed by the transfer rules, which have been created for the current combination of InfoSource and source system and for each InfoObject of the communication structure. A data target can be defined by several InfoSources which in turn can be defined by several source systems.

An InfoSource for hierarchies can only be defined by one source system.

For characteristics, attributes or texts, a combination of flexible and direct updating is only possible for different source systems.

InfoSources with Flexible Updating

For an InfoSource with flexible updating, the data from the communications structure is loaded into the data targets (InfoCubes, ODS objects, master data) using update rules. Several data targets can be defined by one InfoSource. The InfoSource can contain transaction data as well as master data.

This function is not implemented for hierarchies.

Before Release 3.0A only transaction data could be updated flexibly and it was only possible to update master data directly. Master data InfoSources were therefore distinguished from transaction data InfoSources. This is no longer the case as of Release BW 3.0A, since both transaction data and master data can be updated flexibly. You therefore cannot immediately see if it the InfoSource handles transaction data or master data with flexible updating. You should therefore specify which is the case when you define an InfoSource.

You have the following update options:

The data from InfoSources with master data or transaction data can be stored directly in ODS objects.

You can then update from ODS objects into further ODS objects, InfoCubes or master data tables using update rules.

It is also possible to update in InfoCubes or master data tables without having to switch between ODS objects.

InfoSources with Direct Updating

Master data (characteristics with attributes, texts or hierarchies) of an InfoObject can be updated directly (without update rules, only using transfer rules) to the master data table with an InfoSource with direct updating. To do this you must assign it application components. The characteristic is subsequently displayed in the InfoSource tree in the Administrator Workbench. You are able to assign DataSources and source systems to the characteristic from here. You are also able to load master data, texts, and hierarchies for the characteristic.

In the following cases you are not able to use an InfoObject as an InfoSource with direct updating:

The characteristic that you want to modify is characteristic 0SOURSYSTEM (source system ID).

The characteristic has neither master data, texts nor hierarchies. It is therefore impossible to load data for the characteristic.

The characteristic that you want to modify turns out to be a unit or a key figure.

To generate an export DataSource for a characteristic, the characteristic must also be an InfoSource with direct updating.

check the foll links

http://help.sap.com/saphelp_nw04/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

hope it helps,

regards,

raghu.

[Former Member]

Helpful answers

[yogesh8984]

Hi,

Here are the answers in brief...

1. Direct Update has no update rule and you can not load the data in the object from multiple data sources. Whereas in flexible update you have multiple data sources feeding it via multiple update rules.

2. If you use the master object in ODS/Cube, then at the time of loading transaction data the data gets updated in those masters.

3. When you try to delete the master data, the data which is updated in that master due to transaction loading don't get deleted. For that you have to delete the data from transaction (Cube/ODS) first. Then only the complete data from master can be deleted.

Hope this info helps you.

Regards,

Yogesh

[Former Member]

Hi Raghu & yogesh

Thanks a lot for your explanation

BI Learner