Context selection based on selected dimensions

[Former Member]

Hi,

  We have 1 fact table (F) and 2 dimension tables (D1, D2).

There are two contexts involved: #1. D1 --> F;

                                               #2. D1 --> D2 --> F

  The problem is: when we select 1 dimension from D1, 1 dimension from D2, and 1 measure from F, the query can automatically select context #2. However, when we only select 1 dimension from D1 and 1 dimension from D2 without selecting the measure, it will prompt users to select a context. So, any setting can be done such that user will not need to select a context.

Thanks.

[Former Member · Accepted solution]

You can avoid this ambiguity by checking the option "Multiple queries for each context" in SQL tab of Universe parameters.

If you have only one or two webi reports that users use on this universe and if the reports are predefined, then you can use the "Reset contexts after refresh" option in Query properties of report to default the report query to use valid context.

Thanks

Mallik

[Former Member]

Hi Victor,

Did the above mentioned options solve your problem?

Thanks

Mallik

[Former Member]

Yes, thanks for your help