Wise Analyzer - How to import Queries, and a free gift!
Wise Analyzer - how to import Queries from another sourceEven 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 Wise.
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 your double click any non-blank cell the drill down window opens and you can see all the rights this role gives. If you double click a cell in the Grand Total column you will see all the rights given to that user from all the roles he/she belongs to.
Or you can add more data fields to the Pivot table to analyse or filter on.