Description:
Most installations of CA SDM have custom extensions to the out of the box MDB tables that CA SDM installs.
Consider this scenario:
This document documents how best to report the Call Request's Customer's ZBPType details without heavily customizing the CA SDM CABI Universe.
Solution:
The solution is to create an Attribute Alias within SDM via the Service Desk Administration tab.
As described in the scenario above, the intention is to display the zBPType's Name of a given Customer for a given Call Request record. We need to create an attribute alias for that value and let CA SDM automatically create the necessary joins.
Each attribute alias defines a pseudo column that corresponds to a column of a joined table. The current CA SDM CABI ODBC driver allows an unlimited number of attribute alias columns to be added to each object.
Perform the following steps:
Create attribute aliases in CA Service Desk Manager
Update CABI Universe:
Report:
Create a new report with other Request Details based fields alongside the newly added object zCustomerBPTypeName within the Request Details class. For each Call Request record now you will see the customer's zBPType Name value automatically within the report.
The benefit of using the attribute alias approach is that it eliminates the need to create and maintain table joins within the CABI Universe.
Note:
If there is Replicated Database/offline reporting involved:
For more information on Attribute Aliases, refer to Online Bookshelf / Help with in CA SDM Administrator interface or the CA SDM Administrator Guide.