please help me in understanding if it's possible to have a report filter containing all the possibile values for the dimension it refers to, so that changing the value in this filter, the query is refreshed and shows data according to the new selection.
E.g. In a WebI report I have a table with columns DEPARTMENT, SALES_VALUE and a prompt for "MONTH", so that data in the report are referred to a single month. If I insert the MONTH dimension as a report filter, the drop down list shows only the month selected in the prompt.
My question: is it possible having MONTH query filter drop down list containing all months (not only the month selected in the prompt), so that I can refresh data in the report changing selection in this list? I mean, In the moment I choose another MONTH from the drop down list associated to the report filter, the report should refresh data (re-launch queries) according to the new month.
Hope I've been understandable in some way...
Many thanks for your valuable help!