Adding a Default value to the Filter in a Workbook

[Former Member]

Hi,

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.

Regards,

Murali

[Former Member · Accepted solution]

Hi,

adding a value as default value for a variable is only relevant for the selection screen.

If u want to define # in the navigation pane u can do that there and save the workbook.

Then # is saved as filter on workbook lvl, but its changeable by the user.

Hint: In analysis mode disable "initial query view on refresh" in dataprovider settings of the analysis grid.

Regards

Tobias

P.S. Giving points is the way to say thx in SDN!!!

Edited by: Tobias on Jun 6, 2008 7:50 AM

[Former Member · Accepted solution]

Hi Tobias,

I have already tried what u have mentioned. I have added the filter value in the Navigation pane & it also got added but once i refresh the workbook only the old filter value is getting displaye. The value i added is not showing up. Any other suggestion for this?

S P : What u have mentioned is for BW 3.5, but i am using 7.0.

Anyway, thanks for ur suggestions.

Regards,

Murali

[Former Member]

Hi Murali,

After chaning the value to the variable in the query designer. Goto workbook, remove the query from work book and save. Now add the same query in the workbook and execute the query. Now, remove the query result from the workbook. This will be done as follows: From menu bar, select Business Explorer -> tools -> All queries in workbook -> delete results. Now, save the workbook.

From the next time, when ever you run the workbook, the value in the filter will be taken from the variable.

I hope this will solve your issue.

Regards,

S P.

[Former Member]

Hi,

this option "delete result from query" is only available for BEx Analyzer 3.5.

Regards

Tobias