Hi All, To remove cascading completely, Steps what I took are Removed referenced parameters in the parameter query Deleted (@ ) Parameters from parameter list. Deselected the Parameter Caption Intended in Label field--Parameter Properties and selected Exposed. Query Results are Exposed ParameterCaption Parameter Value ParameterLevel (null) All [T Open Closed PO Fact].[All] 0 No No ----- 1 Yes Yes ----- 1 Unknown Unknown -------- 1 This is the result set what I got it from the query. However when I select the Exposed column as parameter label field in the Parameter Properties, it is showing "[T Open Closed PO Fact].[All]" in the drop down list. How to get All instead of this. I appreciate your time. Thanks Tarak.