0

Shortcut Dimension performance issue

Jet Reports Historic Posts

November 16, 2016 09:52

None

Follow

I was just wondering whether anyone had had any thoughts or advise on this issue.

Thanks
regards
Nigel

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts November 16, 2016 09:52

  I need to advise/help regarding a performance issue when using a shortcut dimension.
  
  I've created a batch template to be used when scheduling reports and I have a calculation in the Command line sheet to count the number of GL entries per 'Project code' (Project code is a shortcut dimension).
  
  The formula in the field is:-
  =NL("Count","G/L Entry",,"Project Code","@@"&$C8)
  
  The Project code in column C is based on an NL rows from the Dimension Value table.
  
  This runs at over 2 hours at which point I cancel it.
  
  If I change the formula to count on a global dimension (i.e. cost in our instance) it runs in @ 30 secs.
  
  i.e. change the formula to:
  =NL("Count","G/L Entry",,"Cost Code","@@"&$B8)
  
  I've been told that the huge performance difference is down to using a shortcut dimension.
  
  If anyone has any thoughts on how to improve the performance when using the shortcut dimension I'd be very grateful.
  
  Thanks

• 0
  
  Jet Reports Historic Posts December 02, 2016 08:03

  Nigel,
  
  Have you specified which Key to use in the NL function?
  
  The defualt key for the "G/L Entry" table is "Entry No.".
  
  You should specify the key to be something like "G/L Account No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date"
  
  Hope the aboe helps.