I want a global filter for date in my webi report which could filter all my queries/charts. I tried creating a variable where I could fetch my months which are less than current date. Now I have more than one chart to get filtered by this date.
I tried by creating a new query and adding that object from another query to rest. But that option is disabled for picking object from another query is found disabled. I am using a relational universe (.unx)
Also, I want my current month to be populated as default in the input control.
Creating Input Control for each query is not correct. So can anyone suggest how can I achieve this? Please help me