Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 27, 2009 at 03:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.