I am in the process of loading an InfoCube from the data in a flat file. However, the problem is that the flat file has both master data and transaction data where as the InfoCube (Fact Table) would be having DIM Ids and Key Figures ( Transaction Data)
To make things simpler, this is how my transaction data is
Legal Entity, Cost Center, Account, Amount
1000, 108000,235600, 250
Which is a mix of Master Data ( LE, CC, A/C) and Transactional Data ( 250) - I was not provided any other table to load master data seperately ...
So what do u think i need to do ?
All answers/ideas will be duly rewarded.