Hi,
I am new to TM1. I am confused with Rules Vs Process on some feature.
1) "process" can update data in cube, right? Can "rule" store data? or just evaluate data (e.g. query in rdbms, without storing data)?
2) If i run a process to update a cube: "A" (e.g. dimension: month, product) with cells as "1", and then I create a rule in the cube: "A" to update all Jan. data equal to "2" (e.g. ['Jan'] = N:2; ). Then what is the result of Jan figure if I browse the cube "A" (1 or 2)?
Rule Vs Process
- qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Rule Vs Process
Welcome. A good place for you to start would be the official product documentation, the FAQ on this forum, and the many interesting thereads on it.plkkw wrote:I am new to TM1.
Rule is a real-time calculation that is performed when someone requests data from those cube cells that are affected by that rule. Processes can manipulate the actual values stored in cubes, among many, many other things.plkkw wrote:1) "process" can update data in cube, right? Can "rule" store data? or just evaluate data (e.g. query in rdbms, without storing data)?
Rules always take precedence over stored values. If there is already a value in the cube when you create a rule, then depending on the version this value will either stay in the cube and be ignored until you delete the rule or will be deleted from the cube altogether (in newer versions). Once you have the rule attached it becomes impossible to input any values into the affected cube area.plkkw wrote:2) If i run a process to update a cube: "A" (e.g. dimension: month, product) with cells as "1", and then I create a rule in the cube: "A" to update all Jan. data equal to "2" (e.g. ['Jan'] = N:2; ). Then what is the result of Jan figure if I browse the cube "A" (1 or 2)?
Kamil Arendt