Push rules vs. Enterprise rules

Post Reply
Marcus Scherer
Community Contributor
Posts: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

Push rules vs. Enterprise rules

Post by Marcus Scherer » Sat Mar 28, 2009 10:43 am

Hello,
with Palo 2.5 what are your experiences/recommendations with push rules and (TM1 like) enterprise rules? When should push rules still be used? What are limiting factors for enterprise rules (data volume etc.)?

My application in scope will have a small data volume but intensive calculations on different levels of organizational entities.

Thanks in advance.

Marcus

User avatar
Michel Zijlema
Site Admin
Posts: 702
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Push rules vs. Enterprise rules

Post by Michel Zijlema » Mon Mar 30, 2009 7:22 am

Marcus Scherer wrote: with Palo 2.5 what are your experiences/recommendations with push rules and (TM1 like) enterprise rules? When should push rules still be used? What are limiting factors for enterprise rules (data volume etc.)?

My application in scope will have a small data volume but intensive calculations on different levels of organizational entities.
Hi Marcus,

"Push rules" (which is IMHO just marketing terminology from the time that PALO didn't provide server-side "enterprise" rules) are in fact calulation and loading routines, which will only work on base level (N:) cells (you could calculate on a consolidated level, but the result will be splashed to base level).
So for calculation on C: level you need enterprise rules. Also for dynamic modeling ("real-time what-if") you need the enterprise rules - although you could use Supervison Server (commercial component) to set cell-change triggers on cube areas and have the calculation done at cell change.
In my experience the entreprise rules work well on small data volumes, even when there is a lot of rules/calculations. Make sure you use markers (the PALO equivalent of TM1 Skipcheck&Feeders) as these can influence calculation time significantly (I've seen calculation last for over 20 minutes without markers, but within a second with markers).


Michel

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: Push rules vs. Enterprise rules

Post by John Hobson » Fri Apr 03, 2009 7:32 am

As Michel says, Push rules are what products that don't have "proper" rules use as a workaround.

Having said that I do have a forecasting app that I built in TM1 (and which I am porting to Palo) that only ever uses push rules.

It only forecasts at the N level (another of Michel's salient points) and it has some statistical calculation which is simple to write in an Excel formaulae but which I wouldn't want to attempt in TM1 or Palo. Possible - just no fun to be had there.

The real reason why this works in this particular instance is that the UI is a complex set of data with varying dimensionality that needs a spreadsheet with multiple cube references in contiguous areas to lay it out effectively for the user. Hence we are de facto in Excel land anyway so might as well make use of the functionality.

The combination of Excel formulae and palo.setdata works well in this instance, but it is a VERY specific example. In most cases I would regard push rules as a poor substitute for server based rules.

In my experience of Palo, which is mostly limited to the intensive development of a relatively small planning model (200 product groups X 156 weeks x 4 versions x 30 measures x 3 cost types x 8 data types) rules work very effectively and the editor is pretty smart once you get used to it. I have successfully ported this mode from TM1 where the rules covered over 1,000 lines in the .xru sheet!

No elisanc yet though :? (but the presence of Undo and Undo Spread makes me forgive them a lot :D )
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

Post Reply