I have a 2 dimensions (Account and costcenter) in my Finance application. Now the data from the finance application should be transferred to another application (sales application), but there my account dimension has to be a concetinate of the members of the original account and costcenter dimension.
Example FINANCE APP : ACCOUNT1.MEMBER=600000 COSTCENTER.MEMBER=100 should be transferred to SALES APP on ACCOUNT2.MEMBER=600000_100.
I can not work with a property because for each account there can be 50 costcenters.
Has somebody an idea how to resolve this problem ?
Thx in advance