Rule editors [] =[]
- Chengooi
- Posts: 64
- Joined: Tue Jan 13, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Auckland, New Zealand
- Contact:
Rule editors [] =[]
I was trying this line ['Oct-08','Actual'] =>['Oct-08','Test']; in rule editor and did not give me any result at all.
Can someone tell me what 's wrong with that line.
The cube has 5 dimensions of which these 2 dimensions were specified in the rule, the other 3 simply ALL.
Please help!
Can someone tell me what 's wrong with that line.
The cube has 5 dimensions of which these 2 dimensions were specified in the rule, the other 3 simply ALL.
Please help!
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
e e cummings (1894-1962)
-
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
Re: Rule editors [] =[]
are you trying to write a rule or a feeder?
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Rule editors [] =[]
Skipcheck;
['Oct-08','Test'] =N: ['Oct-08','Actual'];
Feeders;
['Oct-08','Actual'] =>['Oct-08','Test'];
Should get to where you want to be. If your struggling with the basics can I suggest the rules guide that come with the product?
Cheers,
['Oct-08','Test'] =N: ['Oct-08','Actual'];
Feeders;
['Oct-08','Actual'] =>['Oct-08','Test'];
Should get to where you want to be. If your struggling with the basics can I suggest the rules guide that come with the product?
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- Chengooi
- Posts: 64
- Joined: Tue Jan 13, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Auckland, New Zealand
- Contact:
Re: Rule editors [] =[]
Perfect , Thanks very much!
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
e e cummings (1894-1962)
- Chengooi
- Posts: 64
- Joined: Tue Jan 13, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Auckland, New Zealand
- Contact:
Re: Rule editors [] =[]
I was trying to find help for what this line actually do, was it to initialise the element actual ?
['Oct-08','Test'] =N: ['Oct-08','Actual'];
['Oct-08','Test'] =N: ['Oct-08','Actual'];
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
e e cummings (1894-1962)
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rule editors [] =[]
I'm not following you.Chengooi wrote:I was trying to find help for what this line actually do, was it to initialise the element actual ?
['Oct-08','Test'] =N: ['Oct-08','Actual'];
The purpose of a rule is to calculate an "area" (range of values) of the cube based on values stored in another area of the cube (or other cubes), as well as possibly some constants or mathematical functions.
That means that in the line that you've cited, any cell in the cube which contains the elements "Oct-08" and "Test" will return the same values as a cell which uses "Oct-08" and "Actual" in the corresponding dimensions. Since you've specified "N:", This will only be true for N level values; consolidations will be calculated normally.
So in a 5 dimensional cube where those two are the first dimension, you'll end up with a situation where:
DBRW("YourCube", "Oct-08","Test","Dim3Element1", "Dim4Element1", "Dim5Element1")
will return exactly the same value as
DBRW("YourCube", "Oct-08","Actual","Dim3Element1", "Dim4Element1", "Dim5Element1")
and
DBRW("YourCube", "Oct-08","Test","Dim3Element1", "Dim4Element1", "Dim5Element2")
will return exactly the same value as
DBRW("YourCube", "Oct-08","Actual","Dim3Element1", "Dim4Element1", "Dim5Element2")
and so on for every N level element in dimensions 3, 4 and 5.
There's nothing to "initialise"; in that rule you're simply telling TM1 that you want to use the "Actual" values to populate the corresponding "Test" values. Actual is the element that you're drawing from, it's Test that's calculated. If this rule is applied, you'll still be able to make entries to the Actual element, but not the Test one.
As per Steve's suggestion, it might be an idea to work through the Rules manual; all of us cut our teeth on the Fishcakes examples at some point. David Friedlander did a good job of explaining how they work.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Chengooi
- Posts: 64
- Joined: Tue Jan 13, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Auckland, New Zealand
- Contact:
Re: Rule editors [] =[]
Thank you Alan for your excellnet explaination.
My real experience with thsi particular rule was:
I started the line :
Feeders;
['Oct-08','Actual'] =>['Oct-08','Test'];
Thinking that will map all n element of Oct, actual to all n oct-08 test.
But it did not work, so I posted the question and I was told to use
add one line at the begining, so I thought that was initialised line.
['Oct-08','Test'] = N: ['Oct-08','Actual'];
As soon as I added that line, I get Bob's your uncle, so I could not undersatnd why we need 2 lines to get it worked as per se.
what you have explained was ['Oct-08','Test'] = N: ['Oct-08','Actual']; what about the second line below feeder why is it required.
I understood the manual but I am also confused by it.
My real experience with thsi particular rule was:
I started the line :
Feeders;
['Oct-08','Actual'] =>['Oct-08','Test'];
Thinking that will map all n element of Oct, actual to all n oct-08 test.
But it did not work, so I posted the question and I was told to use
add one line at the begining, so I thought that was initialised line.
['Oct-08','Test'] = N: ['Oct-08','Actual'];
As soon as I added that line, I get Bob's your uncle, so I could not undersatnd why we need 2 lines to get it worked as per se.
what you have explained was ['Oct-08','Test'] = N: ['Oct-08','Actual']; what about the second line below feeder why is it required.
I understood the manual but I am also confused by it.
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
e e cummings (1894-1962)
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rule editors [] =[]
Imagine that you have a cube which doesn't have any feeders in it. (It's possible to write cubes without feeders, but in MOST cases it's not a good idea. There are a handful of exceptions that we won't go into here.)Chengooi wrote:I started the line :
Feeders;
['Oct-08','Actual'] =>['Oct-08','Test'];
Thinking that will map all n element of Oct, actual to all n oct-08 test.
But it did not work, so I posted the question and I was told to use
add one line at the begining, so I thought that was initialised line.
['Oct-08','Test'] = N: ['Oct-08','Actual'];
As soon as I added that line, I get Bob's your uncle, so I could not undersatnd why we need 2 lines to get it worked as per se.
what you have explained was ['Oct-08','Test'] = N: ['Oct-08','Actual']; what about the second line below feeder why is it required.
I understood the manual but I am also confused by it.
When TM1 calculates a view of a cube which has rules but no feeders, it would need to calculate EVERY cell in that view just in case that cell might be affected by a rule. Most of the time you don't even need to think about this; if you calculate a zero-supressed view in a cube which has no rules, then you'll get only cells with values in them. However if there are rules and you've elected not to use feeders, TM1 needs to look at every zero value as well... just in case it might need to be calculated.
This obviously slows it down quite a lot.
The alternative is to use a statement called SkipCheck at the head of your rules, which tells TM1 to only look at cells which it knows have a value.
How does it know whether cells have a value? In the case of cells which aren't affected by rules, then there's either a value already there from data entry, or there isn't.
In the case of cells which ARE affected by rules, you need to use a feeder. A feeder is where you take one of the rules formula values, and "push" it (or more precisely push a "flag") to the cells which are affected by the rule. This flags the cell as "needing calculation".
So in your case, any cell which contains the combination of the "Oct-08" and "Actuals" elements will "feed" the corresponding "Oct-08", "Test" cell. In this way, the TM1 server knows that when you calculate a view, it needs to make sure that it has calculated any of the "Test" elements that the view may contain, but it doesn't have to worry about any of the other cells unless they have values from data entry.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Chengooi
- Posts: 64
- Joined: Tue Jan 13, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Auckland, New Zealand
- Contact:
Re: Rule editors [] =[]
I think I am leass confused now, but really grateful to your reply Alan !
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
e e cummings (1894-1962)
- Martin Ryan
- Site Admin
- Posts: 1988
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Rule editors [] =[]
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer