Skip to Content
Sep 07, 2018 at 06:11 PM

How to upload two keyfigures from BI Cube to BPC through single transformation file?


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.


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.