Tuesday Tech Tip (a bit early on Monday):
The development of custom reports for Identity Manager isn't possible OOTB with the bundled product.
Please consider that there's a plethora (or abundance) of Out-Of-the-Box (OOTB) reports, which are constantly being enhanced and extended to meet most of the common business requirements. (This includes a list of audit reports, which weren't available in the original r12 code path.) So it's possible you won't require much customization, but if you have a large population or specific business requirements, perhaps you would like the ability to further customize the pre-canned Crystal reports. If so, please follow the following guidelines when attempting these customizations....:
First and foremost, it's important to understand that Crystal Reports Developer is not provided by CA, so the customer needs to purchase a license from BO/SAP. The recommended Crystal Reports Designer is not included with the IM bundle and must be purchased separately.
Bundled BO tools, Business View manager and crystal explorer, please note that business view manager is not a report authoring tool, so it has very limited capability. It only works on the reports that already have business views and it can only change certain fields. If this limited functionality meets your needs, you can use Business View manager and Crystal Explorer. But if you need full report authorizing functionality, Crystal Report Developer is the recommended tool and it's the tool tested with IM r12 and r12.5 reporting.
For anything to do with Crystal Report modification, client should buy the Crystal Report developer license. While, they can use the business View manager and crystal explorer, you should note that business view manager is not a report authoring tool. This tool allows you to create data model for use with crystal report developer and crystal explorer is tool with very limited capability in fact only work on the reports that already have business views and it can only change certain fields. Neither one of these tools are appropriate tools for modifying crystal reports, you should recommend that for modification of the Crystal Reports, Crystal Reports Developer need to be purchased.
IM reporting does not use Universe. It uses JDBC connection directly to the reporting database. To establish connection to IM reporting database, please refer to Page 14 - 17 in the Green Paper " How to Create Custom Reports in Identity Manager R12"
CR developer XI OOTB and custom reports are only meant for CABI 2.1 NOT .(CABI 3.2)
Crystal report 2008 has new features that are only supported in the BOXI 3.X. Identity Manager r12.5 SP7 and r12 CR16 both ship with CABI 3.2 or in SAP terminology BO XI 3.1 SP3. (earlier versions of IM used to ship with earlier versions of CABI)
Please see TEC508249for further details, including how to customize your reports and a discount on the purchase of CR Developer.
Please respond with any questions or concerns.
Thank you.
Regards,
Chris Thomas
CA Technologies
Principal Support Engineer
Tel: +1-631-342-4360
Chris.Thomas@ca.com