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. . . :(
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 (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 (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 (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 ;)
Thanks Sascha.. I will review the material . . this is a good start... :)