Retail Predictive Application Server (MOSC)

MOSC Banner

Error with the configuration of the position queries

edited Dec 16, 2018 4:02AM in Retail Predictive Application Server (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center