0

Analysis by Dimension

Jet Reports Historic Posts

August 03, 2011 08:16

None

Follow

I am new to Jet reports. I just like to know. does any one know How can I make a report which is the same as the Analysis by Dimension Report. Having The Gl Accounts as lines and Dimensions as Columns. Thanks.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 03, 2011 14:37

  Hi,
  
  Have you tried looking in the "Shared Jet Reports" section of this community site? There are many example reports people have uploaded there. You may not find exactly what you are looking for, but you may be able to find something similar. I'm guessing you just want to use NL(Rows) with the G/L Account table to generate rows and NL(Columns) on the Dimension Value table to get the values for a particular dimension. Then you could use the GL function at the intersection of the rows and columns functions to get the balance, budget, net change, etc.
  
  Regards,
  Hughes

• 0
  
  Malcolm Clarke May 30, 2019 13:50

  Hi Hughes,

  Where is the Shared Jet Reports' section? I too am looking to creating a TB by Dimension 1 - 3, so 2 globals and one shortcut. We are using NAV 2018. I have created the Analysis View, but my report is not working well.

  What we want is to display the Account No, Name and then shortcut dimension 3 in separate columns across the report, but the amount for each dimension. If Dimension 3 is Cost Center, and we have CC-1, CC-2, CC-3 etc, then that should be in the column as a header, and under each one the amount for that GL account linked to that dimension.

  Thanks

  Malcolm 

• 0
  
  Harry Lewis May 30, 2019 15:03

  Hello Malcolm -

  This Community area has undergone some substantial changes (and simplifications) in the 8 years since Hughes wrote that response.  As a result, everything related to Jet Reports is in a single area ("Jet Reports").

  Is something like this what you are talking about?

  I have an Analysis View configured to use my two Global Dimensions (BUSINESSGROUP and CUSTOMERGROUP) and one of my Advanced (or "shortcut") dimensions (DEPARTMENT):

  

   

  I could then create my report as Hughes described.

  I would have an NL(Rows) to list my G/L account number and name - along with an NL(Columns) function to list out the potential values for my Advanced Dimension:

  

   

  Then, in the cell were my NL(Rows) and NL(Columns) functions cross, I would add my GL function that references my analysis view:

  

   

  When I run my report, I'll have the accounts, the possible values from my Advanced Dimension, and my G/L balance: