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

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

84 Views

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.