Input Controls in webi only applies to one query at a time

[Former Member]

Dear all,

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

Regards

Archana

[arijit_das · Accepted solution]

Did you try to merge the dimension from multiple queries and then create the input control filter on the merged dimension ?

[Former Member · Accepted solution]

Dear Arijit,

I use webi thin client .I cannot find any option to merger dimensions apart from the settings in document properties. I tried filtering the query item from another query which is disabled.

Regards

Archana

[arijit_das · Accepted solution]

check this: Web Intelligence 4.0: Merge dimensions from different universes

[Former Member · Accepted solution]

Thanks Arijit and Niraj.

Merging dimensions solved my problem

Regards

Archana