I have a user request to run a Jet Report if possible that would identify shortcut and global dimensions that exist in a given table. Not sure one can run a report on all tables without breaking Jet (and probably Excel too). All I need to do is find out which tables shortcut dimensions appear in. Still pretty new to Jet.
Is this at all possible using Jet?
Thanks!
Perhaps NAV's Default Dimension table would help.
Not sure I understand what you mean. We have set up some shortcut dimensions are are trying to figure out which tables they hit?
In Jet Developer is there a “where used” lookup or Jfx statement that we can use to define all Dimension Set ID sources.
Sorry if I'm being obtuse. Not a programmer, never was.
-d.
The Default Dimension table in NAV contains a Table ID field which lists each table in which the dimensions appear:
So, in the above example, you can see that there are certain dimensions that appear in the Salesperson/Purchaser table (#13) and the Customer table (#18)
Thank you! Not quite what they wanted, but was the correct answer. <g>