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.