I have a BI Cube with say two keyfigure 0Amount and 0Qty. I have a keyfigure dimension in BPC Cube. While loding data through tranformation file to BPC i want keyfigure field to be updated dynamically as AMT for 0Amount and QTY for 0Qty.
e.g
record in BI :
document no 0amount 0qty
doc1 100 50
In BPC it should create two entries
document keyfigure signeddata
doc1 AMT 100
doc1 QTY 50
I need to upload it through single run of tranformation file.