cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Key figures loading into BPC

0 Kudos

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
Active Contributor
0 Kudos

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

What is your system? MS or NW??


Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

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
Active Contributor
0 Kudos

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

0 Kudos

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
Active Contributor
0 Kudos

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

0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Please correct tags in your question!!!

former_member186338
Active Contributor
0 Kudos

Please provide a sample of text file with all columns!

Not clear the relation betwwen account and quantity.