What is new in version 5.0



Wise Analyzer 5.0 comes with 20 + reports/analysis, some old and some new. Furthermore, many previous reports/analysis have been upgraded and enhanced.
Here are some of the changes described.

Improved G/L Analysis - Enhanced

In the G/L Analysis you can now view your Income statement month by month, see the trend graphically and double click on any value to see all the entries in that month.


KPI's and Excel export has also been enhanced and in the filtering for Departments and Project we have added the <empty> filter and a clear button.

hint: to deselect the budget selection, press Ctrl-delete when the focus is on the Budget drop-down editor.

Drill down window - Enhanced

Each drill down window (the window that opens when you double click on a cell in Wise Analyzer) now remembers how you left it last.  So all changes in summaries, filtering, column order and column visibility is kept.

Aged Accounts Receivable and Payable - Enhanced

Here you can now select the "Aged as of date" and analyze all your receivables and payable in dynamic buckets and by Currency code, Payment terms code etc.

G/L Dimension Analysis - New

In Microsoft Dynamics NAV, a dimension is data that you can add to an entry as a kind of marker. This data is used to group entries with similar characteristics, such as customers, regions, products, and salesperson, and easily retrieve these groups for analysis.
A two-dimensional analysis, for example, would be sales per area. However, by using more than two dimensions when creating an entry, you can carry out a more complex analysis, such as sales per sales campaign per customer group per area.
The new G/L Dimension Analysis allows you to do just that, based on the dimensions you have already set up in your Dynamics NAV.

SQL Query Builder (enterprise only) - Enhanced

Now you can choose any SQL Database to create queries from and you can use parameters in the query for your users to further narrow the result set coming from the SQL server.  The NAV intelligence has also been updated to translate options fields correctly to its text equivalent. 




Dashboards

New dashboards and a Dashboard Editor (enterprise only) has been added

Comments

Post a Comment

Popular posts from this blog

Wise Analyzer - How to import Queries, and a free gift!

Image
Wise Analyzer - how to import Queries from another source Even if you don't have the Enterprise version where you can create your own queries to extract data, you can still import queries from other sources, like your NAV partner or from Wi se . Here is a free gift to all our Wise Analyzer users - a Permission Overview report that works with Dynamics NAV 2013 and up and gives you a complete overview of all the permissions for all your NAV users.  Save this file into a folder on your computer and extract it before you continue to read this blog. When you want to import a Query you open "Manage Custom Queries" from the Main menu. Next you click Import Select the Permissions.CQDef file that you saved already. Then you click Save and Close Then the Query should appear under Management in the "Database Views" side bar. If you open Permissions you can see user permissions for all user í Dynamics NAV. If your double click any non-
Read more

Install Guide and technical info for sysadmins

Image
Install latest version of Wise Analyzer You can install Wise Analyzer in two ways, either directly under your user profile using Microsoft ClickOnce technology, or under the "Program Files" folder using ordinary .msi file.  The latter is almost only used when installing Wise Analyzer on a Windows Terminal Server or Citrix environment. If you use the ClickOnce setup, the system will automatically inform you when new versions are available and allow you to upgrade instantly.  Click  here for ClickOnce setup Click here for msi setup When the system starts it will show you a login screen, there you need to type in the SQL Server name and then select the Dynamics NAV database and select the Company you want to connect to. If you connect to a Cronus company (Demo database from Microsoft) you can explore the whole system apart from the Dashboard designer and the Query builder. If you connect to your own company a license window appears and there you just ap
Read more