Shortcut Dimension performance issue

Discussion & Feedback for Jet Enterprise
enigma1962
Posts: 3
Joined: Wed Nov 16, 2016 2:28 am

Shortcut Dimension performance issue

Postby enigma1962 » Wed Nov 16, 2016 2:52 am

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

enigma1962
Posts: 3
Joined: Wed Nov 16, 2016 2:28 am

Re: Shortcut Dimension performance issue

Postby enigma1962 » Thu Dec 01, 2016 1:35 am

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

Thanks
regards
Nigel

kbpatel
Posts: 1
Joined: Thu Sep 25, 2014 4:03 pm

Re: Shortcut Dimension performance issue

Postby kbpatel » Fri Dec 02, 2016 1:03 am

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.


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 1 guest