cancel
Showing results for 
Search instead for 
Did you mean: 

Master data

Former Member
0 Kudos
341

Hello,

I have a master data with date_from and date_to fields for slow changing dimension purpose. When I load data BW will create 2 records, why? lets say I load the data on 04/18/2005. BW creates two records

To_date From _date

-


-


04/17/2005 01/01/1000

12/31/9999 04/18/2005

Why 2 records? and why is some of the attributes for the 1st record are null?

This master table is used in an ODS also when reporting on the ODS, BW pulls in the 1st record with the NULL attributes why?

Is this a bug? Please help me how to go about fixing this.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi David,

This is the way the time dependant master data is recorded in the system. Eg if Material belongs to group A from 04/01/2004 to 06/30/2004, then this will be recorded as:

Material ___ 01/01/1000 to 03/31/2004

Material A 04/01/2004 to 06/30/2004

Material ___ 07/01/2004 to 12/31/9999

The system has to show a status from 01/01/1000 to 12/31/9999.

When executing the report, BW will pull up the data as per the date specified in your report. So may be you ran the report for 08/01/2004 (as per above example) and it have you zero.

Hope this helps...

Former Member
0 Kudos

Thanks Bhanu,

But these dates are not avilable for report(do not know why) also how come some attributes are null for the first record?

former_member188975
Active Contributor
0 Kudos

David,

Is the master data activated? What time char are you using in the report? Have you tried to run the report without specifying any time?

The attributes would be null for the first record, because from the system start date (01/01/1000) till the from date (-1) of the record, the attribute has no value. Like since you loaded on 04/18/2005, we have the value from this date onwards (till another load brings in a change), but from the system start date to 04/17/2005, there was no value for this attribute...

Former Member
0 Kudos

Thanks Bhanu, but yes it is activated no there are no date and time in the master data for reporting.To_date and from_date are just in the communication structure only.

Also not all attributes are null for the 1st record only some of them are nulls.

former_member188975
Active Contributor
0 Kudos

Hi David,

Only those attributes of your InfoObject that are time dependant could be null in the first record. To verify this, take a look at your InfoObject in RSD1 and note the time dependant attrs. Then you can take a look at the M, P and Q tables for your InfoObject.

What is the composition of your ODS?

Former Member
0 Kudos

Thanks

Answers (0)