We already classified our model manager formulas based on this logic. For example credit rate is a formula which for us is universal across all templates so we define it as a formula within the model manager.
1 Like
I believe the only calculation in our model manager is in our Variance element to reverse the variance based on revenue or expense.
We use both types but I would say I definitely have more calculations in the templates
I was using procedural calculations in Model Manager and had to change everything to template calculations because the procedural calculations did not work correctly for my standard users with limited security access. Template calculations are working much better for my end users.
1 Like
As our models are very calculation heavy, we have used both types. In addition, we have moved a lot of calculations to the sql side, so the Prophix models can be more efficient.
I use both types within my reports and templates, I would say that we use an equal amount of both.
Like the comparison when to use calculated account or version vs. a template calculation. Really lays it out nicely.
We use both calculations in our reports. We find model manager formula does impact performance negatively specially there is MDX in formula.
Very interesting topic. We are currently trying to figure out if we need to do a template calculation or an MDX formula.
That makes sense. We primarily use template cals for this reason.
We use a mixture of both!
very useful- we use template calc in our FC workflow
Very helpful! Really helped me understand when best to use each…
We use calculations in both scenarios. They were already setup when I came into this position, but looking forward to creating my own in the future.
I’m glad to get the guidance on which approach works best in which scenarios. Thanks!
We use a mixture of both for various things
We use both types but more calculations in the templates.
Thanks for the information
We use both, but now I am thinking I should review how some items are set up.
We use both. but i do believe a periodic review is necessary.