on 07-10-2014 8:50 AM
Hi everyone,
I have run into a problem when I try to upload data using transformation and conversion file. New accounts were added and mapped to BPC accounts in one of my conversion files, However when I ran data validation on the conversion file I get the following two errors only for the new accounts added (the rest of the records are accepted):
1. Dimension: FLOW member: CYA_YTD_151150_COS is invalid or is a calculated member
2. Dimension: ACCOUNT member: CYA_YTD_151550_COS is invalid or is a calculated member
It is only for the new accounts I mapped and I am 100% sure the BPC accounts I have mapped to are not calculated members. I am also 100% sure the accounts from the flat data file (e.g. CYA_YTD_151150_COS) are 100% the same. Anyone familiar with this issue?
Thanks!
Hi Fahad,
Which dimension are you using for this load?
And what do you mean by creating new members in the conversion file?
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What I mean when I say I am creating new members in the conversion file is that I am adding new rows to it (mapping accounts from the flat file to BPC) The accounts that I am mapping already exist in BPC and in the flat file.
Below is my Transformation file. The dimension and file in question is Account and account.xls.
OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = TAB
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=NO
MAXREJECTCOUNT=999999
ROUNDAMOUNT=
*MAPPING
Account=GL_Account
Entity=CompanyID
AuditID=*newcol(INPUT)
Currency=*newcol(LC)
Consoscope=*newcol(G_NONE)
Interco=*newcol(I_NONE)
Time=AsOfDate
Category=*newcol(BUDGET)
Flow=GL_Account
*CONVERSION
Account= account.xls
Entity=Entity.xls
Time=Time.xls
AMOUNT = account.XLS
Flow=flow.xls
Hi,
After adding new accounts did you logout and login again from Excel or Refresh Metadata for current connection from EPM-->More.
Thanks,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes they all exist. Everything is matching. When I run conversion validation it show as successful, however when I run transformation validation it give me the error. The accounts in BPC and in the flat file both exist. I have trip checked it. I have a feeling that the update did not process properly in the conversion file or the conversion file is not being correctly read for the new rows added.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.