Error with the configuration of the position queries
Hi all,
I tried to configure the position queries but I received an error on the circular dependency.
The base intersection of my worksheet is mnth_str_repr_ver (month,store,department, version).
The base intersection of my measure is str_ver (store, version).
The condition is NCWpVersPosQrBo=if(measure1 > 0 || measure 2 > 0, true, false), where the base intersection of the measure1 and of the measure2 is mnth_str_repr_ver (month,store,department, version).
I applied this position query to the dimensions Location (str) and Version (ver),
but if I have this two dimensions on the Z axis I receive the error on the circular dependency, while if I have only one of the dimensions on the Z axis the position query works.