Skip to Content
0
Aug 27, 2009 at 02:34 AM

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

176 Views

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