rule line error runtime error :circular reference, evaluation stack

[mrdauduong]

hi,

today, i got this error that i never seen that before, so, any help or any exp will be appreciated !

thanks !

my trouble

trouble rule.png (45.29 KiB) Viewed 3738 times

trouble rule 2.png (568.71 KiB) Viewed 3738 times

[Emixam]

People usually pay me to fix that kind of problem. I feel like every time you have an issue, you post on this forum.

[Wim Gielis]

People usually pay me to fix that kind of problem. I feel like every time you have an issue, you post on this forum.

Creating 11 topics in the first 20 days is quite a high average.

[lotsaram]

People usually pay me to fix that kind of problem. I feel like every time you have an issue, you post on this forum.

Yeah dude seriously no one is going to read through that much code and provide you with a free answer (not even Declan).
A circular reference is exactly what the error says it is. Find it and fix it.

[mrdauduong]

To be honest, in beginning, my question is only "what is a circular reference rules"
In the forum rule, i saw that i need to be as clear as possible. this is why i try to post all code here.
But this is maybe not a good way to ask a question. Iam sorry about that.

[MarenC]

Hi,

as the others have said this is a painstaking find and fix problem.

One other thing I will mention, I am pretty sure that I have seen in the past too many continue statements causing similar problems.

So if you get really stuck after a painstaking trawl through the rules, you might want to look at that and and try and combine into nested if statements.

Maren

[mrdauduong]

Thank maren for the reponse, problem solved, i found that i compare A with B while B is calculed by A. but i still dont understand why it cause reference circular error.

B = A * coefficient (0,1-1)
i have a condition if (B>A), B, A.

I still need to do this and i need to understand why there are a reference circular here.


Thanks !


So if you get really stuck after a painstaking trawl through the rules, you might want to look at that and and try and combine into nested if statements. ==> this is a good advise, i use continue a lot before but now, i try to use if to replace

Hi,

as the others have said this is a painstaking find and fix problem.

One other thing I will mention, I am pretty sure that I have seen in the past too many continue statements causing similar problems.

So if you get really stuck after a painstaking trawl through the rules, you might want to look at that and and try and combine into nested if statements.

Maren

[Steve Rowe]

wrt to a circular reference one thing that isn't always obvious until it happens to you the first time is that you need to consider rules and consolidations in the dimension together.

To illustrate this with a silly example.

Say your period dimension has Jan rolling into Year.

and you write a rule

['Measure A' , 'Jan']=N: ['Measure A', 'Full Year'];

Then you create a circular reference since in the rule Jan depends on Full Year and in the consolidation Full Year depends on Jan.

Note though that the below isn't circular (unless Measure B and Measure A are also dependant on each other).
['Measure A' , 'Jan']=N: ['Measure B', 'Full Year'];

[Wim Gielis]

Did you google for a second ?
For instance: TM1 rule circular reference
The very first hit is: https://code.cubewise.com/blog/resolvin ... alculation

[mrdauduong]

Thank for the explain! i have it something in excel formula but this is a first time i have in TM1, i have no idea why a condition can make a reference circular while it work on 1 but not other

probleme is on this line, but this line dont make the trouble in the first case (PR1 MAX)

rule line error.png (374.7 KiB) Viewed 3577 times

Code: Select all

['PR1_CALCUL_MAX'] = N: 
IF(DB('D_PRICING_SELECT_SIMULATION', !D_PRICING_DIM_VERSION, !D_PRICING_PDTS_GROUPE_PRIX_RELATION,'Value') @= 'Oui'
&ATTRS('D_PRICING_DIM_PDTS', !D_PRICING_PDTS_GROUPE_PRIX_RELATION, 'REF_BENCHMARK')@=''
	,0
	,if(attrs('D_PRICING_PDTS_GROUPE_PRIX_RELATION',!D_PRICING_PDTS_GROUPE_PRIX_RELATION,'type_element')@=''
		,if(DB('D_PRICING_SIMULATION', !D_PRICING_DIM_VERSION, !D_PRICING_DIM_POS, !D_PRICING_DIM_ORGA, !D_PRICING_PDTS_GROUPE_PRIX_RELATION, 'SIM')<DB('D_PRICING_SIMULATION', !D_PRICING_DIM_VERSION, !D_PRICING_DIM_POS, !D_PRICING_DIM_ORGA, !D_PRICING_PDTS_GROUPE_PRIX_RELATION, 'PR1')
		
			,DB('D_PRICING_SIMULATION', !D_PRICING_DIM_VERSION, !D_PRICING_DIM_POS, !D_PRICING_DIM_ORGA, !D_PRICING_PDTS_GROUPE_PRIX_RELATION, 'PR1')
			,DB('D_PRICING_SIMULATION', !D_PRICING_DIM_VERSION, !D_PRICING_DIM_POS, !D_PRICING_DIM_ORGA, !D_PRICING_PDTS_GROUPE_PRIX_RELATION, 'SIM'))
			
		,DB('D_PRICING_SIMULATION', !D_PRICING_DIM_VERSION, !D_PRICING_DIM_POS, !D_PRICING_DIM_ORGA, attrs('D_PRICING_PDTS_GROUPE_PRIX_RELATION',!D_PRICING_PDTS_GROUPE_PRIX_RELATION,'element_base'), 'PR1')));

Anyway, thanks for your help ! now, i know where is the problem, i will just delete it and try to make another way. i'am not very smart on math

[MarenC]

Hi,

Bit puzzled why the REF_BENCHMARK ATTRS for D_PRICING_GROUPE_PRIX_RELATION would be asking if it was equal to itself?

If you removed that ATTRS does it work then?

Other than that not enough information to provide an answer and as others have already said, not something anyone has time for really.

Maren

[mrdauduong]

Thank maren for the reponse, we can close the topic here.

To answer your question :
- Bit puzzled why the REF_BENCHMARK ATTRS for D_PRICING_GROUPE_PRIX_RELATION would be asking if it was equal to itself? ==> because i have to apply this rule only for the element who have himself in the attribut REF_BENCHMARK
- If you removed that ATTRS does it work then? => it work if i romove that ATTRS, this is why i dont understand

==> i will try another way to do this thing or use a TI.

Thanks your help !

Hi,

Bit puzzled why the REF_BENCHMARK ATTRS for D_PRICING_GROUPE_PRIX_RELATION would be asking if it was equal to itself?

If you removed that ATTRS does it work then?

Other than that not enough information to provide an answer and as others have already said, not something anyone has time for really.

Maren