Skip to Content
Former Member
Jan 28, 2009 at 12:52 AM

Choosing a Context when running a Query



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.