Hi,
Is it possible to build a Key on the Item Ledger Entry Table including a Dimension which is not a Global Dimension?
eg. =nl("Sum","Item Ledger Entry","Sales Amount (Actual)","Item Category Code","*","Location Code","AA","Posting Date","01/09/2013..30/09/2013","Item No.","*","Entry Type","Sale","Company","ZZ","Territory","110")
Where Company is Global Dimension 1 Code and Territory is a Dimension but not a Global Dimension.
I hope I have explained this correctly.
Regards
Phil
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Phil,
Yes it should be possible to do this. In newer versions of Jet Essentials, you should actually see advanced dimensions in the list of fields for a table in the Jet Browser, and you should be able to filter on them just like you describe. The field name would be the dimension code and the caption would be the dimension name (as they appear in the Dimension table). Is this not working for you? If you are using an older version of Jet, you will only be able to use the dimension code and they will not be visible in the Jet Browser. Can you check the dimension table and be sure that you have the dimension code or name correct? If you are on an older version of Jet, try using the dimension code.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I am using Jet Essentials 2011 11.1.12053.0 (32-bit).
I am also running Nav Version 6.0 R2, Bank2.20 (6.00.32012).
I can certainly filter on all Dimensions in my Jet Reports but filtering on the non Global Dimensions really slows the report down.
In the Jet Tables I can only see Global Dimension 1 Code & Global Dimension 2 Code. I have four Dimensions in total set up in Navision, 2 Global and 2 non-global. I do not see the two Non-global Dimensions in the Jet Browser for the Item Ledger Entry table.
To speed my report up I was trying to create a Key on the Item Ledger Entry Table in Navision as Follows - Item Category Code, Location Code, Posting Date, Item No., Entry Type, Company, Territory.
Where Company is Global Dimension 1 and Territory is one of the non Global Dimensions, but, have not had any success.
We will down load the latest version of Jet and see where that gets us but I don't think it will solve my Key creation issue on the Item Ledger Entry Table.
Regards
Phil -
Jet Reports Historic Posts Phil,
Well, you won't be able to create a key with your advanced dimensions in it because the values don't actually exist on the table. The actual advanced dimension values exist on a variety of other tables like Default Dimension or Posted Document Dimension. Jet has to create a link from the primary table to one of these other tables in order to filter or return values from those dimensions, so this is why your report will be slower if you are filtering on one of the dimensions that's not a global dimension. I doubt you'll see much speed improvement for this in newer versions of Jet since it works basically the same for any version of Jet because that is the only way to do it. Still, upgrading won't hurt and there are some other performance improvements in newer versions, so maybe you'll see some difference.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Understood.
Thanks for your help.
Regards
Phil
Please sign in to leave a comment.