Hi,
Does anyone know if using a longhand instead of shorthand has any effect on performance?
In other words, does writing ['Dimension':'Element'] perform worse than writing ['Element'] in a rule?
Shorthand vs Longhand impact on performance?
- Harvey
- Community Contributor
- Posts: 236
- Joined: Mon Aug 04, 2008 4:43 am
- OLAP Product: PA, TM1, CX, Palo
- Version: TM1 8.3 onwards
- Excel Version: 2003 onwards
- Contact:
Re: Shorthand vs Longhand impact on performance?
Rules are supposedly compiled, so in theory it should make no difference. TM1 is a quirky beast, though, so if you have some evidence it might, I'd be interested to hear it.
Take your TM1 experience to the next level - TM1Innovators.net
-
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Shorthand vs Longhand impact on performance?
Normally when talking about "shorthand" vs "longhand" rules is taken to mean ['Element'] vs DB('cube',!dim1,!dim2,...'Element') on the right hand side of the rule. There is some evidence that the square bracket shorthand actually performs a little better than full DB reference. I haven't ever tested this myself but there are people who have and this is what they claimed to observe. For dimension qualified vs unqualified shorthand I would tend to suspect that qualifying the element reference with the correct dimension might be faster since you are saving TM1 the effort of evaluating which dimension the element comes from. I certainly wouldn't expect it to perform worse.Bakkone wrote:Hi,
Does anyone know if using a longhand instead of shorthand has any effect on performance?
In other words, does writing ['Dimension':'Element'] perform worse than writing ['Element'] in a rule?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Shorthand vs Longhand impact on performance?
The evaluation of which dimension it is from is done at compile time - as you will see if you use an ambiguous name. There is no effect on runtime performance.
-
- Posts: 119
- Joined: Mon Oct 27, 2014 10:50 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Shorthand vs Longhand impact on performance?
Thanks for your reply. Im new at this so haven't really figured out the lingo yet. Ill call it "midhand" from now on.lotsaram wrote: Normally when talking about "shorthand" vs "longhand" rules is taken to mean ['Element'] vs DB('cube',!dim1,!dim2,...'Element') on the right hand side of the rule.
Glad to hear it shouldnt have any impact on performance.