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
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.
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
Another great step-by-step guide – this time submitted by Amanda O’Connor from Formell, one of our manufacturing resellers. She demonstrates how to set up alerts on exceptions in Diver. As she has already posted in the Formell blog, all I have to do this time is post the link to her article. Thanks Amanda! Just […]
Here is another great tip that was submitted by my colleague Edwin Commandeur from Dimensional Insight in the Netherlands, in response to a query from one of his customers. Thanks Edwin – it’s great to build up a library of techniques like this one! Edwin’s customer wanted to know how many products had exceeded a […]
My colleague Debbie Lonsdale created this video to show you how to create parameterised Quickviews for Diver Time Series Periods and Summary Values – this helps you to save screen space before publishing to Diveport, by vastly reducing the number of columns you need in a report. Note that if you want to add in […]
It’s easy in Diver to compare values by all members of a Dimension to the “Parent” or Total value for that Dimension. But what if your users are able to see only their data, how can you give them a report that compares their performance against the whole peer group? Or a sales manager wants […]
This is something we get asked a lot – how do I find the Top 10 Products, Customers, Suppliers by revenue or volume so that whenever I open the report, they change automatically when new data refreshes the model? This tip works whatever Dimensions and Summary Values you are working with. The usual mistake people […]
You might have already mastered how to distinguish between a “Focus” and a “Find” to get a dynamic Top 10. See my Tip on this if you have not already understood the first step. But what if you want to find the top 10 of any dimension within a higher level category? Like Top 10 […]