load error:Dimension:XXXX member:XXXX is invalid or is a calculated member

[former_member190501]

Dear Gurus,

I have created dimensions loaded with data and created a new application based on those dimensions. When I try to load data from flat file to application getting following error.

Dimension: HRACCOUNT member: BONUS is invalid or is a calculated member

When I click on Validate transformation definitions getting above error.

In transformations I maintaining file as follows :

*MAPPING

ENTITY=*COL(1)
CATEGORY=*COL(2)
INTCO=*COL(3)
HRACCOUNT=*NEWCOL(BONUS)

Following are Dimension members(data) in HRACCOUNT:

HRACCOUNT	Language Key	Calc member flag	HIR	Scaling	Long description
401K	EN	N	H1	Y	401(k)
AnnualData	EN	Y	H1	Y	Annual Input Data
AnnualPCTINC	EN	N	H1	N	Annual Percent Increase
AnnualSalary	EN	N	H1	Y	Annual Salary
ApprovalFlag	EN	N	H1		Approval Flag
Bonus	       EN	N	H1	Y	Bonus
CarAllowance	EN	N	H1	Y	Car Allowance
DaysInPeriod	EN	N	H1	N	Days In Period
DentalIns	EN	N	H1	Y	Dental Insurance
FAS106	       EN	N	H1	Y	Ret Med (FAS 106)
FICA	       EN	N	H1	Y	FICA
FICACalcBase	EN	N	H1		FICA Calc Base
HRCalcs	EN	Y	H1		HRCalculation Accounts
HRRATES	EN	Y	H1	N	HRM Rates for the Account Calculations
Headcount	EN	N	H1	N	Headcount
HealthIns	EN	N	H1	Y	Health Insurance
Incentive	EN	N	H1	Y	Incentive
LifeIns	EN	N	H1	Y	Life Insurance
Medicare	EN	N	H1	Y	Medicare
MonthlyBase	EN	N	H1	Y	Monthly Base Salary
MonthlyPCTINC	EN	N	H1	N	Monthly Percent Increase
MonthlySalary	EN	N	H1	Y	Monthly Salary Increased
OT            EN	N	H1	Y	Overtime

When I try with following transformation it went through successfully.

*MAPPING

ENTITY=*COL(1)
CATEGORY=*COL(2)
INTCO=*COL(3)
HRACCOUNT=*NEWCOL(OT)

Why I'm getting error for some members only ?

Your help is highly appreciated.

thanks in advance...

regards,

Raju

I'm very sorry facing some problem while posting thread.

Edited by: VaraPrasadraju Potturi on Aug 27, 2009 4:36 AM

[former_member190501]

Dear All,

I found the root cause to my issue. Issue is with Dimension members(data).Whenever we use *NEWCOL(A)( here A is a member), member values are converted to Upper case and check against dimension members. In my dimension some of my members are maintained as follows : Bonus, Pension....

System is comparing BONUS with Bonus and could not find match. thats why its giving error. When I use OT in transformation ,my dimension member also maintained as OT and going with out errors.

Using conversions I'm able to load successfully for *NEWCOL(BONUS).

thanks and regards,

Raju