Fetching details on parameter of Quantitative Rules like " Avoid Artifacts with High RAW SQL Complexity "

Hi,

We can fetch the parameter detail of Quantitative Rules like " Avoid Artifacts with High RAW SQL Complexity " .

Please find the steps to fetch the details by CAST-MS as well as using a query:

For ex:, in case of above mentioned rule, from CAST-MS you can navigate as explained below:

1] Search the particular rule in assessment model and click on parameter tab inside the rule. Below highlighted is the parameter:

2] Double click on the parameter name to open it and check the details. Here we can see the details like default value of that parameter.

An alternative solution is to query table - DSS_METRIC_PARAM_TYPES 

select * from DSS_METRIC_PARAM_TYPES where metric_id=7829

Please note that in this table default value is not stored because this value can be changed by user as per their need.