Skip to Content
avatar image
Former Member

Multiple Key figures loading into BPC

Hi Everyone,

I was trying to load the transaction data from a Flat file to BPC. The CSV has two Key figure columns 'Balance' and Quantity. In BPC i want to send Balance as Signed Data and Quantity as Quantity member in Account Dimension.

Can any one help me how to achieve this.

Best Regards,

Gowtham.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 04, 2017 at 09:37 AM

    Hi Vadim,

    Thanks for the reply , this is the Data file screenshot.

    In the above screenshot Balance Key figure data will go to Signed Data and Quantity Data will got one of the Account Dimension Member(Qty).

    note:Qty is one of the stat member in Account Dimension.

    Best Regards,

    Gowtham.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2017 at 10:00 AM

    Hi Vadim,

    This is my Input File:

    In the above screenshot Balance Key figure data will go to Signed Data and Quantity Data will got one of the Account Dimension Member(Units).

    note:Units is one of the stat member in Account Dimension.

    This is the output am looking

    Gowtham.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2017 at 11:03 AM

    Which tag i have to select? I was trying to change the Primary tag from MS BPC to NW BPC but NW-BPC is not available as Primary tag.

    Sorry for the inconvenience caused.

    Gowtham.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2017 at 09:22 AM

    Please provide a sample of text file with all columns!

    Not clear the relation betwwen account and quantity.

    Add comment
    10|10000 characters needed characters exceeded