I have two AF analyses. Depending on the value of a third attribute, either one can be expressed in terms of the other.

Analysis B: expression = IF D = 0 THEN C ELSE A

Analysis C: expression = IF D = 0 THEN A ELSE B

As you can see, it is not possible for this to be circular as the value D performs switching. IF D is zero then B is in terms of C, if D is not zero then C is in terms of B. In each case an independent value A is used for the one that is not in terms of the other.

AF flags both these analyses as circular and will not run them. How can I get round this?

Jeremy

Hey Jeremy,

You will need a periodic scheduling or be careful with your triggering input not to create a circular reference. In your last setup, if C receives a value, this triggers Analysis B1, which then triggers Analysis B (provided B1 is a triggering input) which then triggers C1 which then triggers C (provided that C1 is a triggering input) which then triggers C and we restart the loop. This is an infinite triggering loop, the Analysis Service prevents these by flagging them as circular reference.

You can workaround this by using a periodic scheduling.

Hope this helps,

Seb