tips for writing rules
Posted: Tue Nov 23, 2010 9:11 am
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.
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.