If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

hi

Started by anilkumar, 01 Jun 2010 08:39:42 AM

Previous topic - Next topic

anilkumar

hi

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

help me  out.

Regards
ANIL K.MARRI

vipul.bahl@gmail.com

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.