During one of our International Diver Developer meetings recently, my colleague Hannes Hellsborn shared this simple yet effective solution for that niggly issue when you try to calculate a true average at any data level above the lowest transaction level, or row level in the data. Hannes works for Infotool Sweden (another Diver Distributor and Member of the Diver BI Group). I’m sure you will find this as useful as we did.More
Welcome to our "Ask Anthony" pages. You can submit your queries on all technical and administrative aspects of the Diver Solution though our contact form below. If your query has general relevance Anthony will publish his step-by-step guidelines so that other Diver Users can search for these FAQs.
If your query is specific to your organisation it will go through our normal support desk and we will deal with it in our normal manner.
Have a look at some of the queries already solved.
Anthony Wright is one of Diver BI Group's key experts.
He has been developing Diver applications for multi-site customers applying expertise in the techniques of data collection across networks and the transformation of data from disparate sources into a generic format. He works with clients in Ireland, the UK and Europe.
In all my 9 years of working with Diver products, as a developer, support technician and trainer, the one area of functionality that I notice users seem to confuse themselves over the most is the set of features in ProDiver that allow you to Focus, Group or Find particular subsets of data. More
Whenever you set about creating a new Diveport or even just a new environment in an existing Diveport, you should take a few moments to set up some macros relating to the colours and fonts you are going to use. This brief but important job will same you lots of time in the long run – especially if you ever want to make changes to colours and fonts across just one environment.More
In this post I am simply going to share some links with you to take you to some really useful blog posts written by Dimensional Insight’s in-house designer, Rose Weinberger. Over the next few months she will share various dashboard design tips, which, together will become a design “Look Book”.More
It’s that time of year again – when you have a lead up to an event or festival like Christmas or Easter. You want to compare your sales performance (or manufacturing, production or any other KPIs) against the same period last year.More
In Part 2 my colleague YY Tsang from DMBI explains his ideas on extracting and incorporating non-tabular web data.
In Part 1 my colleague Paul Duggan at Dynamic Business Informatics has shared his ideas on how to interface with Sharepoint and incorporate some useful tabular web data into a Diveport embedded within Sharepoint.More
My colleague Paul Duggan at Dynamic Business Informatics shares his ideas on how to interface with Sharepoint and incorporate some useful tabular web data into a Diveport embedded within Sharepoint. In Part 2 we will be looking at ideas on extracting and incorporating non-tabular web data – coming this time from my colleague YY Tsang from DMBI.More
One of my counterparts working at Dimensional Insight in the US, Rose Weinberger, wrote a really useful blog that takes you through the main chart types and provides tips on how they should be used. It’s a very good starting point for anyone embarking on creating a BI portal or dashboard, and one to come back to when you’re struggling to find just the right chart to display your particular information. More
Another Tip from my colleague Debbie Lonsdale – this one is for those of you creating Dashboards and Scorecard in Diveport. How to set up an HTML Portlet in Diveport that allows you to add images that change corresponding to the data Quickviews in your Diver BI model.More
If you are working in Retail, Wholesale or any Supply Chain organisations, there will be times of the year that are critical to your business in terms of sales. These can be periods like Christmas, School Holidays and Easter. How to set up a Time Series in Diver that allows you to set a Start & End Date for two time periods based on Date.More
I’m going to explain how I used a Free Entry Quickview combined with one of the underused functions of the Advanced Find Feature in Prodiver, to create an interactive alert threshold. This technique can be used when your users want the ability to change the threshold to focus on particular groups of values.More
We had a case recently where a customer wanted to use their daily maximum sales value (in any dimension) as a dynamically changing target that could also be controlled interactively to reduce that maximum to a more achievable level.
My colleague Debbie Lonsdale constructed a Dashboard for them to manage the target based on the daily maximum sales, but which they could control with a List Quickview to explore some “what-if” targets in place of a budget file. This technique could equally be used on Minimums and for other dimensions or summaries.More