Reporting using SQL Server

[reyesfra]

Hi,

I have never played with Cognos Planning before.

I've been given an assignment to create reporting out of the Cognos Planning tables using Sql Server.  When I perform a "select * from" on the tables, the records are all encrypted including the view files, they have the 1st primary key with encryption...

Has anyone out there accomplished reporting from SQL Server 2005 ? by decrypting the records ? 

Any help is appreciated. . .   :(

[sascha]

Hi reyesfra

there is a bunch of good stuff in the 'Proven Practices' session on the Cognos support website covering this topic and explaining it at very deep level:

You can have a look at these docs:

• Reporting from new 8.2/8.3 Planning Features
  http://support.cognos.com/supported/tti/public/docs/cognos_pp_reporting_reporting_on_new_ibm_cognos_planning_8.2_8.3_features.pdf
• Cognos Planning as a Data Source for Cognos BI Reports
  http://support.cognos.com/supported/tti/public/docs/cognos_pp_modeling_cognos_planning_as_a_data_source_for_bi.pdf
• Reporting from Planning Applications
  http://support.cognos.com/supported/tti/public/docs/cognos_pp_reporting_reporting_from_planning_applications.pdf

And don't worry, there aren't any decrypted records at all  ;)

[reyesfra]

Thanks Sascha..  I will review the material . . this is a good start...  :)