COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: anilkumar on 01 Jun 2010 08:39:42 AM

Title: hi
Post by: anilkumar on 01 Jun 2010 08:39:42 AM
hi

when importing data , iam getting error like invalid item entire rows were rejected.

help me  out.

Regards
ANIL K.MARRI
Title: Re: hi
Post by: vipul.bahl@gmail.com on 08 Jun 2010 04:26:15 AM
Hi,

Did you import through text files? or you imported data in IM tables?
This generally appears when names have not been specified correctly in the import file and they are not same as Target cells.
Kindly also keep in mind the cases of the data being imported.

Like for example. if you have 3 dimensions Months, location, measures.
Month contains: Jan, Feb, Mar
Location: India, US, Australia
Measure: Expense

So in the import file, there should be 4 columns:
Months              location               measures          Importvalue
Jan                   India                     Expense           100


If in place of Jan, one puts jan (kindly note the case), the row will be rejected.

I think this should solve the issue.