Data Import

[jessewalia]

Hello Everyone,

I am new to Cognos and this might be a dumb question :( After creating a data connection (SQL Sever) how can I import data to actually start creating reports. Any help will be appreciated.

Thank you,
-Jesse

[blom0344]

Importing is not the right phrase. Data is read at runtime using a report package. A package originates from a Cognos model. The model serves as a semantic layer between report and database. The model / packages uses the datasource to the database where data is stored.

[jessewalia]

Thank you for replying. After creating the package - I got the following error when publishing hence no data was populated.

"BMT-MD-2040 The query subject "[SQL].[assembly_files]" contains a query item with a blob datatype. To fetch the blob data, it must be possible to uniquely identify a row of data. Please define a determinant that contains keys that uniquely identify the row." any feedback on correcting this?

Thank you for your help again.
-Jesse

[jessewalia]

Figured it out. Need to create determinants.  :D

[blom0344]

What do you want with Binary data?

[Cognos Business]

Importing is not the right phrase. Data is read at runtime using a report package. A package originates from a Cognos model. The model serves as a semantic layer between report and database. The model / packages uses the datasource to the database where data is stored.

thank you for this answer!  ;)

[blom0344]

@Cognos Business,

Don't tell me you offer Cognos services/consultancy and I wrote something you did not yet know..   ;)