Multiple Key figures loading into BPC

[Former Member]

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.

[former_member186338]

Strange idea to use multiple not related tags for the question!

What is your system? MS or NW??

[Former Member]

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.

[former_member186338]

Sorry, but first you have to delete BPC NW as a secondary tag! Absolutely easy!

[Former Member]

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.

[former_member186338]

First: correct tag! I will stop answering befor the tag will be corrected!

[Former Member]

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.

[former_member186338]

Still not clear:

You have number of accounts in text file with QUANTITY:

PL010 - sales

PL310 - purchace

What do you want to have in QTY account??? What is the logic???? A bit meaningless...

[former_member186338]

Please correct tags in your question!!!

[former_member186338]

Please provide a sample of text file with all columns!

Not clear the relation betwwen account and quantity.