Skip to Content
0

Multiple Key figures loading into BPC

Nov 04, 2017 at 09:11 AM

112

avatar image
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.

10 |10000 characters needed characters left characters exceeded

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

What is your system? MS or NW??


0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

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

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.


trans-001.png (9.8 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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...

0

Please correct tags in your question!!!

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

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.


trans-001.png (9.8 kB)
result-001.png (10.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

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

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Vadim Kalinin Nov 04, 2017 at 09:22 AM
0

Please provide a sample of text file with all columns!

Not clear the relation betwwen account and quantity.

Share
10 |10000 characters needed characters left characters exceeded