I was just wondering whether anyone had had any thoughts or advise on this issue.
Thanks
regards
Nigel
2 comments
-
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts 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.