Skip to Content
0
Former Member
May 30, 2007 at 02:13 PM

Master Data Mapping

11 Views

Hello Experts,

I am in the process of designing an infocube and i was a little confused about the 2 char hierarchy and wanted to clear my confusion on it.

In the flat file, we can have data either at account level or account group level. So i was thinking of having 2 characteristics - account and account group in the infocube.

But how about the master data mapping between account and account group? where would that be taken care of ?

Ex: Flat File

Year, Curr, CoCd, A/C, CC, Period, Amount

2006, USD, 1000, 38001001, 456700, 1, 100

2006, USD, 1000, 38001002, 456700, 1, 100

2006, USD, 1000, 0380, 45600, 1, 200 -


> ( A/C Group 0380 - consolidated entry)

All answers would be duly rewarded with points.

Thanks,

Nandita