How do I extract all dimension codes (2 Global and 2 Shortcut dimensions) created in BC whether or not they've been used? I am very new to using Jet Reports. Tried NL function on Dimension table but not getting a list. Thanks
Date
Votes
2 comments
-
Bryan Robinson The Dimension table has all of the dimension names but not the values. Does that make sense? Let's say you have 3 dimensions, Department, Region, and Project. The Dimension table would only have three records providing the name, captions, code, etc for those three dimensions.
If you need the values associated with those dimensions such as Departments of Admin, Marketing, Sales, etc., then you should be using the Dimension Value table to find the Codes.
Blocked Code Consolidation Code Dimension Code Dimension Value ID Dimension Value Type Global Dimension No. Indentation Map-to IC Dimension Code Map-to IC Dimension Value Code Name Totaling FALSE ADM DEPARTMENT 20 Standard 0 0 Administration FALSE EXEC DEPARTMENT 21 Standard 0 0 Executive FALSE MKGT DEPARTMENT 22 Standard 0 0 Marketing FALSE OPERATIONS DEPARTMENT 23 Standard 0 0 Operations FALSE SALES DEPARTMENT 24 Standard 0 0 Sales Total 0 -
Kapil Kaushik Thanks Bryan, much appreciated. I still need to get my head around that. Will keep you posted if I hit a hurdle.
Please sign in to leave a comment.