SAP BPC TRANFORMATION FILE ISSUE

[Former Member]

Hi,

I am new to data loading in BPC. I am stuck in a situation where I am trying to validate my transformation file and i am getting this error

"Validation with data file failed"

The following dimension are being used as part of flat file and transformation file

Account

Entity

Category

Time

RPTCurrency

Product

In Mapping section in transformation file i have mapped objects header wise for

Account=Account

Entity=Entity

Category=Category

Time=Time

RPTCurrency=RPTCurrency

Product=Product

Please help...to fix the error

[former_member186338]

If you want to solve the issue:

1. Provide few lines of import file in notepad

2. Provide latest transformation file.

3. Check that dimension members in import file exist in the system

[Former Member]

Hi Vadim,

I am not getting the option to send you file in notepad.But i can share the screenshot for transformation file and flat file which i am uploading and also the error which i am getting.

[former_member186338]

Your first screenshot is unreadable!

For data file - please make a notepad screenshot! What you present is not a notepad!

[Former Member]

[Former Member]

[former_member186338]

Sorry, do you know the application Notepad? In any Windows system you have it!

What is the idea to make screenshots in Word??? You first screenshot is unreadable, I already told you about it - no response...

And at the end why do you use Member ID's with space inside for Product dimension:

Product A

...

Absolutely bad idea!

[Former Member]

Hi Tridip,

I recommend you to please read some standard documentation before doing it. There are so many standard documents, tutorials as well as videos available on scn and google. Why cant you refer them. Try first by yourself......and then post.

Click on Yes to see the rejected records......and try to analyse why it is rejected....whats wrong with the ID's.

Regards,

JP

[Former Member]

Hi Tridip,

Actual screenshots of transformation file and data file would have been better! What are you loading transaction or master data? Data file should be .csv format.

Looks like you are loading transaction in which Signedata  mapping is missing!

Insert this line...

SIGNEDDATA=AMOUNT(column header of data)

Hope this helps....

Regards,

JP

[Former Member]

P.S from the screenshot of transformation file....it is clear you are missing the mapping of Signeddata and other 2 dimension of the cube...RB_Product and Scope!. Either add those in your file, or pass a constant value of dimension using *NEWCOL function....

[Former Member]

[Former Member]

Hi JP,

I have got your point,I have not added RB_prdocut and scope in my file.If i dont want to add those in file ,how to write the mapping for those in transformation file.And if i want to add those in my flat file,do i need to add in particular column according to sequence or can put any where..Please help with the steps..

Thanks a lot

[Former Member]

Did you fail to read my reply above till the end???

P.S from the screenshot of transformation file....it is clear you are missing the mapping of Signeddata and other 2 dimension of the cube...RB_Product and Scope!. Either add those in your file, or pass a constant value of dimension using *NEWCOL function....

Where is the mapping for RB_PRODUCT and SCope???? you  need to map all the dimensions when loading the data! And please follow only one convention to map the fields either headers or *COL....don't mix them!

Regards,

JP

[Former Member]

ok got ur point...i will make changes accordingly..

Thanks JP

[Former Member]

Please read the help for transformation file...Data Transformations - SAP BusinessObjects Planning and Consolidation - SAP Library

You can add them anywhere in the file....sequence is not important in file....but mapppping them correctly in transformation is important with correct headers or column no! If you do not wish to add them in file then default them with any one member of both the dimension! e.g RB_PRODUCT=*NEWCOL(RB_PRODUCT1)

SCOPE=*NEWCOL(SCOPE1)

I have given any names to the members....you add your member name their.

Regards,

JP

[Former Member]

Hi JP,

Thanks for sharing the details however the transformation file is still giving different error.I am attaching the transformation file with flat file.

[Former Member]

Is the master data maintained in system in respective dimensions?? Where is the RB_Product and Scope columns in the flat file? I am unable to see those......remove signedata line and then try.

Regards,

JP

[former_member225135]

Hi,

See if you have followed the steps as mentioned in the below link:

http://jaybpc.blogspot.in/2014/02/loading-transaction-data-from-flat-file.html

The screenshot of your flat file will be helpful.

Regards,

Rahul

[Former Member]