Page 1 of 1

tips for writing rules

Posted: Tue Nov 23, 2010 9:11 am
by charan
hi,
I am begineer in TM1, i am working on rules, i have worked on rules which i got from higher collegues and able to do it. when i am tryong of my own rules with developing new models or cubes and writing rules for it, i am always getting error like"Invalid statement with the particular element with the element i have developed" Can give me suggestion for executing the rules correctly.
Example i have developed....
with dimension rule1 with profit,loss, s.p,c.p.
with dimesion gross profit, margin.
rule is..
margin=profit*loss;
when i write this rule i got the error loke invalid statement.
Give some suggestion to correct my self and to get it.

Thanking you very much.

TM19.5
excel 2007.

Re: tips for writing rules

Posted: Tue Nov 23, 2010 10:21 am
by comma
Element must be written using square brackets and apostrophes:

Code: Select all

['margin'] = ['profit'] * ['loss'];

Re: tips for writing rules

Posted: Tue Nov 23, 2010 1:22 pm
by tomok
The Rules editor has a wizard-like interface for helping you with the syntax. Why are you not using this?

Re: tips for writing rules

Posted: Wed Nov 24, 2010 3:25 am
by charan
Boss,
Thank you, i have done what you told me.The mistake i done was i used feeder symbol in the rule.

Thank you very much.