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.