Once a Stored Procedure is added as a dataset to Rockdaisy platform the new ‘Dataset Parameter’ entities equal to the Stored Procedure parameters will be created. The ‘Dataset Parameter’ are used during the filter creation. ‘Filter Variable’ list on the new filter page contains the list of all ‘Dataset Parameters’.
‘Dataset Parameter‘ can be added manually, during the filter creation process. In order to do it check ‘Not Listed’ checkbox next to the filter ‘Filter Variable’ field and type any @FilterVariableName. Once the filter is saved the new ‘Dataset Parameter’ with @FilterVariableName will be created, it means that next time @FilterVariableName will be available in the ‘Filter Variable’ list for all next filters.