uploading transaction file via flat file

[Former Member]

Hi All,

In the transformation file, we maintain the mapping as follow:

Entity_Dimension = *COL(1)

KF_Dimension = *COL(2)

and in the text file, we maintain as follow:

Entity_Dimension	KF_Dimension	Amount
AAA	Quantity	2
AAA	Total	100000

What should I put in Mapping section in the transformation file if I want to maintain the text file as below (if it's possible):

Entity_Dimension	KF_Dimension quantity member	KF_Dimension Total Member
AAA	2	100000

Thanks in advance.

[Former Member · Accepted solution]

Try this:

Importing and Exporting Data Having Multiple Key Figures - SAP BusinessObjects Planning and Consolid...

Andy

[former_member186338]

Please read help about *MVAL

Vadim