Unable to ignore some selection in a star model

jleberre — Mon, 27 Nov 2017 11:36:33 GMT

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!

Re: Unable to ignore some selection in a star model

shraddha_g — Mon, 27 Nov 2017 11:58:42 GMT

PFA.

Sum({<date={"$(=Max({<call_reason=,advisor_name=>}date))"},call_reason=,advisor_name=>}nb_subscriptions)

Re: Unable to ignore some selection in a star model

jleberre — Mon, 27 Nov 2017 12:33:52 GMT

perfect! thank you...

topic Re: Unable to ignore some selection in a star model in App Development

Unable to ignore some selection in a star model

Re: Unable to ignore some selection in a star model

Re: Unable to ignore some selection in a star model