Hi,
[Navision]
I am trying to generate a P&L with all dimensions (Global & non-global) in columnar format, I am fine with Global Dimension but not this non-global / Advance dimension.
May I know is there any sample report available for non-global / Advance dimension?
Thank you.
Regards,
Ming Ming
Date
Votes
7 comments
-
Jet Reports Historic Posts Hi
You need to create analysis views in the Navision to access the dimensions other than the global dimensions.
Once you create viewes there u can access the same from GL function in analysis codes -
Jet Reports Historic Posts When using Jet, you should not need to use an Analysis View to see advanced dimensions on G/L entries. The dimensions will appear as available fields to display on the report. You will just need to select the dimension codes that you want to see and add them as a column.
As dimensions are different in virtually every company, a sample report may not help in this case. If you use an NL ("First"), (or NF function if you are using a row cache) you should be able to select the dimensions you want to see in each row. -
Jet Reports Historic Posts Hello User Jill
Are you sure , you can get all short cut dimensions other that two global dimensions in gl function as available fields ?
I can't get to see , in the first place in gl function only gd1 and gd2 are shown , unless view is selected can't get to see other dimensions.
Even in NL sum function , I can't see other shortcut dimensions
Could you please send me the sample file with gl or nl function where you could see the advanced dimensions, never mind there dimension values will be different for each company at least get to see the formulas
Warm regards
Ravi -
Jet Reports Historic Posts Yes, I regularly build reports using GL Entries that show shortcut dimensions without using Analysis Views. The formula will just list the field name as the dimension code name. For example, if you build a report using Cronus, you will see that they have multiple shortcut dimensions: CustomerGroup, Area, BusinessGroup, and Salescampaign.
I have uploaded a screenshot that shows the field selection for these dimensions in Jet in an NL Function. I have used this for reporting on NAV databases for Version 5 to current. -
Jet Reports Historic Posts Hello
You are only getting field here , how do you get balance Etc filtered by the shortcut dimension ?
Example of we need to get GL balances in columns by shortcut dimension wise?
In your screen you are selecting nl field , what we need is either GL balance or nl sum filtered by shortcut dimension
Please suggest how it could be achieved.
Warm regards
Ravi -
Jet Reports Historic Posts Hi Ravi,
The same list of fields can be selected as filters. So, for example, here is an example of a filter in an NL (Row) function. All of the dimensions are available as filters. -
Jet Reports Historic Posts Yes agreed seems possible this way but bit more complicated than using the GL function , but for GL to use analysis view is a disadvantage , you need to update analysis view in navision otherwise you won't get updated values, in this sense using the NL sum is better.
Please sign in to leave a comment.