Filter a specific value as well as allow user entery selection

[Former Member]

Does anyone know if you can create a default value selection to always be used in a query, and allow a user to enter values as a variable?

For example, say I want to see employees for Department 1 in every Webi report using this query (can't use a variant) but I want the managers to be able to add their own Department (2-5) to the report.

What is the best practice for achieving this goal?

Thanks.

[Former Member]

Hi Bonnie,

you can achieve this with a variable

1) create a characteristic variable on 'department' --> go to variable properties and choose "default values" , enter default value (ex : department 1)  ..

so when ever you run the report, department selection screen just gets selected with the default value which you choose in variable

2) in the same variable  properties --> detail tab --> choose either 'selection option'/ 'interval' and optional.

this will allow users to choose from the list.

[ccc_ccc]

Hi Bonnie,

You can give default values in BEx Query Designer-->Filter-->Default Values -> Drag & Drop infoobjects and respective default values.

Regards

Nanda