Choosing a Context when running a Query

Hello,

I have 4 Facts Tables my Universe A, B, C & D, thus have 4 context paths

A, B, C and fact tables and share common dimensions within them. D is a view which I created which takes the value from the A & B Fact tables .

I ran a query which takes all values from D and it works fine, however when I run a query taking all values from either A or B, it asks me to choose the context. The best part is that the context which query is based out of is not selected.

Question) How do I ensure that I do not get this message every time, as the intent is that all the data for all the filters will be dumped into Excel via QAAWS for the Xcelsius dashboard.

Please advice.