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