Dynamics NAV Financials

account schedules, financial reporting, dimensions, budgets and all the rest of the fun, fun world of Microsoft Dynamics NAV from a (former) Controller who still uses the software every day

  • Account Schedule Examples
  • Account Schedule Formulas
  • Popular Series
  • Services
  • About

Expand your use of dimensions in NAV account schedules by using analysis views

Posted: October 2, 2012 | Author: kpeters | Filed under: Uncategorized | Tags: Account Schedules, analysis views, budgets, Classic Client, codeunit 410, column layout, date compression, dimensions, Dynamics, Microsoft, NAV, row setup, RTC, update | Leave a comment

If I had to pick only three basic elements to Microsoft Dynamics NAV account schedules, I’d have to choose row setups, column layouts and analysis views. Of course, row setups give you access to basic general ledger accounts and column layouts give you options on how to show that data in different time periods. So what do analysis views do for us? Analysis views give us the ability to reach into our dimensions, past the two globals, and into the list of shortcuts, allowing us to combine any four dimensions we want at a time in any account schedule.

For illustration, I’m showing you an account schedule from NAV2009 Classic, which shows the dimension filters on an account schedule where no analysis view has been applied. The two global dimensions for CRONUS USA (Department and Project) are available to be selected on the dimensions filter tab and the remaining options are greyed out, unable to be used.

By selecting a different analysis view  on the account schedule name page, you will have expanded options. Perhaps you’d like to apply an entirely different set of dimensions filters to your account schedule or limit the dimensions filters to only two of your shortcut dimensions.  Any combination of four dimensions is available to you through analysis views.

There are a few things you need to know about analysis views before you start using them:

You can add a default analysis view to any account schedule. If you always want a certain account schedule to filter on a selected group of dimensions, this is the best way to do this.

Analysis Views must be updated. You can do this at any frequency you wish. Some companies choose to update once a month, some companies update once a day. Be aware that the process of updating pulls in any transactions that have been posted since the last update to your analysis view. This means if you post some entries during your close process, you’ll need to update your analysis view in order to show the change on your account schedule.

Updating can be done manually or it can be automated.  To manually update analysis views, just hit the update button.  You’ll need to do each one separately.  Alternatively, you can choose to schedule codeunit 410 Update Analysis View as a regularly scheduled maintenance item in order to automate this process.

When you set up an analysis view for the first time, it can take a long time to update. Depending on the size of your database, if you don’t limit how far back your update goes, it could take a long time to update initially. Be careful by trying this out in a test system first. This process, which will normally take seconds when run daily, will take many hours if you don’t limit it and will cause table locks for other users.

If you test out an update and are afraid it will take up too much processing time, you have a couple of options.  First, you can limit the start date of your update.  One reason you might need a new analysis view is because you’ve added a new dimension.  In this case, you really don’t need to go back to the beginning of time on your update. Choose the date you started gathering data on your new dimension as your starting date. You can also choose date compression. By compressing your data by day, week, month, quarter, period, or year, you limit how much detail you can see when you drill down. If you use this option, you’ll need to remember that this is a compressed view if you change column layouts to different time frame than your compression setting. Choosing date compression of none will allow you to drill down to full transactional detail.

Avoid using the update on posting button. This option updates your analysis view every time you post something to your system. Every sales order, every sales tax entry, every cash receipt, etc. will update real time. I’ve seen one small company use this option and it brought their system performance to a crawl.

Remember to include your budgets. If you make any changes to your budgets, you need to update that information on your analysis views as well.


TwitterYouTubeFacebookGoogleLinkedInEmailRSS
MVP_Logo_Preferred_Cyan300_RGB_72ppi
All Stars_NAVUG(1)
400dpiLogo

Blog Stats

  • 604,407 visits

Enter your email address to follow this blog and receive notifications of new posts.

Join 475 other followers

Top Posts & Pages

  • Account Schedule Formulas
  • Account Schedule Examples
  • 12 month Trend Balance
  • Current Month Balance vs. Same Month Prior Year Balance
  • Maximize your Microsoft Dynamics NAV 2009 Classic screen space with user level configuration options
  • Current Month vs. Same Month Prior Year Net Change
  • Social media at Microsoft Convergence 2013 from the official blogger viewpoint
  • Aging methods in NAV - which buckets are you looking for?
  • NAV Account Schedules 101
  • Use payment tolerance for small balance write-offs [Nav 50 Tips Series]
My Tweets

Account Schedules accounts payable accounts receivable aging analysis by dimensions Analysis Reports analysis views balance at date BREP budgets chart of accounts Classic Client code mandatory column layout community comparison date formula comparison period formula consolidation Convergence CustomerSource dimensions document date dual monitors due date Dynamics ERP Excel export to excel financial reporting financial statement fiscal year general ledger global glued column increase header item ledger entries JET journal entry keyboard shortcut learning Management Reporter manuals Microsoft NAV NAV 2013 NAVUG NAVUG Academy net change networking Office2013 paperless payment terms pivot table posting accounts PowerPivot productivity query tool reconciliation account reporting tool ROI row setup RTC set base for percent setup options shortcut show opposite sign SSRS tips and tricks totaling type training trial balance user group user level configuration user poll video

Blogroll

  • Microsoft Dynamics NAV Team Blog
  • Microsoft Connect
  • Microsoft Dynamics CustomerSource
  • I Love NAV
  • Microsoft Dynamics Community
  • NAVUG

Archives

  • December 2020
  • September 2020
  • November 2019
  • October 2019
  • August 2019
  • May 2019
  • March 2019
  • April 2018
  • December 2017
  • October 2017
  • April 2017
  • March 2016
  • December 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • March 2015
  • January 2015
  • December 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
Blog at WordPress.com. Mid Mo Design.
  • Follow Following
    • Dynamics NAV Financials
    • Join 475 other followers
    • Already have a WordPress.com account? Log in now.
    • Dynamics NAV Financials
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...