Rule Vs Process

Post Reply
plkkw
Posts: 23
Joined: Wed Sep 21, 2011 6:18 am
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2003

Rule Vs Process

Post by plkkw »

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)?
User avatar
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

Post by qml »

plkkw wrote:I am new to TM1.
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:1) "process" can update data in cube, right? Can "rule" store data? or just evaluate data (e.g. query in rdbms, without storing data)?
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: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)?
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.
Kamil Arendt
Post Reply