Another article by my colleague Debbie Lonsdale on some features of ProDiver that are powerful tools but can cause a little bit of confusion when you first start using them.
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. Often support queries come in that show strange results in reports where users have simply taken steps to focus where they need only have done a straightforward Dive; or where they forget that they have created a Group and new data has been added to the model that should belong in that group. Or they “focus”on a Top 10 when they should have sorted the value column down and set up a dynamic “Find First 10” – which works when quickviews are changed.
No matter how much these features are explained in training, unless you use them frequently straight after the training session, the likelihood is that you will forget which one to use and when. So I thought I would gather the relevant pages from the training manual and post them here as a quick reference reminder – and if anyone doesn’t have a copy of the ProDiver training Manual get in touch with me through the contact form and I will send you a complete copy.
Focus vs Group
Remember you only need to focus or group if you want your current Dive window to display and subtotal ONLY those rows that you have specified in the focus. You do not need to Focus or Group if you simply want to choose one row in your current Dive window row from which to dive into the next dimension.
The main difference between Focus and Group is that when using Group you can dive from the combined rows as a single entity.
The Find function allows you to search any column in the Dive Window for a string, numeric or date.
Find Before Dive
This is a really useful feature that many people forget about. It’s very handy when you have a very populous dimension as you can find the string or numeric you are looking for before you even open the Dive window. For example you could find an invoice number or a customer account before you open any window – simply right click on the dimension in the console and select the option “Find Before Dive“.
Advanced Find …Option
If you click on the options button in the Find dialogue box you will see another button – Advanced Find. Depending where your cursor was at the time you clicked it – i.e. either on the dimension column or a summary column header, you will see different default options. There are quite a number of possibilities so it pays to spend some time experimenting with what is possible – including the Boolean logic options.
Advanced Find …Paste String
I can’t say I’ve really taken advantage of this myself because I tend to do this kind of thing using named groups or by adding a field using the Visual Integrator, but for someone without developer skills this is worth taking a look at.
Advanced Find …Extended First N
This last technique was used in the very first Ask Anthony blog – to refresh your memory about it just go back to our previous post.
I hope you “find” this latest blog useful :-) Sorry for the intended pun.
About Debbie Lonsdale
Debbie Lonsdale has been working with the Diver Solution as a BI Consultant at Dynamic Business Informatics since 2008. Her previous experience includes computer programming, analytical and technical roles, team management, account management, sales and marketing in a variety of market sectors, including the Travel Industry and Distribution. She combines this experience as an all round ICT professional in the BI sector.