Skip to Content
Former Member
Jun 06, 2008 at 03:11 AM

Adding a Default value to the Filter in a Workbook



I have created a workbook in BI 7.0. In the Filter, for a variable its displaying '#' as default value, but i want to display one of my variable values there.

I added this value in the 'Default values' tab of the variable in the Query Designer. After saving the query, i went to workbook, clicked on the Filter button, changed to design mode, clicked on the Filter pane, assigned the query as the Infoprovider& saved the workbook. But still i am getting the '#' in my Filter.

I closed the workbook, opened it again & refreshed it but still i couldnt see the variable i added. Am i missing any other thing? Please guide me. Thanks for your time.