2 Replies Latest reply: Nov 27, 2017 7:33 AM by Julien Le Berre RSS

    Unable to ignore some selection in a star model

    Julien Le Berre

      Hello

       

      I would to ignore some selection for some indicators.

      Attached is a QVF example.

       

      For example, the indicator "nb subscriptions" should:

      - change according to selection in Calendar, DimOffers, and DimCustomers

      - not change according to selection in DimCalls and DimAdvisors

       

      I observe that:

      - Sum({<call_reason=,advisor_name=>}nb_subscriptions) : ok

      - Sum({<date={"$(=Max(date))"},call_reason=,advisor_name=>}nb_subscriptions): ko -> = 0 when selecting a value in call_reason or advisor_name fields

      - Sum({<offer_name={'offerA'},call_reason=,advisor_name=>}nb_subscriptions): ok -> ignore selection in call_reason or advisor_name fields

      - Sum({<date={"$(=Max(date))"},offer_name=,customer_name>}nb_subscriptions): ok -> ignore selection in offer_name or customer_name fields

       

      So it seems that there is a problem when I associate, in a set analysis, "date={"$(=Max(date))"}" and some "fields=" expression, where fields were not used to calculate the indicator

       

      Can someone help me please?

       

      Thanks!