Skip to Content
0
Former Member
Jun 03, 2010 at 12:04 PM

Conversion File - Append letters to the external data

10 Views

Hi gurus,

I want to load transaction data from a cube, but my master data is different from the transaction data.

In master data - in account dimension , I have following element aaa100000, aaa100001, aaa100002 .... ... ..

But in transaction data - for account dimension, I have following 100000, 100001, 100002 .. . ...

So in each of the internal data (master data of dimension) there are additional word "aaa" attached.

How can I load data and remove the additional field in master data of BPC dimension.

Thanks in advance

Sanjay