When importing a customized report template into Control Compliance Suite (CCS), you are presented with an error about unexpected parameters.
Example error on template import attempt:
The expected parameters are:
1.) AssetGroup
2.) Folders
3.) AssetJobID
4.) StandardJobID
5.) Top
6.) ReportRunBy
7.) ReportRunDate
8.) ReportJobName
The following extra parameters were found in the report template:
1.) @asset_attr1
2.) @asset_attr2
3.) @asset_attr3
4.) @asset_attr4
5.) @asset_attr5
6.) @asset_attr6
7.) @asset_attr7
8.) @asset_attr8
9.) @asset_attr9
10.) @asset_attr10
Specify a valid report template.
The specific error above was encountered when trying to import a customized Standard based template. The list of expected parameters in the error are the parameters that CCS expects to have referenced in a Standard based report template. The list of unexpected parameters refers to additional parameters that are required to be passed to the report during run time in order to resolve the values of fields that have been added to the report. Report templates that require parameters beyond those expected are not importable into CCS
Most likely a value in the DETAIL row of the report contains fields that require a parameter to be passed to the field before that field can resolve to a fixed value during run time. The particular AttrX_string string fields indicated in the error above are ones that are defined by the usp_GetNonBaseAssetAttributes stored procedure in the CSM_Reports database. In this particular case someone has used parameters from this procedure as field values in the DETAIL row of the report. CCS does not recognize these parameters and therefore at run time cannot determine what the value of the parameter would be. Report templates can only require parameters that are listed in the acceptable parameters for the specific type of template being imported (see information below).
The information below specifies the list of predefined and mandatory parameters (in CCS 10.x.x) that must and can be present on a user defined template for the particular type of business object business object that the template is built on:
*******************************************************
Parameter Name
|
Description
|
AssetJobID
|
This parameter will be set to a unique identifier value to be used for joining assets related data tables in the CSM_Reports database with the ReportJob table in the CSM_Reports database.
|
AssetGroup
|
This parameter will take the ID of the asset group which will be present in the scope of the report
|
Folders
|
This parameter will take in the ID of the folder in the asset system that needs to be used as scope in the report
|
ReportRunBy
|
The name of the user who executed the reporting job for this report
|
ReportRunDate
|
The date on which the reporting job was run for this report.
|
Parameter Name
|
Description
|
StandardJobID
|
This parameter will be set to a unique identifier value used to join standards related tables in the CSM_Reports database with the ReportStandardJob table in the CSM_Reports database.
|
ReportRunBy
|
The name of the user who executed the reporting job for this report.
|
ReportRunDate
|
The date on which the reporting job was run for this report.
|
Parameter Name
|
Description
|
ControlPointType
|
The display name of the control point type for e.g. symc-wnt-file.
|
Status
|
The status of the control point
|
DataOwner
|
The owner of the control point.
|
Tags
|
The tags associated with the control point.
|
EntitlementsControlPointJobID
|
This parameter will be set to a unique identifier value to be used for joining assets related data tables in the CSM_Reports database with the ReportJob table in the CSM_Reports database. This parameter is a part of the filter set definition XML that is used to filter out control point types.
|
ReportRunBy
|
The name of the user who executed the reporting job for this report.
|
ReportRunDate
|
The date on which the reporting job was run for this report.
|
AssetGroup
|
The asset group to be used as scope in the report
|
Folders
|
The folders that will be used as scope in the report.
|
Parameter Name
|
Description
|
CurrentOrSnapshotted
|
This parameter will determine whether the scope of the report contains the current review cycles or does it contain snapshot review cycles.
|
Status
|
The status of the review cycle
|
ReviewCycleID
|
The ID of the review cycle.
|
ControlPointType
|
The display name of the control point type for e.g. symc-wnt-file
|
DataOwner
|
The owner of the control point.
|
Tags
|
The tags associated with the control point.
|
EntitlementsReviewCycleJobID
|
This parameter will be set to a unique identifier value to be used for joining assets related data tables in the CSM_Reports database with the ReportJob table in the CSM_Reports database. This parameter is a part of the filter set definition XML that is used to filter out control point types.
|
ReportRunBy
|
The name of the user who executed the reporting job for this report.
|
ReportRunDate
|
The date on which the reporting job was run for this report.
|
AssetGroup
|
This parameter will take the ID of the asset group which will be present in the scope of the report
|
Folders
|
This parameter will take in the ID of the folder in the asset system that needs to be used as scope in the report
|
Parameter Name
|
Description
|
PolicyJobID
|
This parameter will be set to a unique identifier value to be used for joining policy related data tables in the CSM_Reports database with the PM_PolicyUser table in the CSM_Reports database.
|
ReportRunBy
|
The name of the user who executed the reporting job for this report.
|
ReportRunDate
|
The date on which the reporting job was run for this report.
|
Only the expected parameters can be passed to the report by CCS at run time. Any other additional field values in the report will need to be values that are fixed values from tables or calculations and cannot be ones that require additional parameters to be passed to the report before the value of the field can determined.
Applies To
Control Compliance Suite 9.0.1 and higher.