Home

User Manual - MasterMine Software

1. per B D E F G Account Exec 3 Souce2 n v E WIE F4 Ststus x ARET 5 Contact Type Owner 8 Linked Contact BivotTable lit i 9 Probabilit _ 21 10 Short Reference 11 Activity Code 15 OnWeek jm vl gt 19 OnYea CARecords Potential Units Potential Sales Vol Probability Probable Units Prob 20 1999 Mar 1 1 00 1 190 00 0 10 0 10 21 Apr 2 1 00 0 00 0 35 0 25 May 59 66 00 77 520 00 8 35 9 05 Jun 33 32 00 46 729 08 5 65 5 55 24 Jul 51 49 00 90 125 00 6 05 5 85 25 Aug 13 12 00 7 945 00 1 95 1 85 26 Sep 14 18 00 24 210 00 2 40 2 80 Oct 7 10 00 10 340 00 1 50 3 00 28 Nov 2 2 00 0 00 0 20 0 20 Dec 3 31 00 12 090 00 0 60 7 60 30 2000 Jan 2 2 00 3 680 00 0 20 0 20 31 Feb 3 3 00 2 590 00 0 35 0 35 32 Mar 2 2 00 5 180 00 0 20 0 20 33 Ma 1 1 00 0 00 0 00 0 00 34 Grand Total 193 230 00 281 599 08 27 90 37 00 Original 1 1 4 o Z A Ready m What the Report Says 12 The report currently shows pending sales broken out by year and month in the following columns e CAREecotds the count of pending sale records in the Calendar or CA table e Potential Units a sum of all units for pending sales e Potential Sales Vol a sum of all projec
2. Opportunity Manager Sub Tables OM Opportunities Main table OD Details OK Tasks Team Members OP Competitors Issues OC Influencers OM Opp Record Type Rtrim OM RECTYPE OM RECTYPE OM Stage Rtrim OM STAGE OM STAGE OM Manager Rtrim OM USERID OM USERID OM Opp Flags Rtrim OM FLAGS OM FLAGS OM Opp Company Rtrim OM COMPANY OM COMPANY LEFT rtrim OM CONTACT abs charindex OZ OM RECTYPE iif let OM RECTYPE 2 OZ OM Opp Contact 1 len rtrim OM CONTACT OM CONTACT left rtrim OM CONTACT charindex OZ OM RECTYPE len rtrim OM CONTACT iif let OM RECTYPE 2 OZ OM Reason Win Loss OM CONTACT OM Opportunit Rtrim OM NAME OM NAME OM Opp Status Rtrim OM STATUS OM STATUS OM Opp Code Rtrim OM CYCLE OM CYCLE OM Opp Source Rtrim OM SOURCE OM SOURCE OM 1 Rtrim OM F1 OM F1 OM F2 Rtrim OM F2 OM F2 OM F3 Rtrim OM F3 OM F3 iif OM StartDate is null NullDate OM Opp StartDate Coalesce OM StartDate NullDate OM StartDate iif OM ClosedDate is null NullDate OM Opp CloseDate Coalesce OM ClosedDate NullDate OM ClosedDate iif OM CloseBy is null NullDate OM Opp CloseBy Coalesce OM CloseBy NullDate OM CloseBy Datediff day Coalesce OM StartDate Nul date iif OM StartDate is null OM Age IDate getdate NullDate OM StartDate Datediff day Coalesce OM StartDate Nul iif OM ClosedDate is null NullDate StartDateTo Actual IDate OM Close
3. 77 78 a 61 Toolkits 220 49 133 135 144 TANN 14 19 124 Troubleshooting eee 133 Uncheck default fields 54 fidos qaqa ico 79 WING LOW Doe u waqashasqa aqu 83 Uninstalling 32 Upgrades User Manual z ioni 87 User defined Fields 144 User defined Template sss 62 WebSite ait ceci eii ee xi Week Grouping eene 77 Woerkbook 2 ere eed 61
4. 46 DESIGNNEW heben eq aieo ere Eb hi aream decem a m aer eed 47 Na ak lu 47 USE TEMPEATE cen iare ben n Io ee EID eR arm eoo em am aer eid 48 Template Finder au ua eno eram uet uu S uha 48 yn cmE 49 SELECT FIELDS TO INCLUDE 4 3 rea eite rte EE t erre a Sasa terere th Pesto aha teet tote toe aee een 50 FIBED SEDECTION aaa s 51 Howto find the fields you want to include ne e em den n te reete rg eter 51 Why limit fields donclude 2 epe tbe eet piede t ia er huhu tee n pes 52 Trial Queri ss ene uma au man ema 52 The Field List Short Menwu i Rte teda adeat sS TR eie 53 Tueld Eist Conitols i am iie a a eade e 53 Choose Report NaMe orriez ses dee ehh rie ee cte e ere er qtue teres sia a e ua ayay 54 Save TO ssa xoa eade ee eB hee sS au heh as ON eid e ds 54 LIMITING RECORD SELECTION OR FILTERING 55 History First Date filter iie ye ati e ege e epus ca tae epe e Regiae Ce RE a sU 55 Additional filtering CYilerid Li adepta tapete etate tege dee
5. fields set to show items many fields the Paee area of pivot table can be visually confusing and cluttered This option quickly moves all unused Page fields to the Pivot Table field list These fields can be easily retrieved by dragging and dropping back into the report from the PivotTable field list 4 Show Page Fields With Hidden Items Shows a list of Page fields that contain hidden items Page fields containing hidden items may prevent records containing those items from showing in the display below This is determined by whether the table option to Subtotal Hidden Page Items it turned on or off Z Hide Row Field Subtotals Hides subtotals for all fields in the Row of the pivot table This option is used if many fields have been pulled into the report to create a line listing type report In this case subtotalling by every field unnecessarily complicates the report ah ay Sort Field Items Sorts items in the selected field in ascending alphabetical order by contents of the field ra Xx Delete Worksheets named Sheet Deletes drill down sheets still generically named This helps clean up a report where many drilldowns have been performed worksheets named Log MM DD YYYY Deletes logsheets created by MMUpdater During intensive updating a user may create many Log sheets that are not needed once the job is complete Other Toolbar Buttons E
6. M 22 krowledge i eripe eene 14 MEMO vocet om amu 22 50 58 22 76 ROW At6a3o unge tet HE 64 177 Sales Manager s Toolkit 49 Save Data with Table Layout 108 Save report without data 71 87 Save SQL password 27 41 71 85 86 87 Schedule printing sss 71 88 Search eere k usu ads 104 Search Field Content cece 75 SeCUfIby rininis is 23 27 69 86 select criteria aaa qas 141 Selecting Fields su naga anaqyasqa 123 Selecting Reports sss 50 144 Set p inen 24 Share Report senesine 70 SHOrtRef aguan aq uw upaqas 38 Show GoldMine Database names 54 Show Pages iecit tititintoses tonio 134 SHOW Stats Pe 74 SNAPS NOt yp a gasas aan n 88 aaa qaa qas 71 Sort COlUMNS 80 Sort Fields teretes 53 Sort fields for drilldown 53 Sort unselected fields sss 54 SOND a a a RD 99 SOLD expressions siinne 125 SQL Installation err 26 SOL Query 57 Subtotal Hidden Page Items 107 Subtotal essere 76 Summarize numeric 96 SUDDOTL o 15 17 18 19 System Requirements sse 22 Template 5 rtr tentent 62
7. eene nennen entente nennen enne nennen 145 Activity Analysis Toolkit tet rete tvi rea Yee EEE o ee une de haa ra He 147 Sales Manager Toolkit SMToolkit xls eerte Rite Wades es EVER Ven dee S Re Venice RE DU tn ea do te Pena 148 Sales Manager Toolkit SMToolkit xls e eee etate peste EE Van Te Ane ERR ee YN eu re uere 148 Opportunities Toolkit MMOpportunities xls and MMOpportunities Unlinked xls eene 150 Projects Toolkit MMProjects xls and MMProjectsUnlinked xls eese eene eene 152 Workbooks by GoldMine Table Name MMStandard xls eese eese 153 QuoteWerks Toolkit MM 1 nns 154 APPENDIX D COMMON FIELDS AND EXPRESSIONS 155 APPENDIX BA NOTE ON NOTES cete deer eoe eee ete de re dee 169 APPENDIX Fe SPECIAL FIELDS l L Sq een eee ERR reme aset Soa ede us E u 171 APPENDIX G OTHER FIELD CONTENTS AND CONVENTIONS 173 APPENDIX H PIVOT TABLE EIMITATIONS eet eee SSS ederet orte e Ile e ee eite eee teer Pede n venous teet 175 MIN DEU
8. in the Pivot Table Field List after this function creates it Age from today Returns a field called FieldNameAge which contains the number of days between the selected Source Date field CreateOn date and today the date on which the E Set 3112012 report is run This allows for easy 30 60 90 analysis by grouping see next New Field Name CtesteonFiscal section the numerically formatted field OK Cancel Text as date Returns a true date version of a field that is stored as normal text in the GoldMine database This function applies necessary expressions to convert the text if possible into a true date field for reporting and particularly grouping purposes Start by adding the text date field to the query at report Create time or by using Add Field to include it Drag the field into the row area of the report then click Text as date to create a new date version of the field Numeric Field Functions Ribbon Group Numeric functions make it easier to group sort and create numerical fields complete with calculations and sums 77 LE Numeric Range Numeric Range Convert a field or numbers into an ordered set of values featuring High Low limits and evenly grouped numeric segments i e 1 30 31 60 61 90 If you re trying to make sense of thousands of numeric values or want to create a simple graph that aggregates these value
9. Show sample of source row fields inside GoldMine as field item formatting e g formatting of numeric Open new window in GoldMine For Found record items Drill Through to Pop GoldMine Records Note Drildown preferences affect only the currently active workbook 4 4 Double click on any cell in any record on the first Drilldown worksheet to Drill down to GoldMine If the record is linked to a particular GoldMine contact 111 that record will pop in GoldMine That is control switches to your active GoldMine application and MasterMine queries the record by account number Excel remains active in the background and you can safely switch back and forth between the two In the drilldown preferences mentioned above you can Show sample of source row fields inside GoldMine MasterMine displays a list of the first eight to ten fields from the drilled down row thereby giving you a reminder of key information that may help you find the related information within the GoldMine record Open new window in GoldMine for found record not available on GoldMine PE opens a new contact window to display the report record instead of switching away from the current record in GoldMine In rare instances GoldMine calls up the record with the account number nearest the one you are seeking but not necessarily the same one MasterMine will check the account number against the target and alert you if it does not match T
10. poe eei ia 42 Document visible during refresh on open iai e rete teret e ire etes e HERR Re EU uE sas 42 Close dialog after report created aulae be iun e eed e etel eer m EN ete hama uB a Ges 42 Excel visible during Creation of report l nee e Re edet pute eee Saab d et hae co ue tedden ees 42 CREATING NEW 2 2 1 5 2 1 1 1 EEr is 43 GENERATING 550 5 ta h ER 43 Your first choice specifies which GoldMine area you intend to report Once you ve selected the area you can easily build report from scratch but specifying more narrowly which subtypes of each data with which you wish to work Alternatively the following section discusses existing template selection once the GoldMine area is specified ses 44 CONLACIS dEE 44 44 supa aa Spa au Sua utn E interes 45 Opportunities Projects and Cases u 46 Technical Point Table Jotns
11. Dates and Numerics GoldMine stores all Profile data as character data That is it does not give you the option of setting Date or Numeric types to fields and therefore it is not possible to check data entry errors unless you use Details Plus see page 28 for more information However MasterMine helps you get around this limitation for reporting purposes MasterMine can automatically group dates and numbers logically and in regular units year month 30 day group etc as long as fields contain only Date or Numeric type data To force MasterMine to interpret a profile field as Date indicate this preference by adding the Date designator code to the end of the field name defined in the Detail Properties for the _ profile To track additional Information about the details related to your contacts Detail Properties Detail Info Audit Setup you may customize up to 8 custom fields and designate a custom folder for this Detail done with the settings below select the Info folder of Date and numeric designators are defined in the the expanded Detail to edit and view the additional information MasterMine pre ferences General tab By default 5 2 Field1 GM License 20 Title Field Userstt 6 Ext these are amp amp for Date and HH for Numeric but Field2 MM License 20 LinkAcct Field amp Status 20 State you can change
12. If items in this field have not previously been grouped MasterMine creates a new field button with the name of the old field button plus 27 and opens a group naming dialog showing the default name for the new group Group1 Overwrite Group1 with a name that reflects the group s function or leave it as 1 You can treat the new grouped field button the same as any other field in the PivotTable If items in this field have already been grouped before you may either leave the selected items grouped into a new distinct group or you may add the selected items to another existing group by selecting that group in the list box instead of accepting the default generic group name 103 Group Field Items by Content Search Sometimes you need to isolate or to group items that contain a certain value one of several values This is easy if there are only a few items in the field in question so you can scan them easily But what if there are hundreds or thousands to search Fortunately MasterMine provides an alternative Rather than hunting through hundreds of items looking for a pattern do the following 1 Move the field to the row area of the pivot table so that items are listed below it 2 Click the field search button 84 OR select the field button itself with a single i click and then click the Group Find Item s in a Field and Group selected items button on the s MMTools ribbon
13. 3 Ltrim substring Stuff CH REF Charindex oc CH REF 1 200 Charindex trim mid iif CH REF Like oc CH REF 0c left CH REF instr CH REF CH LogChange Charindex Char 39 CH REF 25 1 CH REF instr 17 CH REF 2 Replicate sign Charindex oc CH REF iif CH REF Like Substring CH REF Charindex 0C6 left trim mid CH REF inst oc CH REF 5 50 Charindex r CH REF oc 4 len trim mid CH RE CH CH Contact oc CH REF F instr CH REF oc 4 1 isnull nullif rtrim Replicate sign Charin dex oc CH REF Substring CH REF amp iif CH REF Like Charindex left trim mid CH REF insitr oc CH REF 5 50 Charindex CH REF oc 4 len trim mid CH REF oc CH REF rtrim C1 Contact instr CH REF oc 4 CH CH or C1Contact 1 trim C1 Contact CH Record Type Data CH RECTYPE CH RECTYPE CH Full Activity Type Rtrim substring CH RECTYPE 1 2 trim left CH RECTYPE 2 sign Coalesce ascii substring CH RECT CH Success YPE 3 1 1 50 mid CH RECTYPE 3 1 lt gt U iif CH status Is Null CH HasNotes Coalesce substring CH STATUS 2 1 0 mid CH STATUS 2 CH CHNotes udfDBO udfMMStripHTML CH NOTES CH NOTES substring udfDBO udfMMStripHTML C CH CHNotes2 H NOTES 254 253 mid CH NOTES 254 substring udfDBO udfMMStripHTML C CH CHNotes3 H NOTES 507 253 mid CH NOTES 507 substring udfDBO udfMMStripHTML C CH
14. grouped field will disappear Notes on Groups Because grouping is so powerful and such an important feature of the dynamic nature of MasterMine it is important to know some key things about groups e Groups affect all pivot tables in a workbook that rely on the same cache of data Therefore if your wotkbook contains multiple worksheets cloned from a single one re grouping will apply across ALL pivot tables in the workbook e When you name a group in the dialog box that comes up when you create the group the new name applies across all pivot tables using the same data cache If you re name a group after the fact by typing over the group name directly in the pivot table the name change will apply only to the current pivot table e Creating groupaffectsthe shape of the pivot table Note that since grouping affects pivot tables across worksheets you might cause unintended changes to a pivot table on a worksheet other than the one that is currently active Check other sheets to make sure your changes are appropriate e Grouping data in a MasterMine report may be a difficult skill for some to master but it is the essential skill upon which data analysis is built Teach all of your users to work with Groups in MasterMine and you will take them a long way toward mastering their GoldMine data 106 Pivot Table Settings A pivot table itself has certain settings that can dramatically affect formatting Right click on a pivot ta
15. 1 Select field containing the value s you are searching For 2 MasterMine will create a new group consisting of all currently visible items in the selected field which contain o Any C None of the following elements If you have a cell selected on the field to be 3 Enter elements to be sought separated by commas or specify alternate delimiter searched the dialog defaults to that field Recall 22 22 gt ec 22 ES Click Any to your or logic to use iti Wildcard substitute For single charact Case Sensitive Search substitute For single character and logic or None to use ond not Begins with Wildcard substitute For string of unknown length logic as desired to guide the search If you are confused about what will happen read 4 i NewG the whole sentence of 2 and substitute Note Existing groups which contain Found items may be ungrouped An A as a result of this action This utility cannot be used with date fields depending on which have chosen Any function the same when only one element is sought Enter elements being sought separated by commas If a comma is part of the search term replace the comma the box above the elements to indicate a different multi element delimiter Even if you searching for only one element but that element conta
16. Next gt 7 Choose Destination Location Specify your preferred destination directory for MasterMine s program files and Click Next gt 8 Ready to Install Click Install 9 InstallShield Wizard Completed Click Finish After a brief pause you should see a dialog that looks like this 24 GoldMine Initial Settings BAX This information will be used to set up MasterMine to work most conveniently with your GoldMine usage These settings can be changed in the Preferences menu within the MasterMine Create Report dialog GoldMine Partner Name for support MasterMine Software Inc GoldMine Partner Phone 1 977 877 7212 toll free Do you use GoldMine Opportunities No C Yes and each Opportunity is linked to a GoldMine contact most common C Yes and Opportunities are independent of GoldMine contacts except for Influencer and Team tabs Do you use GoldMine Projects No C Yes and each Project is linked to a GoldMine contact most common C Yes and Projects are independent of GoldMine contacts except for Contacts and Team tabs Do you use GoldMine Cases Premium Edition or higher only No C Yes omes 10 Enter GoldMine Partner Information If you are a GoldMine partner or you use one as your primary support for GoldMine enter their name and phone number then click OK This information will appear for easy reference in MasterMine on the opening splash screen
17. or Sales as appropriate or Minutes Sales if both types of record are possible is included in most tables as the most reliable count field labelled where XX represents the source file Since count fields in the data area increment only if data are present in the field and RECID is the most likely to include some data we prefer to use this field for counts in the data area Be careful if you use another field as a count of data field only records with non null values in the target field get counted It s easy to trick yourself into believing false results 174 Appendix H Pivot Table Limitations There are certain limits to what can be displayed in a Pivot Table The limits are a direct consequence of the extraordinary flexibility and agility that Pivot Tables offer you in displaying yout data because Excel keeps all your data in live memory As Excel has evolved over the years these limitations have made each major release of Excel and therefore MasterMine even MORE useful Here s a summary of the specifications and limitations for the succession of Excel releases Read below for a full explanation of what these limitations actually mean in practice Limited Feature Excel 2000 Excel XP Excel 2003 Excel 2007 Max Unique Items per Field 8 000 32 768 32 768 1 Million for display ows 64 000 64 000 64 000 1 Million Pivot Table Columns Allowed
18. read the instructions and click Continue to launch the licensing dialog 29 MasterMine Serial Number Required Check to make sure the GoldMine serial number displayed is the correct one for the MasterMine license you are about to enter If so enter the numbers precisely as they are given on your license certificate or as provided by your GoldMine administrator When finished click the Register button If you have a MsterMine Site License the final box of Please enter a unique MasterMine serial number for the Register dialog will contain SL If you have a this workstation named user license your license number will be GoldMine S N 1 6201 Tez idi D D sequentially assigned to users Therefore if you have 5 MasterMine SAE I user MasterMine license each successive user will enter their license entering 01 02 or 03 etc into the last box so that there is no overlap between users If a _Use Demo Register Cancel user attempts to license MasterMine using a sequence number that was already assigned the dialog will respond that the license number is already in use and that a unique number should be entered The computer will store a 227 in the final box until a valid unused license number is substituted Convenience If your MasterMine license number is in your copy paste buffer you can enter it all at once by right clicking on the f
19. ro orto 79 MS Office installation esses 22 MS OFRIeeS I esiste eatenus 22 MS Query 83 86 123 INOteS eH 110 169 Number formats sse 78 Numeric data nas 28 37 Numeric Rane ie a aan teens 78 Open MasterMine Repott 43 143 Open RepOfLti s awa eee 72 Optimize Column Widths eee 68 Page Area aasan akaqa asikusqa 64 107 Page Filters u aa aa ass 97 Page Tayo utes a aaa aa aaa 108 Page Setup etes qaq 69 PivotTable formatting 68 83 107 134 139 PUM CHOTA 63 TI TATIONS a a tte etre ete oett 175 memoty usage 23 175 prefetences essit testae 107 179 PivotTable Options See PivotTable formatting Pop Record ertet 79 refereng8esu sescenti ees 34 37 Preserve Formatting wesc 107 Profile field s 37 as a 4 37 ptollesus ctc et ERES 137 Profiles nente eben 45 lup M 81 Purge Selected Field 75 Record Type ot View see 53 netten 67 81 Refresh on open sse 70 87 Refresh Quetry 15 58 81 98 108 134 petiodie iieri 108 134 Refreshing Repotts sss 121 eR hana 61 Report Builder Templates 49 Requirements Hardware aaa
20. tx he aa 55 VIEW THESQE QUERY MENU c5 erroe ite ctetu retos eater Ariens MEA ee ne NET h 57 HIT FINISH AND THE RESTS FINE TUNING aei erre etre teer ree esteem ee ee p esed tre m dese ee eie 58 GETTING ORIENTED REPORT PARTS AND FEATURES 61 TERMINOLOGYZz S SQ ESE erede n aem oder hated deeem een dre eer 61 Pivot Tables EE 61 Workbooks and eee etel eee repe et IR rt edet reste 61 vi Templates and Toolkits e e attt i ai eb sets pte eere Fe po bee A Rede eo 62 Database Terms EE 62 MASTERMINE SCREEN ELEMENTS aya sama RUD ODE OI DI RIO ned erp pes 63 Pivot Fable Elements E 63 FELD COLORS ASAS su Sua x Tre nV Sus 65 MASTERMINE RIBBONS IN EXCEL 2007 AND HIGHER 67 THEMXASTERMINE RIBBON uq netur tte de re caters hu e rn Herr eir ee rrr eerte 67 Refresh M 67 Analyze Rearrange Ribbon Group eee eese eese teen Sani the eee eE o ae trennen 68 Clean Up Ribbon Group remsen ot a et Su E eee p Sum ee Re ee pP E
21. C1 EXT4 C1 Address Rtrim C1 ADDRESS1 C1 ADDRESS1 C1 Address2 Rtrim C1 ADDRESS2 C1 ADDRESS2 C1 Address3 Rtrim C1 ADDRESS3 C1 ADDRESS3 C1 City Rtrim C1 CITY C1 CITY C1 State Rtrim C1 STATE C1 STATE C1 Zip Rtrim C1 ZIP C1 ZIP C1 Zip5 substring C1 ZIP 1 5 left C1 ZIP 5 Source MM Field SQLExpression dBase Expression 1 Postal Zone substring C1 ZIP 1 3 left C1 ZIP 3 C1 Country Rtrim C1 COUNTRY C1 COUNTRY C1 Dear Rtrim C1 DEAR C1 DEAR C1 Source Rtrim C1 SOURCE C1 SOURCE C1 KEY1 Rtrim C1 KEY1 C1 KEY1 C1 KEY2 Rtrim C1 KEY2 C1 KEY2 C1 KEYS Rtrim C1 KEY3 1 C1 KEY4 Rtrim C1 KEY4 C1 KEY4 C1 KEY5 Rtrim C1 KEY5 C1 KEY5 C1 C1Notes udfDBO udfMMStripHTML C1 NOTES C1 NOTES substring udfDBO udfMMStripHTML C1 C1 C1Notes2 NOTES 254 253 mid C1 NOTES 254 substring udfDBO udfMMStripHTML C1 C1 C1Notes3 NOTES 507 253 mid C1 NOTES 507 substring udfDBO udfMMStripHTML C1 C1 C1Notes4 NOTES 760 253 mid C1 NOTES 760 substring udfDBO udfMMStripHTML C1 C1 C1Notes5 NOTES 1013 253 mid C1 NOTES 1013 C1 MergeCodes Rtrim C1 MERGECODES C1 MERGECODES C1 CreateBy Rtrim C1 CREATEBY C1 CREATEBY iif C1 CREATEON Is C1 CreateOn Coalesce C1 CREATEON NullDate Null ZNullDate 2 C1 CREATEON Coalesce convert datetime nullif substrin g char ascii c1 accountno 17 isdate su bstr
22. Items the contents of fields and are visible with white backgrounds when their fields are present in the Row or Column areas or by clicking the list box associated with the field in the page area Usually an item represents a summary of all occurrences of that item in a given GoldMine field 65 66 A gt Chapter MasterMine Ribbons in Excel 2007 and higher With version 7 MasterMine introduced an extensive set of functions launchable from three Ribbons as Excel s former toolbars or commandbats now known These ribbons provide a wide variety of convenient and powerful tools for report refinement data manipulation and active interfacing with GoldMine Briefly the MasterMine ribbon is available at all times when a MasterMine workbook is open in Excel The MMTools ribbon is part of the Pivot Table submenu and therefore available only when a cell is selected ON a pivot table And finally the MasterMine Drilldown menu is available whenever the user has drilled down from a MasterMine pivot table creating a new detail worksheet which is formatted automatically in to a flat Excel table The MasterMine Ribbon Gail s amp MR xIs Compatibility Mode Microsoft Excel PivotTable Tools Home Insert Page Layout Formulas Data Review View GoldMine MasterMine Options Design MM Tools 2 gt Refresh All Refresh All 5 Clone Freeze Optimize Field Worksheet Unfr
23. Most GoldMine site managers and all GoldMine Solutions Partners should have this level of knowledge already MasterMine Software Inc provides training to achieve any desired level of user competence Some GoldMine Solutions Partners offer training for MasterMine data mining techniques as well Beginning MasterMine Users know the following e Comfortable with GoldMine usage e Know the names and functions of all key fields on the GoldMine contact screen Familiar with lookups and customized codes for their business e Know or can learn basic Microsoft Excel functionality mouse functions manipulating data saving and retrieving spreadsheets and can do the following with MasterMine e Use pre formatted MasterMine reports to dynamically summarize and analyze sales calling faxing scheduling referral and custom profile information e Drill down to and correct data exceptions that may indicate serious business process or training issues or simply data entry errors e Manage individuals and groups by performance criteria e Manage and improve all GoldMine based business processes Intermediate MasterMine Users have the following additional knowledge e Familiar with standard Excel Pivot Table functionality and MasterMine s enhancements e Have detailed knowledge of GoldMine s underlying database structures and can do the following with MasterMine e Replace most static management reports with a standardiz
24. Opportunities C Cases Select fields to include v C1 Company v C1 State v C1 Source v C1 Account Type C1 Status v 1 Partner v C1 Account Rep v C1 Product Int C1 CreateOn lt Design New v C1 C1AccountNo C1 Linked To Contact C1 Last Name C1 Dept C1 Title C1 Suppt C1 PrimaryE mail C1 PrimaryEmail Merge C1 Phone C1 Phone2 C Use Template C1 Toll Free C1 Ext C1 Ext2 C1 Ext3 C1 Ext4 C1 Address C1 Address2 C1 Address3 C1 City Report Name Prospect Analysis SaveTo Path C MasterMine Reports 25 Save Template Filter Finish Cancel Create New MasterMine Workbook File Toolkits 501 Query Preferences Help Which part of GoldMine s information do you want to see C Contacts Main Additional Activities History Details Opportunities Cases Select fields to include C1 Contact v C1 Company v CA Activity Type v CA Activity Contact v CA OnDate v CA OnDay v CA User ID v CA Activity Code v Reference v CA DrWeek lt Design New All except E mail Call Next Action Appointment Literature Request Sale Other Action Event To do E mail v v CA CARecords v C1 Linked To Contact v C1 State v C1 Source v C1 Account Type v C1 Status v C1 MM Partner v C1 Account Rep v C1 Product Int Use Template CA Activit
25. Pivot Table Elements The basic elements of an Excel Pivot Table include Row Column Data Page and Hidden areas arranged as follows 63 Column Area Hidden Area Row Area Data Area All available fields listed on the Pivot Table Field List The Row and Column areas show field items the various possible values within a field Row Area fields create one row per field item The Data area shows the actual summarized data usually either a count of items in a field or a summation of the values in a numeric field The data area must include at least one field but it may include multiple fields in complex reports The Page area includes fields containing data not currently displayed in the table but which may be dragged into Rows or Columns Selecting one ot many items within a Page field filters what appears in the rest of the pivot table 7 Budget _ CreateOn All Column Area Pivot Table Field List Pues Fn Column Fields Column Items or Hidden Area 12 t x 13 CtAccountNo Territofy Drag items to the PivotTable report 14 Contact Type Industry __ v CN CT Mw N PN RM 5 15 Engineering 1 1 1 Contact 16 Food 1 1 2 1 17 TPharmaceuticals 1 2 2 2 1 2 1 Ejcemnony 18 Suspect Aviation 1 1 1 3 2 3 2 Ej OnMonth Engineering 1 4 4 1 2 1 EJ Pre Post Demo Row Fields Food 1 5 2 2 5 1 Demo Row Item
26. You can minimize the amount of effort necessary to do this if you follow a few rules For SQL databases e Do not rename the GoldMine database itself if possible e On your new server create usernames and passwords that are the same as on your old server e Unless you need to for security purposes avoid using specific database owner names instead of the default dbo For dBase databases Keep a copy of your old database accessible during the turnover period so that old reports can still be opened long enough to re direct them to the new data e Because querying dBase data across a network can be very slow consider deploying reports to the same server on which the data resides If re hosting from dBase to SQL Plan to re create your reports from scratch as the underlying query needs to be created in a completely different syntax than the one in which it started While it is technically possible to preserve an existing report and replace the back end query with a new one this method contains many potential pitfalls and should only be handled by an experienced technician Contact MasterMine Software if you wish us to do this for you With these suggestions in place here are some technical notes that may assist you in redirecting your data pointer within an existing MasterMine report If you followed the advice above and the only change in your data location is the SQL Server name you can easily redirect repor
27. gives users inaccurate reportsbut such centralized reports typically get muddled with information for various users who need it presented differently for each of their jobs At the same time it forces all users either to make do with a multi use report that only partially serves them Eventually it becomes a bureaucratic process printing and distributing copies of a compromise report instead of a dynamic solution to each person s unique information needs With MasterMine you can use Excel s native SaveTo capability to save a unique version of a report to any disk location where another licensed MasterMine user has 119 access The user can launch the report at will with current data and reorganize it on the page as needed The original report writer person need not be involved after the initial creation process We urge you not to waste MasterMine s end user flexibility by restricting MasterMine usage to a single or only a few users MasterMine provides inexpensive share licenses for precisely this reason to give end users the full flexibility of MasterMine without the responsibility of generating reports from scratch Sharing Reports Each MasterMine report contains a connection string pointing to the original source of the data This means that MasterMine reports can be stored anywhere albeit only refreshed when the data is available along the same path used to create the report The most common way to
28. of line listing type reports where many fields are dragged into the row area of the report this selection automatically turns it off for all fields Users then need to deliberately turn on the subtotaling function for fields where they wish to use it To turn them back on double click each field button for which you wish to restore subtotaling and check Automatic on the left side under subtotals 40 Substitute blank space for blank in field items By default blank spaces in pivot tables are represented with the written out notation blank For users who prefer that reports default to a true blank data field this alternative automatically substitutes a single space instead of blank for all fields Note that this is not related to another distinction frequently seen with SOL databases namely the distinction between null values and blank values SOL Server makes this distinction returning to Excel a null value alphabetized at the top of the field item list if the field has never contained a value and returning a or blank alphabetized at the bottom of the field item list and showing up by default as blank Although MasterMine does not do this automatically users may wish to aggregate these two forms of empty by grouping them into a single item or by applying the Isnull function in MSQuery to the field in question Use Logo Check this item and enter a valid path to a
29. 19 3 588 00 20 PENNY 11 750 71 160 00 allows him or her to see the 21 26 575 17 995 00 295 00 proportionality between individual 22 MW Total 106 750 78 4 843 00 1 394 00 3 NE 142 373 64 7 485 00 103 075 01 Users performance against one another 24 NW 17 745 80 5 943 00 7317 80 25 SE 87 730 30 27 797 60 32 116 25 644 AND against other regions 5 50 56 361 43 20 805 22 16 091 00 93 257 65 27 SW 114 209 12 8 747 07 2238495 145 341 14 manager can then proceed to roll 28 Grand Total 587 523 68 82 014 69 186 764 01 down additional Regions again by double clicking on each region as needed He or she can roll them up again by yet again double clicking on the same region names This selective roll up roll down feature should be used actively by any end user as a means to quickly understand large amounts of data and to present it for others in the most revealing fashion Combine Rollup Rolldown with Item Grouping The above example shows the detail you see when rolling down the items of a second field UserID from the database This is very useful However you also create groups within a single field for example grouping Sales Rep field items the sales reps into Regions even though you don t have a field in your database called Regions Even 100 9 1 1 ET ES 2 3 4 5 B 7 8 9 E Es 1 1 20 2 2 1 2 23 24 Urvvege
30. 41322011 7 47 32 PM Save MasterMine Reports Skip right History Activities Call for ACW List of All New 8 2 2011 11 41 14 AM 117KB 8 2 2011 11 41 14 AM th 5 b History Activities Call time of calls lsrn 5 4 2011 1 17 33 PM 5902KB 5 4 2011 1 17 33 PM History Activities Call xlsm 4 15 2011 2 03 03 PM 775KB 4 14 2011 7 44 15 PM to reate menu item to History Activities E mail daniel demo xlsm 5 26 2011 10 48 01 AM 27292 5 26 2011 10 48 01 4 Last Completed Call 2 xism 4 19 2011 4 06 55 PM IBI7KB 4 19 2011 4 06 55 PM creating new repotts if you ate Last Completed Call for acw check for pending xl 7 14 2011 2 06 00 PM 81 7 14 2011 2 06 00 PM m Last Completed Call for ACW List of All New Acts 7 18 2011 1 14 41 PM 106KB 7 18 2011 1 14 41 PM licensed to do so ot use the Open Last Completed Call for nancys workable accoun 4 14 2011 8 09 47 PM 164KB 41422011 8 09 47 Last Completed Call history report for home xlsm 7 18 2011 3 05 25 PM 1BB KB 6 8 2011 4 55 32 PM 1 1 Lot ad raneh se 223122011 552 33 PM 19 KR 3 31 2011 12 558 PM 7 dialog to navigate toa report created m gt and saved by another user From now on the folder containing the opened report wil appear in this treeview Reporting and Data Management for GoldMine Copyright C 1999 2012 MasterMine Software Inc U S Patent Nos 7 185 279 and 7 945 850 Use the right cli
31. CSState Rtrim CS STATE CS STATE CS CSAddress1 Rtrim CS ADDRESS1 CS ADDRESS1 CS CSAddress2 Rtrim CS ADDRESS2 CS ADDRESS2 CS CSAddress3 Rtrim CS ADDRESS3 CS ADDRESS3 CS CSDear Rtrim CS DEAR CS DEAR CS CSPhone Rtrim CS PHONE CS PHONE CS CSFax Rtrim CS FAX CS FAX datevalue iif isdate format mid cs city 9 Convert datetime coalesce nullif substrin 8 g CS CITY 9 Isdate Substring CS CITY format mid CS CITY 9 8 CS CSCreateOn 9 8 8 0 NullDate NullDate CS CSCreateBy Substring CS CITY 1 8 left cs city 8 CS EmailMergeCodes Rtrim CS MERGECODES CS MERGECODES CS CSLastUser Rtrim CS LASTUSER CS LASTUSER CS CSCity Rtrim CS CITY CS CITY Source MM Field SQLExpression dBase Expression iif CS LASTDATE is null CS CSLastModified Coalesce CS LastDate NullDate NullDate CS LastDate CS CSAccountNo CS ACCOUNTNO CS ACCOUNTNO CS CSRecords CS RECID CS RECID CS CSHasNotes CS STATUS CS STATUS CS CSNotes udfDBO udfMMStripHTML CS NOTES CS NOTES substring udfDBO udfMMStripHTML C CS CSNotes2 S NOTES 254 253 mid CS NOTES 254 substring udfDBO udfMMStripHTML C CS CSNotes3 S NOTES 507 253 mid CS NOTES 507 substring udfDBO udfMMStripHTML C CS CSNotes4 S NOTES 760 253 mid CS NOTES 760 substring udfDBO udfMMStripHTML C CS CSNotes5 S NOTES 1013 253 mid CS NOTES 1
32. Code Rtrim CA ACTVCODE CA ACTVCODE substring rtrim CA Ref 1 CA Short Reference ShortRefLen left CA Ref ShortRefLen CA Product Rtrim CA REF CA REF CA Reference Rtrim CA REF CA REF iif CA ONDATE Is CA OnWeek Coalesce CA OnDate NullDate Null NullDate CA ONDATE iif CA duration is null 0 Convert float Coalesce CA Duration 0 iif CA RECTYPE lt gt S 0 CA duration 10 CA Probability 100 0 CA Duration Coalesce CA Duration 0 iif CA duration Is Null O CA DURATION CA Meeting Confirm CA ACONFIRM CA ACONFIRM CA Appointment User Rtrim CA APPTUSER CA APPTUSER iif CA status Is Null CA HasNotes Coalesce substring CA STATUS 2 1 0 smid CA STATUS 2 CA CANotes udfDBO udfMMStripHTML CA NOTES CA NOTES substring udfDBO udfMMStripHTML C CA CANotes2 A NOTES 254 253 mid CA NOTES 254 substring udfDBO udfMMStripHTML C CA CANotes3 A NOTES 507 253 mid CA NOTES 507 substring udfDBO udfMMStripHTML C CA CANotes4 A NOTES 760 253 mid CA NOTES 760 substring udfDBO udfMMStripHTML C CA CANotes5 A NOTES 1013 253 mid CA NOTES 1013 CA Potential Amount Coalesce CA NUMBER1 0 157 iif CA NUMBER1 Is Null 0 CA NUMBER1 Source MM Field Name SQLExpression dBase Expression iif CA NUMBER2 Is CA Potential Units Coalesce CA NUMBER2 0 Null O CA NUMBER2 iif CA NUMBER 1 Is Coalesce C
33. Date sese enne 37 Character s ending Profile field names to indicate Treat field as Numeric eee ene 37 Standard length to pull from Reference Product field eese eee nee entente 38 Default start date for history atsi ec tet re ded ibe er E Ee e De ee Ee ee 38 Date to substitute when date fields contain no data or unreadable date eene 38 TOOEKITS PREFERENCES dene a arenosis 38 INTEGRATION SSL SS RAP reborn amo aree beverage mere de 39 COMPATIBILITY PREFERENCES mede demere rere ees 39 DEFAULTS PREFERENCES uiid ere 40 Hide page fields set to AU us eoe reete 40 Hide page fields with no valid items esee 40 Turn off subtotals for Gly fields tete tait tte rei e ese et re Q h Ga shua ss ss 40 Substitute blank space for blank in field items sese eene 41 MU P M M s 41 Always save SQL password in reports Gua h qhip aa h ua sa asa Su S uba usia pusa apay 41 Always dock4oolbar on report open et pete ede E pde e eee EE EEE eet ete SS aaa 41 Hide fields list onyeport open a getan ue
34. ER O CO 0 Finally we subtotal group roll up our groups into sinele items use them as filters whatever makes it easiest to understand our calling results Here s how the same report looks rolled up into a tight summary 102 KI E ES Cy n em 4 Lu e N NINN N 5 Unvveek M 6 Account Rep A Result Code2 Result Code gt User ID gt Groups can be treated just like individual field items as filters in the Page area of your report or as display elements row or column items just like regular field items Therefore you can compare not just calls by PAUL PENNY and ROB as individuals but also by region where each region is actually a group of users instead of a separate field value as they are in GoldMine Grouping Techniques and Tricks To build a local Group in MasterMine use one of these methods Manually Group Field Items Highlight the items within a Row or Column field you wish to group and click the Group selected items button on the MMTools ribbon You can highlight these items either by drag selecting them if they are next to each other or if the desired items are not next to each other click the first item and control click the rest You can add mote items to your highlighted selection by control dicking or control drag selecting additional ones BEFORE hitting the group button
35. Excel version 11 0 Windows User Rob 86 password is not entirely secure since hackers can open an Excel workbook to see a password stored within it Help The Help tab inside the Query Display provides access to MasterMine s underlying information in the About MasterMine text window as well as a link to this User Manual Click on the User Manual to launch this manual as a PDF file You must have Actobat Reader installed on the workstation More Toolbar Buttons 8 Add Report to GoldMine Taskbar GoldMine Group Create GoldMine group from all rows listed in Drill Down screen This button is enabled only when viewing a drill down screen Add to GoldMine Taskbar Adds the current report to a GoldMine taskbar for button launch either in your own GoldMine or in another user s This is the quickest easiest way to deploy a report for easy repeated use Note that other users must have MasterMine licenses to launch these reports This dialog allows you to select any GoldMine user whose taskbar will have a button which will lauch the current workbook at will An existing taskbar may be selected or a new one created The Caption is the label which will accompany the new icon on the GoldMine taskbat Set security and convenience parameters in the lower frame of the dialog as follows Add this report to a taskbar in GoldMine for easy one button launch GoldMine Username per e Auto Refresh
36. GoldMine When drilling through to GoldMine by double clicking anywhere in a row of a drilldown sheet to the underlying record this feature shows the first eight fields of the source row This is useful especially if you drilled down from an Activity Report to remind the user which pending or history activity to bring up Open new window in GoldMine for found record By default drilldown causes the currently displayed record in GoldMine to change to that of the drilled down row potentially losing the user s place GoldMine This option opens a new contact window in GoldMine so that the user can easily go back to the previouscontact Connection The connection string defines the location of the reported GoldMine data as well as driver information user may change this information for instance if the SOL database name or server location is changed Caution Invalid changes to the connection string not trapped and may cotrupt the pivot table and render it unrefreshable In this event immediately attempt to repair the connection string or close the workbook without saving changes in order to preserve the report Note that if the SQL password is saved in your pivot table it is obscured by in the Connection box You may enter a new username passwotd combination here if desired by turning on SQL password saving in table options The syntax for the password line 15 PWD pass
37. GoldMine data stored within it and the ability to be automatically refreshed Being aware of this relationship helps you choose wisely among the following options Don t distribute Deploy Too many organizations bottleneck all reporting through a single highly trained or not report writing person or department This results in only a handful of people getting information when they need it The rest of the people depend on the availability of this person as well as on their own ability to accurately describe information needed the report writer s ability to correctly interpret it and other dubious factors to get a report One of MasterMine s big advantages is that it breaks this bottleneck putting much more power and flexibility into the hands of the end user who needs the information The key is to send a live refreshable changeable report to the user so he or she can run their own report as needed with a simple button click Since anyone can learn MasterMine s most basic moves refresh drill through any user can turn a single simple report deployed to them by a Full Licensed user into a wealth of information that is literally at their fingertips common workaround for companies with a shortage of report writer skills is to print reports on a regular basis say weekly or monthly and force users to accept the printed reports even if they are obsolete as the only information available to them This not only
38. Issue Notes5 NOTES 1013 253 mid PI NOTES 1013 PI PlAccountNo IssueRecords PI RECID PI RECID PC PCRectype Rtrim PC RECTYPE PC RECTYPE PC ContactCompany Rtrim PC COMPANY PC COMPANY PC ContactName Rtrim PC CONTACT PC CONTACT PC ContactTitle Rtrim PC CYCLE PC CYCLE PC ContactRole Rtrim PC STATUS PC STATUS PC PCAccountNo PC ACCOUNTNO PC ACCOUNTNO PC ContactRecords PC RECID PC RECID Appendix E Note on Notes Notes fields in GoldMine are of unlimited length which poses a challenge to users who want to wotk with them in reporting or analysis In order to make them manageable MasterMine extracts Notes fields from your data in sequentially numbered segments each 253 bytes characters long These segments with names like CS Notes CSNotes2 CSNotes3 etc must remain contiguous in the MasterMine query in order for MasterMine to handle them properly as desctibed below The user must decide how many of these segments to use for the job at hand Although notes can be theoretically of unlimited length consider what the maximum length of one of your notes might be in practice or alternatively how much of the longer notes you are willing to ignore for your report typical user might decide that everything they need 1s probably contained in the first 253 characters of the notes and therefore would include only CS Notes not CS Notes2 etc in
39. Make a copy save the original and freely create promising variations Cloning a whole workbook is as simple as hitting SaveAs inside an existing report Remember to save unchanged the report you started with so you can go back to it at will Often it makes sense to group reports with similar source data but different presentations into a folder by themselves Remember also that from the MasterMine ribbon you can instantly clone any worksheet within a workbook creating variation after variation until you have what you need Then 108 you can go back and delete earlier versions that you didn t need Nothing is wasted by trying vatious options within a single workbook Auto Refresh When you deploy reports to other users especially people not as familiar with MasterMine as you are you should turn on Auto refresh since they are likely to assume that what they see is current And here s another twist on auto refresh Some users not only prefer that reports refresh as they open but also that open reports refresh every few minutes A well designed dashboard that shows the key metrics for the business especially ones that summarize a lot of fast changing information for example call results from a large outbound calling center can be a powerful management tool all by itself Set Filters Across Worksheets Page Selection As you clone your report from worksheet to worksheet you create a vatiety of related reports within
40. NR Ue 116 Ideas for MMUpd ter tasksz u a s dU ceu qu uade Sau h hua sys 116 DEPLOYING SHARING AND MANAGING REPORT S 119 DON T DISTRIBUTE DEPLOY ta indere tea er canes adeeb cn Er ER EN epe R 119 SHARING REPORTS oaei S 120 viii OPENING EXISTING 8 4444 4 120 Open Vid Windows dialog CE Re edo 121 Launch from a GoldMine Taskbar idee AR ertet D ete er ERR Deer gite a as le 121 REFRESHING REPORTS eO E e ee ster a a a 121 COPY AND SEND REPORTS OUTSIDE OF MASTERMINE 1 00 00000 enne esten enne reet tene 122 MODIFY UNDERLYING QUERY sere esveseo esiti to PE Fe PE FEET HE Ee eo PE Sopa tes Tee DRE SPP e epa e Pao eo tosses 123 WORKING WITH MS QUERY Q iret cette fu ete Pe etre tede S Env tee Pe ede pee bee Puce ed en Pe a edere tenor 123 ZH IB A 124 MODIFYING YOUR QUERY 5 5 eoe re crece ce bee eve reo tee eed E reete 124 ACCESSIN
41. RR 68 Fields ACGODNITINO ees 173 COMPANY Sas masay treten 173 DURATION 173 Linked to Contact 112 173 Mite 174 ONDATE uuu 173 RECID 174 REGHEYDBE 173 173 Short Reference 173 SUCCESS n 173 File Locations 24 31 32 54 ate a edes 55 Faltetifip sadi teet 55 Key Piel Ges tente 56 PiltefsSsissnssasshenaBengncheNGni UE 109 Eiftalizez sonent nr 79 55 Fiscal Year unu eh 77 Folder Treeview sii una aaa aaa aaa 35 Format Numetic Hields 110 Formatting TUM ELS a 96 PivotTables See PivotTable formatting 68 83 140 GoldMine Administrators Toolkit 49 GoldMine Filters 55 GoldMine Group sse 78 GoldMine Groups sss 56 87 GoldMine taskbat 70 87 GoldMine Taskbar 121 Grand Totals annassa 110 Giro 76 98 105 1teTHIS
42. Test Run do not update GoldMine Use this MasterMine column to match AccountNo containing the normally used match field for the selected table will be displayed in the second field In most cases the default selection here is the correct one to use when MMUpdater looks up your target record GoldMine For the Contact table the AccountNo is used For any other table a RecID is required MasterMine labels RecID fields as CXRecords where CX corresponds to the key table in the quety behind the MasterMine report you are using In some rare instances you have vattety of match fields to choose from if your MasterMine report includes multiple AccountNo or RecID fields Replace the contents of this GoldMine field Select the target field in GoldMine to be updated The list of fields here is all fields in the table you selected above showing both user friendly labels and database field names with the contents of this MasterMine column Defaults to the name of the wotksheet column containing your highlighted data You may select a different column than the one that defaults MMUpdater Options The following options can all be set to default differently in preferences byclicking the preferences menu Add numbers to existing field data If the target field is a numeric field the value from the MasterMine worksheet is added to rather than replacing whatever value is already cont
43. aan oie ER aan REA ays 82 142 96 on content search 104 Headings 109 Help see ERE 87 Hidden Area 64 98 110 128 Hidden Items esee 107 hide items in a field 107 Hide unused filters sss 69 How to deploy a 70 87 How to add fields to an existing query 125 add MasterMine users ose 34 add remove subtotals 110 create a MasterMine 43 drill down for detail s 111 manage existing reports 121 133 refresh data in an existing report 81 108 121 134 troubleshoot repotts 133 Installation iue iion 21 24 torsit tse 29 30 Integration of non GoldMine data 15 19 123 Items Per Field enne 177 Un rM 46 127 134 Label retener 109 Large File Handling See Memory managing usage Launch 34 21 24 limitquety 6 24 Line Listing esee 111 MasterMine Drilldown Ribbon 78 MasterMine Ribbon sss 67 Memory managing USAGE wesc 50 134 Mei Launch eedem 34 MMTools Ribbon see 72 MNI pd tet
44. and sometimes ABED You want to include only those whose Reference field also contains the word sold In this case you would click the radio button at the top enter the following without quotes into the box after Enter elements to be sought separated by commas AB D sold Finally name the group something non generic like ABxD and sold When you hit the OR button every field element visible in the row area will be searched and if it meets the criteria will be highlighted and grouped then shifted as a group to the top of the row area Now the user has many choices of how to use this grouping further 1 Double click on ABxD and sold to roll it up or down 2 Drag the new field Reference2 up to the page area and select ABxD and sold in the dropdown list next to it thereby filtering the report to include only those in the ABxD and sold group 3 almost anything else you can do with a single field item Date Ranges Group Using Date Fields Any date field can be automatically grouped by several calendar units year quarter month date at once This allows you for example to quickly organize any report around year to year or month to month comparisons date ranges or single dates First make sure the date field you wish to group is in either the Row or Column area of Auto your report Then select any date item in the Starting at field and click the Date ran
45. be getting priority attention How can we use past expetience to anticipate the future How can we do mote of what has worked in the past and stop doing what does not work Keep these questions in mind as you creatively explore the views and insights MasterMine gives you about your data Start with the familiar a sales projection report or calls analysis report for instance and see how you can slightly alter your viewpoint to identify a new opportunity or anticipate a problem Suddenly you ll realize that up until now you ve been flying blind and the static management reports you had been using seem woefully inadequate to your most important task overseeing and guiding your business process as it happens Other chapters cover the mechanics of manipulating your data with MasterMine This one helps use your creativity and unique knowledge about your business to turn MasterMine into your most powerful management tool 131 Data Mining Techniques The key to Data Mining success is recognizing the important relationships in your own company and expanding your reach from there These relationships often expressed with phrases like Key Progress Indicators or chokepoints Your old static management reports are probably the best starting point of where to look Look at your old reports and ask yourself If I could alter this report slightly see the same data for only one division for one useror group of users for one lead
46. be used in different ways depending on the conventions set up within your business Most companies link each project to a contact record so by default MasterMine assumes this is the case Howevet some organizations use projects in such a way that the contact under which the project is linked is irrelevant Enable the appropriate one in your preferences see Chapter 3 Preferences page Error Bookmark not defined The opportunity manager table OpMgr contains Projects as well and these are defined by a seties of sub tables see GoldMine Data Structure documentation In MasterMine these sub tables have the following aliases as seen under GM Tables below In most cases the alias corresponds with the OpMgr or record type used to identify them in GoldMine Alias Table For Tab C1 Contact1 Main Contacts C2 Contact2 Custom Fields CH ContHist History CA Cal Pending CS ContSupp Supp Contacts PJ OpMgr Projects PK OpMgr Tasks PF OpMgrFld Details PC OpMgr Contacts PT OpMgr Team PI OpMgr Issues PC OpMgr Influencers Workbook Name Description GM Tables All Projects Contacts relating to Projects PJC1C2 Project Tasks Tasks relating to Projects PJPKC1C2 Project Details Details relating to Projects PJPFC1C2 Project Contacts Contacts relating to Projects PJPCC1C2 Team Members relating to Projects Shows team member information from the Project record only not original GM Project Te
47. can make loading a long process For reports that you open several times a day and don t need up to the minute data it s best to leave this one unchecked Refresh Every __ Minutes Setting a refresh time on live reports gives you current information at any moment on key business processes without any intervention on your part This allows you to turn your dynamic report into a real time display Those familiar with Microsoft s Digital Dashboard will appreciate how easy this makes building your own dashboard element Background Query Allows you to work with your PivotTable while data is loading This can be a time saver for long refreshes when you may want to begin moving fields around before you have your final data Be aware that when the query finishes different data may alter the layout you want to see Optimize Memory Try this one at your own tisk Microsoft introduced this feature with Office 97 but it never worked properly in that edition We recommend closing the reports you re not using and optimizing memory by careful field selection More Tips amp Tricks in Excel Here in no particular order are some additional tips that can help you get the most value from your GoldMine data Branch Off From Existing Reports Branching off from earlier work instead of starting at square one can save you tremendous time If you have a report that serves you well but a variation might also be useful don t re create it from scratch
48. counts and sums the data area by the amounts associated with these items When you use the same report later your report may be misleading unless you account for your missing hidden items In addition to sheer long run convenience this is why we recommend using the grouping method of filtering described above wherever possible e HINT New users tend to overuse this feature It can be very time consuming to check or uncheck large numbers of field items It is easier to create a group of items that you want to display of the ones you want to hide Then you can simply turn the group on or off as desired either in the Row or Column area or even better in the Page Area Read more about data grouping starting on page 101 e If you move a field containing hidden items up to the Page area the missing items will still affect the displayed data This may or may not be desirable If you DO want this to happen it is probably best to type in a hint to the user to the right of the Page area indicating the hidden values If you DO NOT want hidden values to affect the displayed report you can change the table attribute Subtotal hidden page items as desired e Hidden items can always be revealed by moving the field to the Row Area and viewing the dropdown list associated with it If you see unchecked field items there re checking them will return them to the report Without moving the field you can also see hidden items by dou
49. dBase the date the quety was last refreshed against the GoldMine data the number of records in the query and memory size of the query MasterMine Pivot Table Control C1AccountNo OnYear Result Group gt Call Res Contact Completed INP 1 Stats Drilldown Connection Query Text Security About Selected PivotTable 2008 Grand Total Selected PivotField Call Result Result Code Display Name Field Name Selected Item Completed COM The user can also see how many data caches are contained in the workbook and which one 1s being used by the current pivot table This can be significant if there memory issues or if the report is a fairly complex one containing many pivot tables with different data sources ie different underlying queties There is also information about the selected field on the pivot table which can help the user trace a value that appeats in the report to the field in GoldMine that contains it In the image here the user selected the pivot item Completed within the field Call Result when calling up the information display Display box reveals that the GoldMine field Result Code has a local name of Call Result in this report The latter may be a more meaningful label in the context of the current report but it helps to know what field it represents GoldMine Likewis
50. database With this capability you can e Further customize reports built from MasterMine s templates to use the unique uset defined features of your own GoldMine installation e Make your Pivot Tables as efficient as possible in handling larger database files e Vastly increase the power of all your analyses by zeroing in on key data relationships that otherwise cannot be represented in Pivot Tables You can pre format the data in various ways take part or all of a given field s data or perform calculations on it in combination with other fields You can also change the criteria by which data is included or excluded from the query and integrate data tables from other sources within or outside of GoldMine This is very powerful stuff but WARNING Changing the underlying query for your PivotTable is a valuable skill best left to trained users Accurately applying the more powerful actions in Query requires some knowledge of GoldMine data structures and some familiarity with basic dBase or SQL functions like mid left right trim etc We encourage free form tweaking with reports from MasterMine templates but bear in mind that your own workbooks contain the aggregate effort you have put into them over 123 multiple sessions including your own groupings data labels etc If you change the query that underlies any Pivot Table and get an improper result and then save your workbook you will not be able to recover the lost re
51. down while you move the mouse to the target area for the field then dropping the field by releasing the clicker As you drag a field in a pivot table notice how the mouse icon changes to a schematic of the pivot table itself with the highlighted area reflecting the area of the pivot table where your mouse is hovering Letting go of the clicker will drop the field into the pivot table area corresponding to the highlighted area in the mouse icon The rest of this manual assumes you know the names of the areas in a pivot table If you are not familiar with the areas of a pivot table and how they relate to data layout please refer to Pivot Table Elements on page 63 In this example the Company field is beine dragged and is hovering over the Page area of the pivot table Therefore the upper part of the mouse icon is highlighted in blue Notice also that a fuzzy line appears between the 89 Suspect State and Source fields indicating that the Company field would be located between these fields if the user were to drop it Red X If your mouse icon changes to a Red X instead of the pivot table schematic as you drag your field it means that your mouse has moved past the area covered by the pivot table and instead is hovering over the raw spreadsheet You can retrieve the field at any time however from the Hidden Area Te Dropping the field at this point removes it from the pivot
52. for the current workbook Users ate expected to use this function frequently while developing custom data analysis workbooks and dashboards Freeze Panes Freezes panes on the worksheet so that the top row and column of Pivot Table are the crux of the frozen pane If there are several Pivot Tables and none is selected user is prompted to select one Optimize Column Widths For selected Pivot Table or if there is only one Pivot Table automatically resets column width to accommodate display of all data on the table Field list Toggle visibility of the pivot table field list on the right side of the screen The field list contains ALL fields available in the query that underlies the pivot table From the field list drag any field into the pivot table for display or filtering Clean Up Ribbon Group Use the functions in this sub ribbon to prepare your report for delivery by simplifying the contents to only what is needed Delete All Worksheets named Sheet Deletes drill down sheets still generically named This helps clean up a report where many drilldowns have been performed 1 o Delete Logsheets Delete worksheets named Log MM DD YYYY Deletes logsheets created by MMUpdater During intensive updating a user may create many Log sheets that are not needed once the job is complete 68 EN Delete Sheet and Logs Hide Unused Filters Security Delete all drilldown and Log sheets at once Hid
53. from a GoldMine taskbar To get the most from your GoldMine database and to avoid duplicating work MasterMine users should share reports by frequently deploying them to their own or other network users GoldMine taskbars This is also one of the best ways for an experienced report creator MasterMine to share reports with less experienced users Refreshing Reports Unlike with traditional report generators it is not necessary to create a new report evety time you want to see your information in a certain format If you have already run a workbook and formatted reports to your satisfaction simply select Open MasterMine Report from the GoldMine menu and select a report you have already formatted and saved You can refresh your report several ways 1 After opening the report hit Refresh or Refresh All on the MasterMine ribbon A counter on the bottom of the screen indicates refresh progress so you can anticipate how long this will take 2 You can set the report to refresh automatically every time it is opened on a periodic basis while the report is open by checking the appropriate boxes in the Pivot Table Options dialog Find this dialog by right clicking anywhere on the pivot table and selecting Table Options from the short menu 121 When you save formatted report be sure to change the name to reflect more closely what you use it for This way it won t be accidentally overwr
54. in Pivot Table 255 255 255 16 000 Maximum Number of No maximum No maximum No maximum No maximum Records Maximum Query Size 100MB Available RAM Available RAM Available RAM Column Field 32 768 32 768 32 768 1 Million NET possible Actual Actual Actual Intetsections I intersections intetsections intetsections intersections Row Field Albien SIB Ey ES possible available ntersections intersections intersections intersections memory Pivot Tables are best suited to display up to a few screens full of data at a time If they are wisely used they can almost always display what you need to see when you need to see it However they and by extension MasterMine are of limited use as a data dumping device as opposed to an analytical summary reporting or simple line listing device 175 Maximum Number of Records There is no fixed maximum number of records you can use when you create a Pivot Table In practice creating a Pivot Table from an external database that contains a very large number of records can strain the performance of the workstation on which Excel is running and can take vety long time to complete if your quety is so large that it uses up all available RAM Maximum Query Size With Office 2000 or lower you will receive an Out of Memory error if you try to query more than 100MB of data For Office XP and later there is no fixed maximu
55. in will be available in Excel File Locations The MasterMine program and support files should be installed locally on each workstation to be used by a MasterMine user MasterMine s main files typically reside in a Program Files sub tree named MasterMine and containing subfolders Support and Toolkits The installer also includes a number of standard Microsoft libraries dlls which automatically overwrite and self register if older versions of the same dlls are found MasterMine s report workbooks are stored in a location set by preference at the time of installation The default location is under My Documents in a folder called MasterMine Reports For users of GoldMine s dBase versions 6 7 and older standard edition MasterMine workbooks reside a MasterMine subfolder of the selected GoldMine contact set Once created MasterMine reports can be stored anywhere without losing their functionality This makes them easy to transport and share among GoldMine MasterMine users However be aware that a MasterMine share license is required for otherwise unlicensed users to open and use MasterMine workbooks Terminal Services Installation MasterMine may be installed on Terminal Servers including those using such products as Citrix SOL login and database parameters need be entered only once as these are stored in the central MMINI xls file Log into the terminal server as an administrator and
56. install MasterMine as usual and do the following to make the software available to each user 1 Add launch items to the user s GoldMine Menu if desired This may be done manually by copying the FileMenu segment of one installed user s User inr file into those of other users Alternatively for each subsequent MasterMine user log into GoldMine as the additional user then double click on the file MMConfig exe in the MasterMine Support folder This will set up a items and toolbar launch item automatically for whichever GoldMine user is logged in 2 Do the licensing in advance for each GoldMine uset as outlined above or provide the license number in sequence to each MasterMine user so that they may license MasterMine the first time they run it 31 Uninstalling MasterMine s uninstall will remove all MasterMine program files from the machine as they were during installation You may need to delete files or folders that have been created by users or that have been created by the program itself If this is the case delete the application folder called MasterMine to remove any folders in the same tree To complete the uninstall you will need to perform some additional manual adjustments GoldMine View menu references to MasterMine must be removed from the file ournameini in the GoldMine folder using any text editor If other custom menu items exist they would be listed under Filemenu in the int be sure to leave
57. listbox Detail Level 2 Standard Data Fields Y 2 gt 1 Query Summary of records with and without e mail address Select Template In the Template listbox select Description a report by name As you select a report a summaty explanation of the report appears in the display window below The References Section 1 f this man i me ti Sane page 144 of this manual gives you some tips about contents of each report Most names self v C1 Contact v C1 Reseller C1 Dept 1 Al the Tips in th v C1 Company C1 Account Rep C1 Title exp anatory SO SCC 1 in tne next section EM Email Priority CT Product Cl Asst on selecting the most efficient template for the v EM EmailMergeCodes v C1 CreateOn C1 Phone v EM Email Address 01 CiAccountNo C1 Phone2 teports you need v EM Email Contact EM Mime C1 Phone3 v C1 Primary Email EM HTML C1 FAX V C1 Source EM Wrap Lines C1 Ext Select Detail Level Detail level determines the v C1 Contact Type C1 Linked To Contact C1 Ext2 quantity of default selected fields in the field v C1 Status C1 Last Name C1 Ext3 T 2 selection list box below This is memory management feature that is useful mainly with very large databases or on older computer systems Report Name EMal where memory was at a premium SaveTo Path as mm MS In most cases detail level 2 the default is sufficient ium Ru
58. need to drag fields into or out of the Data Area MasterMine reports anticipate the best arrangement of fields to be included in the Data Area given the context of the report As you become a more sophisticated user of MasterMine you may find that experimenting with the Data Area is a tich source of sophisticated information Here our comments on the Data must remain general 95 Suggestion When you first launch MasterMine you need only hit Create without selecting If a field in the data area contains character data the numbers displayed are counts of non null values in that field Because every record in GoldMine contains a value in both the RecID and AccountNo fields these fields are most often used as the default field in the Data Area However sometimes MasterMine uses numeric or date type data to create more interesting results Numeric Fields After dropping a numeric or date field into the data area double click on the field not its contents to define how that field is to be summarized For a numeric field such as Amount in a Sale record you get a Sum of the numeric values in the field by default You can make the pivot table perform more sophisticated calculations by changing this setting to Average Maximum Minimum Product Count of Numeric Items Standard Deviations and Variances You can also cause summed or counted data to show as a percentage of the Row or Column or many other variations Excel provide
59. numbets In your report for summing sorting grouping etc _ Cancel clicking Numeric will apply functions to transform the field as needed New expression edit as desired New Expression may be altered in any way that conforms with the rules of Transact SQL expressions including the use of MasterMine user defined functions If you make erroneous changes such as a syntax error the refresh will fail and the query will revert to its original status without the new field lt 2 Delete dii Delete Field Removes the selected field ie the field on the pivot table that has a cell selected on it from the pivot table s underlying query gt lis Edit HER Edit Query If you wish to alter the undetlying query using MSQuery click the Edit Query button to go backwards through the Microsoft PivotTable and PivotChart Wizard This brings you perhaps surprisingly to Step 3 of 3 of the wizard This is because your pivot table 73 PivotTable and PivotChart Wizard Step 3 of 3 21 Show Stats Layout Options lt Back Next gt Lens already exists along with its underlying query so you will be modifying it rather than building a new one from scratch Click lt Back to open Step 2 of 3 then click Get Data to bring up MSQuery Many users will see a message that says This query cannot be edited by the Query Wizard The Quer
60. of lookups that you have defined for the field in GoldMine If an item appears to be missing it is probably because you do not have a real example of that item in your database r 90 Each field item is counted so we can see that there are 112 Suspects 58 Prospects etc in the database 24 records for which the Contact Type field 15 blank There are nine fields the Page Area of the report available to be used as filters or to be dragged down and displayed the Row or Column Areas of the report To create another simple summaty report you can simply drag another field into the row area and drag the Contact Type field out either to the Page area above or entirely off the pivot table Although the results from this process may seem extremely simple they approximate the result of writing a series of SOL statements on your own minus the wasted hours Matrix Reports A 1 x 1 matrix report is a very simple yet powerful way to segment your database To accomplish the one below drag a second field into the Column Area of your report The result is a table also called a cross tab showing a breakdown simultaneously by both fields Suspect Prospect Customer Past Client Grand Total T this example the database is broken down Contact and Territory Each Contact Type is broken down by Territory in rows and each Territory is broken down
61. of the field changes to black an undocumented Excel featute Drag any field in the table to change the color back Change an Item Name Select an item in a row or column of the table and type a name that reflects its meaning in yout context Once the item name has changed you can identify the original name by 109 drilline down to the underlying data and findin it in the column for the source field Name changes like this remain in place even through data refreshes Retrieve Hidden Page Fields The easiest way to retrieve a field is to find it in the pivot table field list and drag it into your report However another trick can save you time If you know the name of the field you wish to retrieve you may select any page field and type the name of the field exactly as though you were changing the name on the field button Instead MasterMine recalls the hidden field and moves it down Re size Cells to Fit Data Cells sometimes do not automatically re size to fit the data resulting in a display of HHHH signs if columns are too narrow or a table full of space that extends far to the right of the screen if columns atre too wide Also Notes fields tend to be too wide to work with conveniently when placed in the Row Area Hit the Optimize Columns button on the MasterMine ribbon to quickly re size columns fit Likewise for columns on drilldown sheets Optimize Columns is available on the Design ribbon under Tab
62. on Open Causes the report to refresh Target Taskbar MasterMine against GoldMine s data as the report is opening Most effective when database is small enough to allow data poss Main Account Info loading without significant delay Deploy this report with the following preferences Disable Drill Through Prevents the user from double clicking on data items to see underlying data Password to Modify Auto Refresh on open Disable drillthrough Save report without data Save SQL password Save Report Without Data Vastly reduces the size of saved files especially important if file is to be e mailed to another user Also promotes security by preventing storage of database data within the Excel workbook Save SQL Password avoid requiring users to A enter a valid username password combination every 87 time their report refreshes against the SQL database you may elect to save the SQL password with the report IMPORTANT NOTE the SQL password is not encrypted when stored within the Excel workbook so secutity conscious users may wish to avoide saving the SOL password il Snapshot Archive Take a snapshot of the current worksheet with all pivot table attributes frozen This is a great way to create an archived version of the worksheet within the same workbook You may also use this to export the current sheet to a new workbook that can be transferred to non MasterMine users Print Schedule
63. s native password protection for sensitive reports While all MasterMine spreadsheets shareable by default Excel documents can be password protected under SaveTo to restrict users from any access or to read only Finally MasterMine provides convenient ways to restrict at the report level what capabilities are available to users by way of data refreshing query modification and drilldown for detail Setup Procedure Obtain the install file from the MasterMine website www mastermine net from your local GoldMine pattner reseller This install file is the same for demo live versions of MasterMine Entering the license number makes your demo live 1 In order to install MasterMine you must have GoldMine running on the wotkstation being set up Log into GoldMine with the username and password of the person who will be using MasterMine 2 If Excel is open on the machine close it You may want to use Windows Task Manager to ensure that all Excel processes are closed 3 Run the setup file MM6Setup exe from the distribution medium or copy it onto your desktop or into a suitably named folder on your system and run it from there by double clicking on the icon 4 Welcome screen Click Next gt 5 License Agreement If you accept click I accept the terms in the license agreement then hit Next gt 6 Readme Information Read about support and report writing options then click
64. share MasterMine reports is to store them on the same network location or at least the same folder tree for all users The SaveAs location in your MasterMine preferences determines the default location of MasterMine reports The next most common is to use the Share Report button under Deliver on the MasterMine ribbon The process is very simple With the report already created and formatted as desired click the Share Report button and answer the prompts in the dialog See the full description of this dialog under Deliver Ribbon Group on page 69 In GoldMine Corporate Edition version 7 0 and lower the GoldMine taskbar is built to mimic a taskbar in Microsoft Outlook If your taskbars are turned off you can activate them by going to the Window menu and clicking Taskbar You may also distribute reports by attaching them like any other Excel document to outgoing e mails Be aware though that recipients must be licensed MasterMine users or they will not be able to open the file Reports may also be distributed via GoldMine synchronization To do this attach a report as a Linked Document or link it to a page in the GoldMine Knowledge Base Such deployment follows the ordinary rules for linked documents in GoldMine in particular this Files are synchronized to other users NOT every time they are changed but rather each time they are LINKED to a GoldMine record or to the Knowledge Base Keep this in mind when pla
65. table for every one in the other table This is probably not what you wanted so you need to specify link or between the tables in your query as follows Adding or Adjusting Joins Joins are tricky and they can lead to misinterpretation of your data so read closely A Join defines the relationship of one table to another usually through a key field or fields that appear s in both tables To specify a join click on the key field in one table and drag it onto the corresponding field in the other table For example both the Cal and Contact1 tables contain an ACCOUNTNO field Most Cal records are linked to the Contact1 database through this Account number which is unique in Contact and Contact2 for that matter Drag ACCOUNTNO from Cal onto ACCOUNTNO in Contact1 and drop it You have created an Inner Join which means that only records with at least one mate in the other table are included In our example this excludes records for instance GoldMine e mail messages in Cal that are not linked to any record in Contact1 127 ot that are linked to records in different contact sets It also excludes Contact1 records that have no pending activities linked to them The other kind of join is an Outer Join which includes all records from one table and only records in the other that have a mate in the first To see ALL of the records in your main selected table you must specify an Outer J
66. the data have been corrected Then go back to the original Pivot Table and refresh the data to ensure that your corrections are made propetly Exception Reports You can also build reports specifically designed to uncover data exceptions For example by grouping Users according to function and running Pivot Tables that compare user groups against activity codes or date groups you can find records that indicate activities outside the normal process The pre formatted report called Exceptions which is part of the Database Manager s Toolkit provides starting point for this type of report Add new reports to Exceptions xls as you develop them and check them periodically with refreshed data 135 136 Chapter References Appendix A Details Tab Reporting Reporting on Details requires special setup work to ensure that MasterMine reports properly reflect your information GoldMine stores Details as character based data That is even though you may have labelled it in GoldMine as Birth date GoldMine does not prevent you from entering any data not just dates in the Birth date field Querying profiles from GoldMine is especially difficult for most report writers because profile fields are user defined with each field uniquely labeled Being highly GoldMine integrated MasterMine detects the user defined labels for your GoldMine profiles and automatically treats them as though they were regular fields
67. the display Substitute blank space for blank in field items area of the report then hide the Use Logo CAMy Documents My Pictures MM Logo MMsw_BW bmp remaining fields in the Pivot Table Load Behavior Field List Leaving this item Always save SOL password in new reports unchecked produces this result v Always dock toolbar on report open Hide fields list on report open Checking this item causes all page Document visible during refresh on open fields for which is no set default Close Dialog After Report Created selection to be automatically hidden Excel Visible During Creation of Report This produces cleaner teport with many fewer fields on the page Cancel the other hand users need to aware that fields can be retrieved from the Pivot Table Field List at will by dragging and dropping Hide page fields with no valid items Hiding page fields with no valid items provides a less drastic alternative to the previous item It simply cleans up the page area of your report by removing fields that are included by default in the report but for which there is no data in the GoldMine database Such fields serve no purpose in the report Turn off subtotals for all fields By default every field in Excel pivot table has the subtotaling function turned on under the assumption that most reports ate meant to sum and aggregate data In the case
68. the user s username ini file Switch User To add MasterMine functionality for another user on a workstation where MasterMine has already been installed do the following 1 Run GoldMine and log in under the new user s name 2 Use Windows Explorer to navigate to the MasterMine application folder by default it s c Program Files MasterMine and double click MMconfig exe MasterMine installs the view menu items for the new user visible the next time he or she logs in The Report Launch Dialog When you launch MasterMne you see a directory dialog that allows you to quickly locate organize and open your existing MasterMine workbooks treeview on the left displays all remembered locations where you have previously saved MasterMine workbooks both on your own workstation and on the network 33 MasterMine for GoldMine To open any report simply select the desired folder containing the workbook in the left side treeview then double click the workbook itself on the right Sort the files within each folder by clicking on the header of the column you wish to sort by Filename Modified Date Size or Created Date Click again to reverse the order between ascending and descending Folders with MasterMine files Create Open Recently Used Help Gv B MasterMine Reports Sales Reports Marketing Reports Data CleanUp Admin Reports amp Real Reports C MasterMine Reports B Users am
69. them to any other value in the Field3 Version 20 County Field7 VAR Contact 40 Address Preferences screen Field4 Date issue amp amp 10 Zip For instance you may want to change the date designator to the word Date aware that MasterMine will then interpret any profile s field label Tab Name IMMLic 137 ending in Date as a date Next go to the GoldMine profile setup screen Do this by starting to enter a new profile of the type you want to work with then clicking the Setup tab at the top of the dialog Note that in this example Field4 which corresponds to the Zip field in GoldMine s ContSupp table is labeled Date issue amp amp The amp amp at the end of the field label tells MasterMine to treat the contents of the Zip field as dates for the profile called GM Master License With this setup in place a user can create a report on the GM Master License profile grouping Licenses by date ranges of yeats months dates or any combination thereof For any profile record that does not contain a legitimate date in the Zip Date issue whether because it was left blank or because there is a typo that makes the date illogical i e Januaty 34 a dummy value of 1 1 1989 will be substituted Likewise the designator at the end of Field5 field Ext in ContSupp tells MasterMine to return numeric data from the Users field so that we can conveni
70. to change this if you wish to save reports to somewhere other than the default location If you change this setting your report will not appear in the Open MasterMine Report dialog Hit the Create button to generate the report A progress bar will keep you posted on the development of the report MasterMine informs you when your report is done Click OK to finish View Data in Default Layout 8 10 Note that the default table shows projected and probable sales multiplying the probability times the number and amount of sales by month for all data in the file Depending on your monitor settings you may wish to get a better view of your wotksheet by changing the zoom on your Excel toolbar from 100 to 75 MasterMine and Excel are best suited to a screen set for higher resolution at least 1024 x 768 pixels If all data are not visible on the page or some cells contain HHHH instead of numbers try hitting the Optimize Columns button on the MasterMine ribbon to bring them into view 139 11 If all data are still not visible you may want to freeze the column and row heads while scrolling to other parts of the report To toggle this feature on or off click the Freeze Unfreeze Panes button on the MasterMine ribbon Microsoft Excel Sales Pending xls File Edit view Insert Format Tools Data Window Help lt o B A E Man ct a
71. to one of these boxes but since MasterMine is reporting across many GoldMine records each Field in MasterMine is really a container for many such items Field Items in MasterMine are the smallest units of data comprising the answers that get entered into fields in GoldMine In a MasterMine report dragging a Field into the lower area of the report exposes each Field Item contained in the field along with a corresponding number either a count of occurrences or a sum of something numetic like dollar amounts in the data area MasterMine Screen Elements Basic manipulation of MasterMine Pivot Tables is easy and fast but does require some getting used to Active users of this Excel feature are relatively few but developing good pivot table skills can be very helpful in many situations For more in depth discussion of PivotTable functionality we urge you to use the extensive Microsoft Excel help from the Excel menu For many the best way to learn how Pivot Tables function is simply playing with them Most of the data relationships you want to see can be created by simple dragging and dropping Don t worry you won t damage MasterMine spreadsheets you can always close them without saving changes or go back to the basic MasterMine templates to start ovet Most importantly remember Undo In most cases you can undo your last change by hitting Ctrl Z or more slowly by clicking Undo in Excel s Edit menu
72. you selected on the left that have all the keywords you entered To broaden your search click List All Templates at the bottom of the area selection or remove some keywords from the search box then click Search again Toolkits Another way to find an appropriate template is to search by Toolkit MasterMine templates are grouped into job and task related toolkits which contain report templates formatted for specific purposes It is a good idea to familiarize yourself with the templates in the Job related toolkits as they contain many useful reports that you may not have thought of on your own but which may help fulfill role related responsibilities There are two ways to see templates sorted by Toolkit The first is to simply sort the templates in the template search window as described above The second is to use the Templates menu Templates menu If you are already familiar with the available templates and know which toolkit you need to use simply click on the Template menu select a toolkit and see a dropdown list of templates contained in that toolkit Your GoldMine administrator may regulate which toolkits are available to you by removing or adding toolkits from the Toolkits folder Workbook Past Due Pending Activity within your MasterMine application folder Some Toolkits may be This one workbook can be the basis for many useful reports each easily created in a few minute
73. 013 rtrim CX CONTACT rtrim CS CONTAC CX Contact T CX CONTACT CS CONTACT CX Company Rtrim CX COMPANY CX COMPANY Main or Supp CX Contact Main Supp Main Supp CX Last Name Rtrim CX LASTNAME CX LASTNAME rtrim CX DEPARTMENT rtrim CS CON trim CX DEPARTMENT trim CS CON CX Dept Ref TSUPREF TSUPREF CX Title rtrim CX TITLE rtrim CS TITLE trim CX TITLE trim CS TITLE CX Secr Rtrim CX SECR CX SECR udfDBO udfMMPrimaryEmail CX ACC OUNTNO udfDBO udfMMSuppContE CX Email Address mail CS RecID udfDBO udfMMPEmailMergecodes CX ACCOUNTNO udfDBO udfMMSuppE CX Email MergeCodes mailMerge CS RecID CX Phone rtrim CX PHONE1 rtrim CS PHONE CX PHONE1 CS PHONE CX Extension rtrim CX EXT1 rtrim CS EXT CX EXT1 CS EXT rtrim CX MERGECODES rtrim substrin CX MERGECODES mid CS MERGEC CX Merge Codes g CS MERGECODES 2 20 ODES 2 20 rtrim CX ADDRESS 1 rtrim CS ADDRE CX Address 551 CX ADDRESS1 CS ADDRESS1 rtrim CX ADDRESS1 rtrim Coalesce nu CX Address1 iif CS ADDRESS1 is Null CX Address Filled lif CS ADDRESS1 CX ADDRESS1 CX ADDRESS1 CS ADDRESS1 rtrim CX ADDRESS2 rtrim CS ADDRE CX Address2 SS2 CX ADDRESS2 CS ADDRESS2 rtrim CX ADDRESS2 rtrim coalesce su bstring CS ADDRESS2 1 datalength CS ADDRESS2 CS ADDRESS1 space as cii CS ADDRESS1 ascii CS ADDRESS CX Address2 iif CS ADDRESS 1 is Null CX Address2 Filled 1 CX ADDRESS2 CX ADDRESS2 CS ADDRESS2 rtrim CX ADDRESS3 rtr
74. 253 mid OM NOTES 1013 OM Opp ID OM OPID OM OPID OM OMAccountNo OM ACCOUNTNO OM ACCOUNTNO OM OppRecords OM RECID OM RECID OK OKRecType Rtrim OK RECTYPE OK RECTYPE OK Task User Rtrim OK USERID OK USERID OK Task Reference Rtrim OK COMPANY OK COMPANY OK Task Status Rtrim OK STATUS OK STATUS OK Task Priority Rtrim OK STAGE OK STAGE OK Task Begin Date OK STARTDATE OK STARTDATE OK Task End Date OK CLOSEBY OK CLOSEBY OK Task PctDone OK CLOSEAMT OK CLOSEAMT OK OKAccountNo OK ACCOUNTNO OK ACCOUNTNO OK TaskRecords OK RECID OK RECID OD ODRectype OD RECTYPE OD RECTYPE OD Item Rtrim OD FNAME OD FNAME OD Reference Rtrim OD FVALUE OD FVALUE OD Sync substring OD LINKEDDOOC 8 1 mid OD LINKEDDOGC 8 1 iif isdate format mid OD LINKEDDOC 2 3 8 4HHHERHERHP datevalue format mid convert datetime substring OD LINKEDD OD LINKEDDOC 23 8 OD Detail CreatedOn OC 23 8 NullDate OD Linked Doc substring OD LINKEDDOC 47 30 mid OD LINKEDDOC 47 OD Whole Link OD LINKEDDOC OD LINKEDDOC OD DetailRecords OD RECID OD RECID OD Detail Notes udfDBO udfMMStripHTML OD NOTES OD NOTES substring udfDBO udfMMStripHTML O OD Detail Notes2 D NOTES 254 253 mid OD NOTES 254 substring udfDBO udfMMStripHTML O OD Detail Notes3 D NOTES 507 253 mid OD NOTES 507 substring udfDBO udfMMStripHTML O OD Detail Notes4 D NOTES 760 253 mid OD NOTES 760 substring udfDBO udfMMStripHTML O OD Detail Notes5 D NOTES 1013 253 mid OD NOTES 1013 OT OTRect
75. 7472 iflowers minds B Barbara Jones Bartman Company NC Radio Advertising Past Client Aviation Laura SE 12 11 2005 9912134096196LOOTZBar babs mci net 7 Brandon Bates Martinsen NC Magazine Ad Past Client Aviation Bill SE 12 12 2005 AD0120251918 V B brandon martit 8 Kathy Woodworth Premdor Systems FL Customer Referral Past Client Aviation Tammy SE 5 20 2005 97111136295 QNMBGLau B kathy mci net 9 Patricia Phan Qualified Systesm NC Yellow Pages Engineering Tammy SE 4 19 2007 91040329159613033Dav B 10 Rachel Thompsin Ramtron Inc FL Trade Show Suspect Engineering Tammy SE 1 11 2006 A0011332047 3CREQRac_B rachel ramtror 11 Walter Wells Consumer Reclamation Project NC Customer Referral Prospect Engineering Bill SE 8 29 2005 990831006068 GCom _wwells consre 12 Randolph Williams R D Williams Inc GA Magazine Ad Prospect Engineering 10 21 2004 98102330724 P _J 13 Spier Landsource GA Radio Advertising Prospect Engineering Laura SE 7 31 2006 94041300000126900Mar C 14 Donna Ritter Speedy Solutions TN Trade Show Past Client Engineering Bill SE 10 27 2006 A0020160931 K_AV7 B 15 Lance Lawrence Trenton Solutions Group GA Trade Show Suspect Food Laura SE 11 22 2005 991 12432398 _ NGJoh 16 Edward Castelle Uptown Systems NC Customer Referral Suspect Food Bill SE 4 19 2005 A0012841532 IDLR7 B edward uptow 17 Bryan Carlisle Global GA Radio Advertising Suspect Food Laura S
76. A NUMBER 1 0 Coalesce C Null O CA NUMBER1 iif CA duration is CA Probable Amount A Duration 0 100 null 0 CA duration 100 iif CA NUMBER2 Is Coalesce CA NUMBER2 0 Coalesce C 0 2 iif CA duration is CA Probable Units A Duration 0 100 null 0 CA duration 100 CA DirCode Rtrim CA DIRCODE CA DIRCODE CA CreateBy Rtrim CA CREATEBY CA CREATEBY Is CA CreateOn Coalesce CA CREATEON NullDate Null NullDate CA CREATEON CA CreateAt CA CREATEAT CA CREATEAT iif CA ENDDATE Is CA EndDate Coalesce CA ENDDATE NullDate Null NullDate CA ENDDATE CA Last User Rtrim CA LASTUSER CA LASTUSER iif CA LASTDATE Is CA Last Modified Coalesce CA LASTDATE NullDate Null NullDate CA LASTDATE CA LastTime CA LASTTIME CA LASTTIME iif CA ALARMDATE Is CA AlarmDate Coalesce CA ALARMDATE NullDate Null NullDate CA LASTDATE CA AlarmTime Rtrim CA ALARMTIME CA ALARMTIME CA AlarmFlag Rtrim CA ALARMFLAG CA ALARMFLAG Rtrim isnull nullif CA APPTUSER Blue CA Color CA APPTUSER CA ContactFile Rtrim CA DIRCODE CA DIRCODE CA CAAccountNo CA ACCOUNTNO CA ACCOUNTNO CA CARecords CA RECID CA RECID CA Linked OpReclD CA LOPRECID CA LOPRECID iif CH Ondate is null NullDate CH OnDate Coalesce CH OnDate NullDate CH ondate substring datename weekday Coalesce CH OnDay CH OnDate NullDate 1 3 WeekDay CH OnDate CH OnTime CH OnTime CH OnTime CH OnHour substring CH OnTime 1 2 left CH
77. CG ContGrps Group Headers G2 ContGrps Group Members RI Resltems Company Resources 144 GoldMine Database Administrator s Toolkit DBM Toolkit xls Every GoldMine administrator needs tools to clean up the GoldMine database to find errors in data entty to streamline business processes and to clear up training issues In addition to the main reports of the Starter Toolkit he she should use these tools which are designed to help the GM administrator find data exceptions and monitor e mail address accuracy to fax via automated systems like FaxRush to synchronize via GoldSynch etc Suggestions about other administrative tools you d like to see ate welcome at support mastermine net Workbook Name Description GM Tables Summary of records with and without e mail address Optimized E Mail for large databases but does not include C2 user defined fields C1EM E mail addresses linked to contacts and contact2 user defined E Mail with C2 fields Does NOT include records that have no e mail address C1EMC2 E mail addresses linked to contacts and contact2 user defined fields INCLUDES records that have no e mail address May be E Mail with Contact2 slow on large databases C1EMC2 WebSites Summary of records with and without website C1CS Linked Documents Linked Documents plus Contact info LDC1C2 User Log Report Hours logged in GoldMine UL Open query on all Contact records Analysis based
78. CHNotes4 H NOTES 760 253 mid CH NOTES 760 substring udfDBO udfMMStripHTML C CH CHNotes5 H NOTES 1013 253 mid CH NOTES 1013 substring udfDBO udfMMStripHTML C CH CHNotes6 H NOTES 1266 253 mid CH NOTES 1266 substring udfDBO udfMMStripHTML C CH CHNotes7 H NOTES 1519 253 mid CH NOTES 1519 substring udfDBO udfMMStripHTML C CH CHNotes8 H NOTES 1772 253 mid CH NOTES 1772 substring udfDBO udfMMStripHTML C CH CHNotes9 H NOTES 2025 253 mid CH NOTES 2025 substring udfDBO udfMMStripHTML C CH CHNotes10 H NOTES 2278 253 mid CH NOTES 2278 CH Duration Rtrim CH DURATION CH DURATION Coalesce Convert float Nulllf ISDate CH DURATION 1 Convert float Nulllf Char Index S CH SRECTYPE 1 1 convert float Convert Datetime CH DUR iif isdate CH DURATION timevalue CH CH Minutes ATION 1440 DURATION 1440 0 Source MM Field SQLExpression dBase Expression Coalesce Convert float Nulllf ISDate CH DURATION 1 Convert float Nulllf Char Index S CH SRECTYPE 1 1 convert float Convert Datetime CH DUR iif isdate CH DURATION timevalue CH CH Hours ATION 24 DURATION 24 0 Coalesce nullif ISNUMERIC Replace C H DURATION 1 1 nullif charindex S CH SRECTYPE 1 iif CH DURATION Like _ Or 1 Convert Money srectype lt gt S 0 iif CH DURATION Is CH Amount Replace CH
79. DURATION Null 0 val CH DURATION Coalesce nullif ISNUMERIC CH UNITS 1 1 nullif charindex S CH SRECTYPE 1 CH Units 1 Convert Real CH UNITS iif CH UNITS Is Null O val CH UNITS Is CH CreatedOn Coalesce CH CREATEON NullDate Null NullDate CH CREATEON DateDiff day CH CREATEON Coalesce iif CH Ondate is null NullDate CH DaysForcst2Sale CH OnDate NullDate CH ondate DateDiff day Coalesce C1 CREATEON iif CH Ondate is null NullDate NullDate Coalesce CH OnDate NullD CH ondate iif C1 CREATEON Is CH DaysLead2Sale ate Null NullIDate C1 CREATEON CH Last User Rtrim CH LASTUSER CH LASTUSER iif CH lastdate Is CH Last Modified Coalesce CH LASTDATE NullDate Null NullDate CH LASTDATE CH CreatedBy Rtrim CH CREATEBY CH CREATEBY CH Linked OpRecID CH LOPRECID CH LOPRECID CH CHRecords CH RECID CH RECID CH CHAccountNo CH ACCOUNTNO CH ACCOUNTNO iif CH Ondate is null NullDate CH OnWeek Coalesce CH OnDate NullDate CH ondate CS CSRecordType Rtrim CS RECTYPE CS RECTYPE CS Detail Type Rtrim CS CONTACT CS CONTACT CS Detail Ref Rtrim CS CONTSUPREF CS CONTSUPREF CS CSTitle Rtrim CS TITLE CS TITLE CS CSLinkAcct Rtrim CS LINKACCT CS LINKACCT CS CSCountry Rtrim CS COUNTRY CS COUNTRY CS CSZip Rtrim CS ZIP CS ZIP CS eMail Priority Substring CS ZIP 2 1 Mid CS ZIP 2 1 CS CSExtension Rtrim CS EXT CS EXT CS
80. E 7 19 2006 97061337523773096Bre 18 Tyler Morris III Tyler Morris Company Trade Show Suspect Media Bill SE 2 22 2006 AD0022423256 amp SZV_lss C 19 Bellamtin CBS GA Customer Referral Suspect Media Gertrude SE 3 4 2005 A0010528324 F 18 B barry tcbs cor 20 Roger Williams IMAC Industries FL Customer Referral Suspect Media Pete SE 7 13 2004 98071549217 KGA _Rog 21 Marilyn Davidson AFSM Inc FL Customer Referral Suspect Media Gertrude SE 6 27 2005 99062930828 R _ mdavidson afs 22 Venus Markelis Menda Associates GA Radio Advertising Suspect Media Bill SE 9 10 2005 96121604685070566Var B 23 Madison Frank _KMS Inc INC Customer Referral Prospect Media Laura SE 9 18 2005 9909205619496 1A VCar madison frank 24 Monique Kardu Tradewinds Solutions FL Magazine Ad Prospect Media Bill SE 1 6 2006 98072229404 J 7G Mad nique attgloba 25 Judith Martin Barters amp Baubles FL Web Import Past Client Media Bill SE 7 3 2005 96100834813425188Joh B judith b b con 26 Kevin Kaiser Downtown Market Makers SC Other l Pharmaceuticals Laura SE 5 29 2006 AD020731174489 1 B kmk mindsprir 27 Jeffrey Garnett Commercial Partners TN _ Yellow Pages Pharmaceuticals Pete SE 4 27 2007 ADO1245005496W KQ7 jgarrett copart 28 Brett White Gilburn Inc FL Trade Show Pharmaceuticals Tammy SE 3 7 2004 98030936944 V P_GES B bwhite gbp co 29 Brent Dessenberger Marathon Innovations MS Customer Ref
81. ES 1013 253 mid PF NOTES 1013 PF Sync substring PF LINKEDDOC 8 1 mid PF LINKEDDOO 8 1 iif isdate format mid PF LINKEDDOC 2 3 8 4HHHERHERHP datevalue format mid convert datetime substring PF LINKEDD PF LINKEDDOC 23 8 PF Detail CreatedOn 23 8 NullDate PF Linked Doc substring PF LINKEDDOC 47 30 mid PF LINKEDDOC 47 PF Whole Link PF LINKEDDOC PF LINKEDDOC PF DetailRecords PF RECID PF RECID PT PTRectype Rtrim PT RECTYPE PT RECTYPE PT Team Member Rtrim PT CONTACT PT CONTACT PT Department Rtrim PT COMPANY PT COMPANY PT Title Rtrim PT NAME PT NAME PT Role Rtrim PT STATUS PT STATUS PT PTAccountNo PT ACCOUNTNO PT ACCOUNTNO PT TeamRecords PT RECID PT RECID PI PIRectype Rtrim PI RECTYPE PILRECTYPE PI Issue PI COMPANY PI Issue Priority Rtrim PI STAGE PI STAGE PI Issue Status Rtrim PI STATUS PI STATUS PI Issue Start PI STARTDATE PI STARTDATE PI Issue User Rtrim PI USERID PI USERID PI Issue Notes udfDBO udf MMStripHTML PI NOTES PI NOTES substring udfDBO udfMMStripHTML PI PI Issue Notes2 NOTES 254 253 mid PI NOTES 254 substring udfDBO udfMMStripHTML PI PI Issue Notes3 NOTES 507 253 mid PI NOTES 507 167 Source MM Field Name SQLExpression dBase Expression substring udfDBO udfMMStripHTML Pl PI Issue Notes4 5 760 253 mid PI NOTES 760 substring udfDBO udfMMStripHTML PI Pl
82. G LOITA PEE 124 Resort Columns for Drill dw sue 51 sicci t ERR e 125 Add Fields 10 a Query eo eite etd e a SS oet A S e e ete hun 125 Apply SQL or dBase Functions and Expressions 125 Adding or Changing Selection Criteria eee esee teen tenente tnet nenne trennt nne nne 126 Adding Tables hee te E rr RE ie d t Recte EDDA uhaspa 127 Adding orAdjusting Joins ni dd kasama aa e RE Fe O a HIER Condes Plaats 127 Finishing Query Changes and Returning Data eese eene eene 126 Formatting After Query Modific tion iie seii te tenete an ete ite nee ne queo 126 REDIRECT TOA NEW DATA SOUR CE E bo ERE E ec bep HEY 129 MANAGING YOUR GOLDMINE BUSINESS 131 INTRODUCTION TO DATA MINING troie entere eee aree uma uha eene e ak redes ee ee eere usha usai 131 Data Mining Techniques ses ae e Fete ee a eiat een ee VAR n GER ERA YR EE RETE CENE is ss 132 The Art of Pr sentation e dte ete te eee n ete E REESE A SR ERIS 132 DYNAMIC MANAGEMENT REPORTING ccssssssscvensessrscvonsessnscvonsessnssvonsessnsevensesensevenseesnsevenseeesevon
83. ID PK Task Reference Rtrim PK COMPANY PK COMPANY PK Task Status Rtrim PK STATUS PK STATUS PK Task Priority Rtrim PK STAGE PK STAGE substring udfDBO udfMMStripHTML PF Source MM Field Name SQLExpression dBase Expression PK Task Begin Date PK STARTDATE PK STARTDATE PK Task End Date PK CLOSEBY PK CLOSEBY PK Task PctDone PK CLOSEAMT PK CLOSEAMT PK Task Notes udfDBO udfMMStripHTML PK NOTES PK NOTES substring udfDBO udfMMStripHTML P PK Task Notes2 K NOTES 254 253 mid PK NOTES 254 substring udfDBO udfMMStripHTML P PK Task Notes3 K NOTES 507 253 mid PK NOTES 507 substring udfDBO udfMMStripHTML P PK Task Notes4 K NOTES 760 253 mid PK NOTES 760 substring udfDBO udfMMStripHTML P PK Task Notes5 K NOTES 1013 253 mid PK NOTES 1013 PK PKAccountNo PK ACCOUNTNO PK ACCOUNTNO PK TaskRecords PK RECID PK RECID PF PFRectype Rtrim PF RECTYPE PF RECTYPE PF Detail Item Rtrim PF FNAME PF FNAME PF Detail Reference Rtrim PF FVALUE PF FVALUE PF Detail Notes udfDBO udfMMStripHTML PF NOTES PF NOTES PF Detail Notes2 NOTES 254 253 mid PF NOTES 254 substring udfDBO udfMMStripHT ML PF PF Detail Notes3 NOTES 507 253 mid PF NOTES 507 substring udfDBO udfMMStripHT ML PF PF Detail Notes4 NOTES 760 253 mid PF NOTES 760 substring udfDBO udfMMStripHTML PF PF Detail Notes5 NOT
84. J 12 13 C1AccountNo 14 Contact Type Contact Industry Total 15 Dan Jensen Jensen Group Pharmaceuticals Radio Advertising 16 Ida Yates Jensen amp Sons Pharmaceuticals Word Of Mouth 1 ile Sue Puccini McDonnell Manufacturing Engineering Trade Show 18 Total 19 Suspect Brenda Barthalomew Connective Automation Engineering Trade Show 1 20 Dean Champlin Elite Systems Engineering Web Import 21 Dolly Harden Brown Investment Systems Pharmaceuticals Web Import 22 Ellen Sefenaro Praxis Consulting Inc Aviation Word Of Mouth 23 Glen Hillerman Sandor Assembl Media Trade Show 1 24 lan Kendall 25 Jerome Leon Advanced Product Solutions Media Magazine Ad 1 26 Jonathan Stallings Collegiate Systems Aviation Customer Referral 1 27 Karl Yarborough Fenix Associates Aviation Web Import 1 28 Lawrence Kristoff Excellent Objects Inc Food Radio Advertising 29 Marsha Mayfield i Customer Referral 30 Parker Fillman Radio Advertising 1 31 Stephanie Lopez Complete Solutions Engineering Radio Advertising 32 Tanya Lechter Generic Brands Food Trade Show 1 33 Wylie Kalvert Kalvert amp Sons Pharmaceuticals Magazine Ad 1 34 Suspect Total 15 35 Prospect Annette Ambrose Blackhawk Manufacturing Media Customer Referral 36 Brandy Smith Maldensen Products Media Word Of Mouth Sr apt b Annliacdpeemblydpsnsultants TOT Nautica ETT y 1 Lh Drill down Report Another type of Line Listing r
85. MASTERMINE SOFTWARE INC Business Analysis and Reporting for GoldMine MasterMine for GoldMine v7 0 Users Guide BUSINESS ANALYSIS AND REPORTING FOR GOLDMINE MasterMine for GoldMine User s Guide For Distribution with MasterMine Version 7 0 1999 2012 MasterMine Software Inc 4200 Toledo Ave S Minneapolis MN 55416 Phone 651 917 5010 Toll free 877 877 7212 MasterMine software is protected under US Patents 7 185 279 and 7 945 850 All Rights to Software and Documentation reserved GoldMine is a registered trademark of FrontRange Solutions Inc Microsoft Excel Office 97 Office 2000 Office XP Office 2003 Office 2007 PivotTable and MS Query are registered trademarks of Microsoft Corporation All other trademarks are the property of their respective owners Table of Contents IS MASTERMINE RIGHT FOR Y OU a l 13 What Master Mine can do for ann eenean a una aan a te Stas quam een etd 13 Wlio should use MasterMine al g ete ett E ge ou ASSEN ao amu n RR NE kan 13 KNOWEEDGE REQUIREMENTS S OEE ERE ee eee EE eee ves 14 Beginrung MasterMme Usens sei e ette nb n OM D eere x rete eee ee es eben ces dede qae aD e Oe ine oet doeet 14 Intermediate MasterMine USers 2 sois eet cete ret idee an aa n h u usa eo des cech aao San deor dee vele 15 Advanced M sterMin
86. OI COMPANY Issue Priority Rtrim Ol STAGE OI STAGE Ol Issue Status Rtrim Ol STATUS OLSTATUS Ol Issue Start OI STARTDATE OI STARTDATE Issue User Rtrim Ol USERID OI USERID Issue Notes OI NOTES OLNOTES Ol Issue Notes udfDBO udfMMStripHTML OILNOTES OLNOTES substring udfDBO udfMMStripHTML O Ol Issue Notes2 NOTES 254 253 mid OI NOTES 254 substring udfDBO udfMMStripHTML O Ol Issue Notes3 NOTES 507 253 mid OI NOTES 507 substring udfDBO udfMMStripHTML O Ol Issue Notes4 NOTES 760 253 mid OI NOTES 760 substring udfDBO udfMMStripHTML O Ol Issue Notes5 NOTES 1013 253 mid OlNOTES 1013 Ol OlAccountNo Ol ACCOUNTNO OI ACCOUNTNO OI IssueRecords OI RECID OI RECID OC OCRectype OC RECTYPE OC RECTYPE OC InfluencerCompany Rtrim OC COMPANY OC COMPANY OC InfluencerContact Rtrim OC CONTACT OC CONTACT OC Title Rtrim OC CYCLE OC CYCLE OC Role Rtrim OC STATUS OC STATUS OC OCAccountNo OC ACCOUNTNO OC ACCOUNTNO OC InfluencerRecords OC RECID OC RECID Source MM Field Name SQLExpression dBase Expression Project Manager Sub Tables PJ Projects PK Tasks PD Details PF Contacts PT Team PI Issues PC Influencers PJ Project Record Type PJ RECTYPE PJ RECTYPE PJ Project Rtrim PJ NAME PJ NAME PJ Proj Company Rtrim PJ COMPANY
87. OLDMINE GROUP er eere e e ere sa dps eerie eei TOU C Yd 87 ADD TO GOEDMINE TASKBAR n Su ERE o Eee ee ERE EPOR e ERE V Toc qana tenores 87 SNAPSHOT ARCHTVE S Tu nn e ete te estie fepe tees ede da ret rece e re o tied rege ees 88 PRINT SCHEDULER vere esee e E E n Sa sss SSS ter dece qe dentes ede ee eee IU Qu Speo ee cue da 88 S u D 89 MOVING EIBEDS AROUND asss u as ERU fed ERE EE ER C RU LER e EA Eee ds Puede aa s 89 REPORT TYPES ETE 90 Summary Report jue aee e pet A E Y EEE EE EE gel e edi ie I iva E 90 Matrix aiir 01 M lti dimensional MATIS su GO E Ie i p Q Casa 91 Tine LASUNG SQ SE 92 DrlldownRepott sa i t eH Redit qua eum a eat Rma mn RED tdi REN 93 Gliartszand Graphs aono na pape a ett et es etin alte t TREE 94 Multi table Reports and Digital Dashboards eese esee tnen nennen trente enne 95 Data Area iiio eie t d e GR RII ge tette niece da E REG Ed 95 TOOLS amp SKILLS FOR FORMATTING AND ANALYZING uu auiii entente entente ene 96 Combine Rollup Rolldown with Item Grouping eee eese eene 100 GROUPING FIBEDITEMSZ a 101 Grouping Techni
88. OnTime 2 CH User ID Rtrim CH USERID CH USERID Datediff day Coalesce CH OnDate NullD date iif CH OnDate is null CH DaysSince ate getdate NullDate CH OnDate CH Activity Type CH SRECTYPE CH SRECTYPE CH Result Code Rtrim CH RESULTCODE CH RESULTCODE CH Activity Code Rtrim CH ACTVCODE CH ACTVCODE Rtrim substring Ltrim Stuff CH REF Char left iif CH REF Like index oc CH REF 1 200 Charindex oc left CH REF instr CH REF CH Short Reference oc CH REF 1 ShortRefLen 1 CH REF ShortRefLen Rtrim Itrim Stuff CH REF Charindex iif CH REF Like oc CH REF 1 200 Charindex 0c left CH REF instr CH REF CH Product oc CH REF 1 Rtrim Ltrim Stuff CH REF Charindex iif CH REF Like oc CH REF 1 200 Charindex 0c left CH REF instr CH REF CH Reference oc CH REF 1 CH REF substring Ltrim Stuff CH REF Charindex left iif CH REF Like oc CH REF 1 200 Charindex 9o o0c 9e left CH REF instr CH REF oc CH LogUpdate oc CH REF 1 11 1 CH REF instr CH REF 1 Source MM Field SQLExpression dBase Expression trim mid iif CH REF Like 0c left CH REF instr CH REF substring CH REF 15 1 CH REF instr CH REF 3 instr 17 CH LogField Charindex stuff CH REF 1 15 CH REF instr CH REF
89. PJ COMPANY PJ Proj Contact Rtrim PJ CONTACT PJ CONTACT PJ Manager Rtrim PJ USERID PJ USERID PJ Proj Code Rtrim PJ CYCLE PJ CYCLE PJ Proj Status Rtrim PJ STATUS PJ STATUS PJ Proj Stage Rtrim PJ STAGE PJ STAGE PJ Proj Source Rtrim PJ SOURCE PJ SOURCE PJ Start Date coalesce PJ STARTDATE NullDate PJ STARTDATE PJ End Date coalesce PJ CLOSEBY NullDate PJ CLOSEBY PJ Actual End coalesce PJ CLOSEDDATE NullDate PJ CLOSEDDATE datediff day Coalesce PJ STARTDATE PJ Age getdate getdate date PJ STARTDATE DaysFromStartToAc datediff day PJ STARTDATE coalesce P PJ tualEnd J Closeddate getdate PJ CLOSEDDATE PJ STARTDATE DaysFromTodayUnti datediff day getdate Coalesce PJ CLO PJ IEndDate SEBY getdate PJ Closeby date PJ Proj Notes udfDBO udfMMStripHTML PJ NOTES PJ NOTES substring udfDBO udfMMStripHTML PJ PJ Proj Notes2 NOTES 254 253 mid PJ NOTES 254 substring udfDBO udfMMStripHTML PJ PJ Proj Notes3 NOTES 507 253 mid PJ NOTES 507 substring udfDBO udfMMStripHTML PJ PJ Proj Notes4 NOTES 760 253 mid PJ NOTES 760 substring udfDBO udfMMStripHTML PJ PJ Proj Notes5 NOTES 1013 253 mid PJ NOTES 1013 PJ F1 Rtrim PJ F1 PJ F1 PJ F2 Rtrim PJ F2 PJ F2 PJ F3 Rtrim PJ F3 PJ F3 PJ ProjectFlags Rtrim PJ FLAGS PJ FLAGS PJ ProjectID PJ OPID PJ OPID PJ PJAccountNo PJ ACCOUNTNO PJ ACCOUNTNO PJ ProjectRecords PJ RECID PJ RECID PK PKRecType Rtrim PK RECTYPE PK RECTYPE PK Task User Rtrim PK USERID PK USER
90. RE 68 Delete All Worksheets named Sheets seriei 68 IRA nu Pa 68 Delete all drilldown and Log sheets eee eis 69 Hide unused 69 Page Selupi cete oie 69 Deliver Ribbon GYoUp e SS DS o ea e t FP O Sah Sa yuthu masala 69 EE 69 Share Report tte e rr lect 70 AutosRefre h on Opb na EEUU 70 Schedule S A EE us ata a ERE 71 Application Ribbon Group ei e ater rh P dee ep liae e era cease 72 t aee NAR ke o ERE FO ET 72 Active Report Ribbon GrOUp eii t esee lia Rp ae ere rab tee esie Lo RR Per era dads 72 EE 73 SHOW SSIS Ra GEI 74 Active Field Ribbon Group hua an S aa mayu sau h u Sus a Su tene ue eei tet 75 Apply Filter ACross nqa tete ed ntl gre eere Odi PEE DD rere ed E teu 76 Group Ribbon Group oie Hee ete erased umen ted rae a Ear TEDE 76 GErOUpilgs iiit enne duum
91. To do this highlight the entire pivot table including if necessaty some empty cells in the 9 LAURIE A0 NANCY 12 ROB 13 SUSIE 14 Grand Total 20 Onvear 21 OnMonth iy 22 23 ChiRecards 24 OnWeek areas sutrounding the pivot table then copy the area and paste it to the new location on another wotksheet Adding charts is easy and it often 25 2 25 0007 26 3 10 2007 27 3 1 2007 2 17 2007 28 13 18 2007 324 2007 29 3005 2007 3 31 2007 30 Grand Total 161 31 32 23 35 37 makes your report immediately more readable Right click on any chart and select Location from the short menu to plug the chart Y T 2025 2007 IN IAN 302502007 MEG OMNE into a spreadsheet containing other pivot tables or charts Using these skills you can build a sophisticated Digital Dashboard that contains all the key metrics you need to manage your people and your business effectively Data Area Alternatives Your Pivot Table Data area generally shows a count of the number of records in GoldMine that meet the criteria given by the corresponding column and row headings and by filters set in the Page area More sophisticated reports can include summed numeric data such as sales amounts ot even dates in the data area If you start with a MasterMine template you will generally not
92. X MY 178 FOREWORD This manual is designed to give you a quick introduction to using MasterMine for GoldMine MasterMine itself is designed to be a user friendly low skill entryway to your GoldMine data so this manual is meant to assist both novice Excel users who have no desire to develop deep skills as well as those who wish to become true experts The basic functionality everyone must learn to make use of MasterMine should not take more than an hour For those who wish to dig deeper this manual goes on to discuss important and useful concepts for GoldMine managers such as data mining GoldMine database structures and Microsoft Excel spreadsheets and Pivot Tables We hope our explanations are clear and understandable enough to make MasterMine use easy productive and fun even for the most inexperienced Data Miner Howevet this manual by itself cannot provide a thorough knowledge of any of these important management skills We recommend that users seek further information in a variety of resources including online training books on data mining itself the GoldMine Reference Manual and the many off the shelf books on Microsoft Excel The latter are often inadequate with regard to information about Pivot Tables but you can supplement your knowledge by using Excel s built in Help screens Latest Release When significant additions or changes
93. X KEY3 CX KEY4 Rtrim CX KEY4 CX KEY4 CX KEY5 Rtrim CX KEY5 CX KEY5 CX CXNotes udfDBO udfMMStripHTML CX NOTES CX NOTES substring udfDBO udfMMStripHTML C CX CXNotes2 X NOTES 254 253 mid CX NOTES 254 substring udfDBO udfMMStripHTML C CX CXNotes3 X NOTES 507 253 mid CX NOTES 507 substring udfDBO udfMMStripHTML C CX CXNotes4 X NOTES 760 253 mid CX NOTES 760 substring udfDBO udfMMStripHTML C CX CXNotes5 X NOTES 1013 253 mid CX NOTES 1013 CX CreateBy Rtrim CX CREATEBY CX CREATEBY coalesce convert datetime char ascii CX iif isdate format mid CX ACCOUNTNO accountno 17 isdate substring CX acc 2 5 199 datevalue format mid ountno 1 6 CX ACCOUNTNO 2 5 iif left CX ACC 1 substring cx accountno 2 5 NullDat OUNTNO 1 A 200 1 99 CX CreateOn e NullDate CX Owner Rtrim CX OWNER CX OWNER rtrim CX LASTUSER rtrim CS LASTUS CX Acct Last User ER CX LASTUSER CS LASTUSER iif CX LASTDATE Is Null NullDate CX LASTDATE iif C Coalesce CX LASTDATE NullDate C X LASTDATE Is CX Acct Last Modified oalesce CS LASTDATE NullDate Null NullDate CX LASTDATE CX C1AccountNo CX ACCOUNTNO CX ACCOUNTNO CX ACCOUNTNO CX ACCOUNTNO CX CXRecords CX RECID CS RECID CX RECID CS RECID 162 Source MM Field Name SQLExpression dBase Expression
94. a new set of Activity Codes and Result Codes Does your existing data simply go to waste because records did not conform to 116 the new way of doing things This could cause you to lose valuable historical information about the activities recorded in your database With MMUpdater starting with the pivot table itself you can conveniently group or re group your old codes under labels corresponding to your new codes Some other information i e from the Reference or some Contact field may be needed in the pivot table to subdivide the data along the new lines When you have grouped and filtered in your pivot table as necessary to get your data appropriately re grouped drill down and use MMUpdater to mass change the old historical records to the new coding Now you can apply current metrics that go back in time beyond when you actually started using the codes possibly even to the earliest time your company used GoldMine 117 118 Chapter Deploying Sharing and Managing Reports Sharing is vital part of any reporting solution Even a single MasterMine user needs to deploy frequently used reports for easy recall rather than creating reports anew evety time they are needed Because MasterMine gives end users much more flexibility even with the most basic form of each report that is the ability to pivot and drill down you have several options for deployment Each MasterMine report has both the path to the
95. a single wotkbook that combine to tell a story or to serve a reporting need For instance you might have a workbook of Sales reps weekly call reports where each tab in the workbook represents a different sales rep When you load this report each week you might sett the Page field OnWeek on every worksheet to the current week If you have many sales reps this can be a lot of work There is an easier way After setting OnWeek in the Page area on the first worksheet double click on the value you set i e if you set OnWeek to 07 23 08 07 30 08 double click on the cell containing 07 23 08 07 30 08 MasterMine will confirm that you want to apply this setting to all other pivot tables in the workbook with OnWeek in the Page atea and take care of it for you By the way reports on subsequent worksheets need not be cloned from the original sheet They might be reports based on completely different queries The key for this feature to operate is that each pivot table have an identically named field in the Page area Change a Field Button Name or Label Select the field button or item and type a name that reflects its meaning in the context of the current report You may need to select the button twice if the first selection highlights a row or column field s underlying data Do not use a name that is already used elsewhere in the Pivot Table If you do that field will be pulled to the location of the selected field The color
96. able Sale Amount the full amount times the probability of the sale are switched on by default Your report will be automatically formatted specifically for sales analysis though the fields can be easily rearranged to make a multitude of useful reports In contrast to other activity reports which are count based sales reports by default amount based but also allow you to track counts units and probabilities as appropriate Details sometimes referred to as Profiles If you select Details the right side of the MasterMine dialog displays a checklist of the user defined Profiles set up in your GoldMine This is the same list you should see when you right click in your Details tab in GoldMine select New and view the Lookups ES Create New MasterMine Workbook gt Which part of GoldMine s information do you want to see Design New C Use Template for the Detail field C Contacts Main All o you will be reporting on one type of C Activities ado Detail Profile rather than many so check the box Pending ea next to the detail type you wish If only a single H gt History Profile is checked the fields list below will reflect Details all the user defined field labels from the GoldMine IGM Master License setup for that Detail Profile C Cases GoldMine Serial Number TUUM If you don t know how Details and particularly Selec
97. ained in the target GoldMine field This feature is invaluable for aggregating data from many records in to single contact level field i e sale records for a whole year saved into Last Year Sales field Add strings to end of existing field data If the target field is a character field the value from the MasterMine worksheet is linked with rather than replacing the value contained in the target GoldMine field Do not update GM field if source cell is blank If a blank cell is encountered on the spreadsheet do not update GoldMine which would wipe out the value in the GoldMine cell This can be useful if you selected an entire column in MasterMine before using MMUpdater and you are not sure if your selection includes blank values Empty target field for all GoldMine records before starting Use thiswhen updating a field in GoldMine that will be used for aggregate reporting In effect this resets this field to blank for all records before MMUpdater processes Delete records from GoldMine Rather than update a field in the target table you may wish to delete the record entirely This can NOT be used to delete account records from GoldMine but can be used for most other types of records Note that record here refers to a row of information in a GoldMine table typically corresponding for example to a single activity on the Pending or History tabs in GoldMine or to a profile record on the Details tab or an Opportunity reco
98. ams contact PJPTC1C2 Team Members who are GoldMine Contacts not USERS Project Team with Member or manually entered GM Contact info for Team member Contact Info includes full GM contact record PTPJC1C2 Project Issues Issues tab for Projects PJPIC1C2 Project Sales Forecast Pending Sale records linked to projects PJCAC1C2 Project Sales Completed Completed Sales linked to Projects PJCHC1C2 Project Pending Activities Pending Activities linked to projects PJCAC1C2 Project Completed Activities Completed Activities linked to Projects PJCHC1C2 152 Workbooks by GoldMine Table Name MMStandard xls This toolkit 15 designed for use by those familiar with GoldMine table structures to quickly set up custom reports based upon various table combinations Reports work the same as with other toolkits but are named by the GoldMine tables they contain See Adding or Adjusting Joins in Chapter 7 for an explanation of Joins orkbook Name Description GMTables ae Inner Joined missing do NOT appear at all C1C2 Forecast sales linked to contacts and any profile record Forecast Sales amp Contact Counts one of EACH for every occurrence of a match so amp Details Profiles iltering must be done on the page CACSC1C2 Completed sales linked to contacts and any profile record Completed Sales amp Counts one of EACH for every occurrence of a match so Ug Contact amp Details Profiles filteri CHCSC1C2 Pending acti
99. and under Help About MasterMine 11 Indicate whether components of GoldMine are used At setup or by preference parts of GoldMine not being used such as Opportunities Projects or Service can be excluded from the MasterMine dialog MasterMine goes on to complete installation of components A link is added to your GoldMine View menu for launching MasterMine This link will not be visible until the same user closes and re opens GoldMine MasterMine installs this user manual in your local program folder for easy access Call it up anytime using Start Programs MasterMine for GoldMine You may also launch it from the Help menus of the Launch dialog and the Create New Report dialog or from the MasterMine ribbon in Excel Click OK to proceed Set up launch inside GoldMine MasterMine launch item is automatically added to the Goto or View menu GoldMine PE and higher and to the GoldMine taskbar The taskbar item may not be 25 visible until the zex time you log into GoldMine Log out of GoldMine and back in if you don t see the item on the taskbar already For maximum convenience or if you prefer not to use the GoldMine taskbar at all you may wish to add this item to your GoldMine menu to the Customze 0 EIE Toolbars Commands right of Help To add command to a toolbar select a category and drag the command out of this dialog box to a to
100. auch the GoldMine Username penny E current workbook at will An existing taskbar may be Target Taskbar MasterMine selected or a new one created The Caption is the label which will accompany the new icon on the GoldMine Caption Main accountinfo 1 Deploy this report with the following preferences Set security and convenience parameters in the lower p Open frame of the dialog as follows Password to Modify Auto Refresh on open Disable drillthrough Save report without data Save SQL password Auto Refresh on Open Causes the report to refresh against GoldMine s data as the report is opening Most effective when database is small enough to allow data loading without significant delay Disable Drill Through Prevents the user from 70 double clicking on data items to see underlying data Save Report Without Data Vastly reduces the size of saved files especially important if file is to be e mailed to another user Also promotes security by preventing storage of database data within the Excel wotkbook Save SQL Password avoid requiring users to enter a valid username password combination every time their report refreshes against the SOL database you may elect to save the SOL password with the report IMPORTANT NOTE the SQL passwotd is not encrypted when stored within the Excel workbook so security conscious users may wish to avoide saving the SOL passwotd Snapshot Snapshot Archive Take a s
101. ble and select Table Options from the short menu Depending on your version of Excel this dialog may vary somewhat from the image here From this panel you can set your preferences for the Pivot Table you are working with Most selections are self explanatory and all are explained in the internal Excel documentation and help screens We ll point out just a few Format Options Grand Totals for Columns Rows Turns on off totaling for columns and rows AutoFormat Table If an AutoFormat has been applied to a pivot table unchecking this option turns off autoformatting and returns the pivot table to a generic non formatted PivotT able Options xi state Name Subtotal Hidden Page Items Can Format options be used to include or exclude data V Grand totals For columns Page layout pown Then Over from your report by Hiding items within fields in the Page Area This v Grand totals For rows i Fields per column 0 ES can be vety powerful but it can be v AutoFormat table As mone misleadingif you forget that you have ubtotal hidden page items turned it on ot o f f lasers For error values show M Preserve Formatting For empty cells show To see how this feature works check V Repeat item labels on each printed Set print titles the box on the Options panel and hit page the button Right click on a eTa nap ers Hi Totals with field in the Page Area and select Field Data op
102. ble clicking on the field the page area and viewing the highlighted items in the Hide dialog Date Ranges Filtering on a date range is very similar to filtering on any other Page Area item Do this by clicking on the Year Month Quarter Week or other date desired All Pending and History reports in MasterMine automatically contain the OnDate of each activity date the date when the activity is scheduled to occur or has actually occurred respectively grouped into Years Quarters Months and Weeks Selecting a date range requires of course that your report contain these fields to start with Once these items are created you will find altering the selected date range is easier than typing start and end dates You may wish to use a range based on another date from your database To create date range selection fields identify the field containing the data you want to filter Use the technique described below under Date Ranges Group Using Date Fields on page 105 to create your Date unit fields for easy user selection Refresh Data With any cell on the PivotTable selected click Refresh the MasterMine or Options under PivotTable Tools to retrieve current data from the GoldMine database files 98 AutoSort options Sorting By default MasterMine automatically sorts tables alphabetically by the outermost field on the left breaking out each item in the field by the field items to the right of it which are t
103. by Contact Type in columns As one example there are 15 Suspects in the MW Territoty This 1s obviously the simplest kind of matrix report showing one dimension in Rows and another in Columns creating a 2 dimensional cube Note that adding this dimension changes the size and shape of the pivot table so it occupies much more of the spreadsheet If the cells that would be covered by the expanded pivot table contain any information Excel will ask the user whether overwriting those cells is okay Multi dimensional Matrix You can drag mote fields into either the Row or Column areas thus showing more and more detail for each item in the fields already there Adding a second field to the Row Area to the right of the Contact Type field changes the report to look like this 91 Territory Engineering Food Pharmaceuticals Suspect 23 Prospect 25 26 27 Pharmaceuticals 28 System Design 29 Customer Engineering 30 Media 31 Pharmaceuticals 32 Past Client 35 Pharmaceuticals Grand Total Note that dragging in the Industry field allows us now to see each Contact Type item broken down by both Industry and Territory The advantage of seeing this further detail is obvious we see a finer level of detail in out database The disadvantage is that our report now extends beyond the boundaries of the page Continuing to add detail will simultaneously expand the size of the pivot table ev
104. ce 2003 or higher but it works best with newer versions of Office In general it is best to simply Install all components of MSOffice as space considerations are rarely significant on newer machines MasterMine works with GoldMine 5 7 or higher Standard or Corporate Edition and wotks with SOL or dBase GoldMine database files Some features that rely upon Microsoft SQL may not be available to standard dBase users To begin ensure that your MS Office installation includes MS Excel and MS Query For Office 2003 or higher Select Custom Installation when you install Office or re run the Office installer CD and select Add or Remove Features Find Microsoft Query under Office Tools and select Run from My Computer in the setup MSQuery will optionally self install the first time it is used We recommend that you install the most current service release for Microsoft Office soon after it is released You can obtain it from the Microsoft support website at http support Microsoft com at no cost Required Hardware MasterMine software itself occupies very little space either on your hard drive or in memory during operation especially when compared with GoldMine Excel and Windows all of which must run simultaneously for MasterMine to function These components can operate together comfortably in about 512MB of RAM 22 Your teal hardware requirements depend directly upon the size of the data files you
105. ck short menu to further control the folders that are displayed here Set the default folder for your Open Report dialog as well as for the launch dialog itself by right clicking on your preferred folder and selecting Set Default Choose Remove Path if an undesired folder appears in the list say because you saved a workbook unintentionally to the wrong location The deleted folder path will no longer appear in the treeview dialog until another file in that folder is opened or saved by the user Right click on a folder and select Show Sub directories to expand the tree to contain all sub folders of the selected folder To permanently add a subfolder to the tree open any file stored in that subfolder Files List The files list on the right side displays all Excel workbooks found in the folder selected on the left side The list can be easily sorted by filename date last modified size or date created simply by clicking on the appropriate column header If you select a folder that contains many Excel workbooks you do not need to wait for the file list to finish filling in before you click on another folder 34 The files list provides some tools for organizing your MasterMine reports more easily than if you were operating in the open Windows directory dialog Right click on a filename in the file list for a short menu that allows you to open rename or delete the file You can also copy the file path and name to your c
106. cle which is number of days between sale Sales Cycle from Date Lead date and the date account record was created CreateOn for Entered the account Shows count of sales summaries etc CHC1C2 149 Opportunities Toolkit MMOpportunities xls and MMOpportunitiesUnlinked xls GoldMine s Opportunities may be used in different ways depending on the conventions set up within your business Most companies link each opportunity to a contact record so by default MasterMine assumes this is the case However some organizations use Opportunities in such a way that the contact under which the opportunity is linked 15 irrelevant Enable the appropriate one in your preferences see Chapter 4 Preferences page 37 The opportunity manager table OpMer contains a series of sub tables see GoldMine Data Structure documentation In MasterMine these sub tables have the following aliases as seen under GM Tables below In most cases the alias corresponds with the OpMer or recotd type used to identify them in GoldMine Alias Table For Tab C1 Contacti Main Contacts C2 Contact2 Custom Fields CH ContHist History CA Cal Pending CS ContSupp Supp Contacts OM OpMgr Opportunities OK OpMgr Tasks OD OpMgrFld Details OC OpMgr Influencers OT OpMgr Team OP OpMgr Competitor OpMgr Issues Workbook Name Description GM Tables Opportunities Contacts relating to Opportunities OMC1C2 Tasks relating t
107. cted activities in a calendar based format Scenarios A few examples of how to make selections in the Design New dialog If you want a report showing Then select Area Button Record Type Forecasted sales for the coming yeat Pending Sale The past month s calls and appointments History Calls compated to other months Appointments All activity associated with any customer Pending shown in one place History or All except e mail report of custom profile or detail Details Select the name of by any name the profile A list of contacts both main and Main none use supplementary that meet certain criteria Additional filter button Another option for quickly reaching your goal is to use one of MasterMine s built in report templates which are designed to anticipate reporting or specialized query needs that users frequently encounter when working with GoldMine The next section covers the use of these invaluable tools 47 Use Template MasterMine has more than 125 built in report templates each of which instantly branches off to literally thousands of variations as needed Using these templates wisely can get you the results you need instantly to without needing to build every report yourself These templates cover a wide variety of areas in GoldMine encompassing virtually every part of GoldMine s data that you see in the GoldMine product itself Selecting th
108. d reports After choosing a template and making field selections you may save settings under your own user defined template name and recall it at will for more variations later Also easily launch recently used reports under the File menu Office 2007 and Windows Vista Compatibility MasterMine handles new workbook type vatiations under Office 2007 and takes advantage of new features in Office 2007 to make reports even more flexible and back end quety management easier Archive pages Click a button to copy the current page out to a static archive workbook or to another page within the same workbook 6 Ease of use features in Excel Many functions and features requested by our more than 5000 users worldwide including a Search dialog new grouping and add to group dialogs set filter settings across multiple reports in a workbook clean up unused field buttons delete drilldown sheets and Logsheets from MMUpdater save the SOL password automatically in workbooks and much more Auto schedule report printing Submit existing reports to Windows Scheduler to run automatically every day week month MMUpdater enhancements Delete activity ot profile records on a mass basis update Lookups notes blob fields and update Linked Documents MMUpdater now includes virtually every table in GoldMine that users normally access Other ease of use improvements New features in Version 7 0 Version 7 enhancements focus on usabili
109. d or if only one exists for the contact outside vendors etc Field Name Contains Useful For Featured in these toolkit reports Linked To Yes or No if Pending or History record is Distinguishing records that are not tied to All reports including CA and Contact linked to a contact in the currently open the currently selected GoldMine contact CH linked to Contact GoldMine contact set set Postal Zone First digits of zip code Sorting by Sectional Center Facility for Contact reports mailing sometimes for territory splitting PrimaryEmail SQL only Returns the e mail of the E mail lists exporting GoldMine data to All reports using Contact Contact2 supplementary table to basic contact information Field Name Contains Useful For Featured in these toolkit reports Linked To Yes or No if Pending or History record is Distinguishing records that are not tied to All reports including CA and Contact linked to a contact in the current the currently selected GoldMine contact CH linked to Contact2 GoldMine contact set set CUSTOM User customized fields non standard in Including all kinds of customized data FIELDS GoldMine Cal table of pending activities Field Name Contains Useful For Featured in these toolkit reports OnDay Weekday name on which pending activity Building Calendar type tables Calendar is scheduled to occur OnHour First 2 characters of OnTime Summarizing by hour with
110. dDate iif OM StartDate is OM Close Coalesce OM ClosedDate NullDate null NullDate OM StartDate Datediff day Coalesce OM StartDate Nul iif OM CloseBy is null NulIDate StartDateTo IDate OM CloseBy iif OM StartDate is null OM Projected Close Coalesce OM CloseBy NullDate NullDate OM StartDate iif OM ForAmt Is OM Opp Forecast Coalesce Convert Real OM ForAmt 0 Null 0 val OM ForAmt OM Opp Units Coalesce Convert Real OM F3 0 iif OM F3 Is Null 0 val OM F3 iif OM ForProb Is OM Opp Probability Coalesce Convert Real OM ForProb 0 Null O val OM ForProb Source MM Field SQLExpression dBase Expression Coalesce Convert Real iif OM ForAmt Is Opp OM ForAmt 0 Coalesce Convert Real Null O val OM ForAmt iif OM ForProb OM ProbableAmount OM ForProb 0 100 Is Null O val OM ForProb 100 Coalesce Convert Real iif OM CloseAmt Is OM Opp CloseAmount OM CloseAmt 0 Null O val OM CloseAmt OM Opp Notes udfDBO udfMMStripHTML OM NOTES OM NOTES substring udfDBO udfMMStripHTML O OM Opp Notes2 M NOTES 254 253 mid OM NOTES 254 substring udfDBO udfMMStripHTML O OM Opp Notes3 M NOTES 507 253 mid OM NOTES 507 substring udfDBO udfMMStripHTML O OM Opp Notes4 M NOTES 760 253 mid OM NOTES 760 substring udfDBO udfMMStripHTML O OM Opp Notes5 M NOTES 1013
111. debe 81 Pure Alias RUNE e 81 Sort Field and ahua ama s e EFE NE HER OUR SSD a tO Sal as S 81 Clone Reports sinet eC OR DURER er HE OU sag 81 FORMATTING SUBMENU S SS 9 M 0 urs n EO FO GRE DTE ene imb eem ner ite eaa epis 82 Hide Page fields set to show All items 82 Show Page Fields With Hidden Ttems epe eee eed ec degener Galau s au 82 vii Hide Row Field Subtotals 82 WOME Bled non tent tdt A das huu niit ie m 82 Delete All Worksheets named 122 2 2 2 220100000000000000000000 82 Delete worksheets named Log MM DD YYYY a u a busua 82 GROUP EIEED ITEMS DRE e e ERREUR e XE aues FIO E EA 82 UNGROUP un nalan eed cte dte ec eed terc dert dde kahaman ahua 83 SEARCH EIEED ITEMS osea echo re ie Rte vena ARR iby PEE CERE URSUS ERES RUE EE PE RUE ERR RR E SE A uet epus 83 FREEZE PANES ME ER 83 OPTIMIZE COEUMNWIDTHS neo Ste d ebrei ped eds editt im ea b i eed a ees 83 ku aS 83 PIVOT QUERY INFORMATION Na sese eset estate sese sese estate neas 83 G
112. dexed key fields on the main GoldMine screen the same information will appear here and be used to select criteria for your table Now change all page fields except Linked to Contact back to All in order to include all data Note that MasterMine automatically groups the OnDate field into years months and weeks the buttons OnYear OnMonth and OnWeek These buttons can be treated like any other field button by dragging and dropping them into the Row Column or Page areas Drag the field buttons OnMonth and OnYear up to the Page Area drop them and replace them with USERID by dragging the button down to the Row Area Watch the mouse icon to be sure you drop these buttons into the intended areas Now you see all potential sales broken out by user By the OnYear button select 2000 to see only sales projected for the year 2000 broken out by user presumably sales representative If you use the reference field to indicate products drag that field down to the row area and drop it next to the USERID field button Before you drop it watch the mouse icon carefully to ensure that it is in the row area and see how the shaded border between cells indicates which rank in the row area will receive the field If you dropped to the left of USERID the table will show sales counts by product by user If you dropped to the right of the USERID the table will show sales counts by user by product These are very different type
113. do within access limits set by the creator of each report For example if you have a 15 user GoldMine license but only 5 users docked and undocked need to make reports while most users simply open and view standard reports you may purchase a 10 user Share license for the majority of users 21 Site License Users of MasterMine versions earlier than V6 0 could purchase a MasterMine license that matched their GoldMine seat count while saving on the per seat cost To setve these legacy customers MasterMine site license seats may be purchased for an existing site license but new site licenses are no longer sold The site license option gives full MasterMine functionality to all users although access can be limited at installation if desired As a result of the requirement to match GoldMine seat counts as the GoldMine seat count increases MasterMine will cease to function until additional MasterMine site license seats are installed to match the GoldMine seat count Share Site License For ease of implementation MasterMine offers a centrally administered Share Site License which allows all users in GoldMine to open manipulate save and SaveAs existing reports subject to limitations you administer For a single price all GoldMine users who have MasterMine installed and accessible could launch existing reports defined and saved for them by Full users Required Software MasterMine requires MS Offi
114. e parallel to the main contacts as though they were in one big table together Activities Select Pending History or both to report at the activity level One row will be returned for each activity record so these reports are activity centric If you select Activities you have a secondary choice of the type of activities to include like Calls Appointments etc This list corresponds to the types of activities tracked in GoldMine under Schedule or Complete menus and displayed in the Pending and History tabs In the dialog simply 44 check on which types of activities to include in the report If you select multiple types of activity or if you leave the default selection checked on for Pending All for History All except E mail you will still be able to filter or group by Activity Type within your MasterMine report Limit your report to only one ot a couple of activity types only if you wish to permanently exclude other types for instance if you want to create a calling report and know you will not be using this report to compare calling and appointments and other possible contacts with your prospects or customets Sales Reports Selecting Sale only and unchecking all other types of activity produces a sales oriented report such as Forecasted Sales or Completed Sales Fields that relate only to sales such as Potential Sale Amount the full amount in the Amount field and Prob
115. e Users seus um au bau eR Gp ee ct vete mayunta Qan et tete a anam e Od de d 15 NEW FEATURES IN VERSION 5 0 amp 5 L 22 un erecti teret tees EEEN ENESE 15 NEW FFA TURKS TN VERSION O 0 cese tete qaqa epe DER eO ER ee Eee re dp ee Re YR ets 17 NEW EEATURES IN VERSION 7 U 0 Ree re Ore rete e heu 18 GETTING HELP Qu 2 X 19 5 iiie ett e e etae abs conta due em eH e dde dete ti tet de 19 Report Writing Training P se as St 21 sun s 21 Named User Full License 21 Named User Share LiC nS S cccccccecececececececeeecececececeeecseeeseecessesesesesesesesesesseststssstsestsssssesesssseseseseseseseseseseseseseseseseseseeeeeeens 21 unaq ih RI E Em Share Site License s REQUIRED SOBTWARB REOR RE EE pees EE cee REQUIRED HARDWARE a t SSS u SS n SS pon ERU P pees How MASTERMINE WORKS E SECUBITEY uu TRUE SETUBPROGCEDURE Q eme eec tp eee heec eee ve ec heec e cete eee eee heec e cete SET UP LAUNCH INSIDE GOLDMINE c ccccccccccoccece
116. e the item Completed is a report label for the value in the GoldMine Result Code field MasterMine Pivot Table Control Drilldown Stats Drilldown Connection Query Text Security About drilldown work Drilldown From PivotTable to Line Listing Do not format data or headers on Drilldown sheet Drilldown from Excel to GoldMine Show sample of source row fields inside GoldMine Open new window in GoldMine For Found record Note Drildown preferences affect only the currently active workbook 84 Set user preferences to determine how different aspects of Do not format data or headers on drilldown sheet When the user double clicks any Data area element a new drilldown sheet is created showing in rows each record that comprises the element MasterMine adds some formatting to this native Excel process by passing through fieldname and label substitutions the user has added to the pivot table MasterMine Pivot Table Control Stats Drilldown Connection Query Text Security About ODBC DRIVER SQL Server SERVER GOLDMINE VM UID sa PWD APP Microsoft Office 2003 WSID 49931 DATABASE GoldMine Caution IF changes to connection string cause pivot table to become invalid close workbook without saving to recover MasterMine Pivot Table Control Checking this box disables this feature for the current workbook Show sample of source row fields inside
117. e Items Sork Items in Selected Field Simple Refresh Re query the underlying data to refresh report Refresh All Refresh all pivot tables in the current workbook Purge Selected Field Purges the field of inactive items pivot table field remembers all items that have ever appeared in a field Over time adding new data and changing or deleting old data in your GoldMine database can cause the item list in a field to include many obsolete items We recommend purging old values that are no longer valid especially after doing significant data corrections Purge All Purges ALL fields of Inactive Items Report wide purge that for systems with slow processors or in the case of very large databases may take considerable time Sort Field and Refresh Sorts items in the selected field After initial query each new value for a field is added at the end of the list This function re establishes alphabetical order for the selected field Clone Report Creates a duplicate of the current worksheet at the end of the tab row for the current workbook Users are expected to use this function frequently while developing custom data analysis workbooks and dashboards 81 Formatting Submenu MasterMine Refresli 38 Hide Page Fields showing AT Show Pace Fields with Hidden I ems Hide Row Field Subtotals Sort Items in Selected Field Delete all worksheets nared Sheet Delete all Log tabs
118. e appropriate template can help get your desired outcome quickly whether it is a report a dynamic analysis or data management project Template Finder When you check Use Template a selection of MasterMine templates appears The list you see is ALREADY NARROWED to those appropriate for the area of GoldMine you selected on the left Find the appropriate template by browsing through the list As your mouse hovers over each template name you can see the toolkit and a Create New MasterMine Workbook Which parl of GoldMine s information do you want to see Cortacts Main Additional Activities Pending History Details pportunities C Cases C ListAll Templates Select fielcs to include v C1 Cortact v C1 Company CA Actvity Type CA Actvity Contact v CA OnDate CA DaysTill C amp User ID v CA Actvity Code v CA Ghort Neference v Reference Design New Use Template Alarm Calendar Alarms by User All Accounts end linked pending All Pending Faxes Pending Forecast Sales amp Contact amp Details Profiles New Client Sales Pending Next Pending Activity onlu No Pending Ac ivity Opp Influencers Pending 4ctivities Opp Pending Astivities All L on acts v C4 OnWeek v C Duration CA Lest User v Modified v CA C amp AccountNo v CA CA Necords v C1 Linked To Contact v 1 5 v C1 Account Ty
119. e but powerful activity gives you the ability to summarize OR show greater detail in an instant The pivot table at left is an ordinary two dimensional table with one field Region in the Row Area and one field Status in the 393 80 435500 7313141 Column Area This simple report is a clear 4 843 00 1 394 00 11298778 representation of sales broken out by 7 485 00 103 075 01 252 833 55 tegion and by account status 5 943 00 7 317 80 31 006 60 27 797 60 32 115 25 147 644 15 20 805 22 16 091 00 93 257 65 Because there are multiple sales agents 8 747 07 22 384 95 145341 14 operating in each region the user a sales There are many approaches to doing this For instance the manager could drag the region field to the page area and select MW then pull the UserID field into the report This would create view ONLY of the MW region preventing the person from compating it conveniently with other regions Another option is simply to Roll Down the MW field item by double clicking on MW A dialog asks which type of further detail to show for the MW field In the dialog 12 USer IZ ACTIVE reps m 1 BEES Ameis Da the manager selects UserID and clicks 14 15 Amount Status _ i 16 Region v UserlD Active Inactive Dead 17 B2 352 61 6 393 80 4 385 00 131 Now manager has in context 18 MW GAIL 6418 1 100 00 399 00 breakdown of MW UserID that still 19 LAURIE 62 006
120. e repott and to some useful language for talking about it Understanding these terms will help you to make sense of reporting concepts as discussed in this manual as well as to discuss problems and solutions with colleagues and MasterMine suppott staff Terminology Pivot Tables The standard unit of a MasterMine report is a pivot table trademark of Microsoft Corporation A pivot table is an analytical structure built into Excel that allows the user to quickly and easily rearrange and view data from many angles A pivot table is more generically a multi dimensional data cube Users who master the idea of cubes can intuitively understand exactly how moving fields around a pivot table will affect what they see For the rest of us the experience of simply playing with a pivot table more slowly but effectively gives us a feeling for how a pivot table works Pivot tables are extremely convenient for displaying data in any scope converting immediately from a narrow summary to finest detail MasterMine leverages this capability and ties it to the capabilities of GoldMine to produce both a powerful analytical tool and a means of managing people processes and data itself Workbooks and Reports A Workbook is an Excel file that may contain one or many Worksheets The term MasterMine Report may be used to refer to either a workbook OR one of the worksheets within a MasterMine workbook It is therefore clearer
121. e unused filters Remove all fields from the paee area that are not being used to filter the report Fields can be pulled back in as needed from the Pivot Table field list on the rieht side of the worksheet Page setup Set page margins gridlines column widths and much mote in preparation for printing Deliver Ribbon Group Once you have settled upon an atrangement for your report or set of reports in workbook store it in a location where it can be easily recalled by whoever needs it Make it easily launchable with a single click restricted as necessary to prevent loss of data refreshable against the GoldMine database so that users can immediately get information value without having to change settings or manually refresh the data Security Lock down your report so others can t make unauthorized changes either to the report layout or to the parameters and definition of the data that get pulled into it In the Security dialog you can set the following e Disable access to underlying query Prevents a user familier with transact SQL from changing the underlying query so that only the deliberately allowed data can be accessed e Save workbook without data Saves only the report format and the instructions for querying data not the data itself inside the Excel workbook e Refresh on open Sets the report to automatically receive current information at the time the report is opened If a user attempts to open the workb
122. ear of messing something up You can consider this a legitimate expression of the Art of Management you often read about As with any artistic endeavor being technically proficient with the tools and techniques is only the start but it opens up a whole world of satisfying creative opportunities Using the techniques described earlier in this manual you can freely dig around in your data for nuggets of information that tell you about your business We call the process of altering your data and placing it in interesting configurations analysis as opposed to reporting Sometimes you configureyour data in a new way without clearly knowing what you want to achieve but knowing that it ought to reveal something together Suddenly you make an important discovery after the report is done As you ate exploring be sure to periodically save your workbook and copy the current sheet for later use This is very easy with the Clone Worksheet button on the MasterMine ribbon Itgives you a snapshot of your current report allowing you to continue trying alternatives You can collect the new reports thus generated into an aptly 132 named workbook or move them to another existing workbook by right clicking on the tab and selecting Move or Copy Finally don t forget to add charts and graphs to your presentations as these will often give you insight where mere numbers on the page can t Don t assume that the purpose
123. eben du 76 Date Field Functions Ribbon Group reete tete tog eet regie b e be 76 Date Range nana ouo uie a OO Do ee P e tette dee C RC EET YE eee o De te eR irre get 77 Week Grouping us un m u e pt erepti tege tute tane Angina 77 Ae TOM LOGY m o ete prp dup eee nere tegit vede ur bere pe an te su a aa au s 77 Text at lgfle 77 Numeric Field Functions Ribbon Group esee et reae Lore RR tee Rae pes Pese tie 77 THE MASTERMINE DRILLDOWN RIBBON ana aaa enne ias ak uqaqa inana asi Sau asua 78 GoldMine Group da eit e t e a e de edere et ce epe eee aee apawaq aa REIS 78 Pop Record up wea eive qe tiae e de Dei ede eie tee meri pets 79 Edit ACIVIy ea ege A eles ecu tee a 79 MMU pd ater kaun E a M 79 79 Undo en ce a QR 79 THE MASTERMINE TOOLBAR EXCEL 2003 80 REFRESH BI uy ven EE 81 Simple Refresh estie o oe o o OR i debe e ep rte dria re Eb ede See e e ea era Su 61 Refresh All aus ua E a IH Ee DCN De E eie 61 Purge Selected uis pa tuo eri b e a
124. ecords where JOHN was the UserID the person who did the activity which is NOT necessarily the assigned account for the contact do this set up all other fields as normal in the main MasterMine dialog then hit SOL Query to display and edit the query At the bottom of the SOL Query you could add to the existing Where clause something like AND CH Userid This would permanently limit the current report not the next usage of the template which would revert to normal to include only records completed by JOHN Limitations to your tweaking of the SQL query in Transact SQL 1 You may not alter the number or sequence of fields in the query expression 57 2 You may not create an outside join if more than two tables are being joined 3 Generally your query syntax is constrained to that which is readable by MSQuery as it accesses your SQL or dBase data using the applicable Microsoft Data Access Components MDAC ODBC drivers Hit Finish And The Rest Is Fine Tuning When you have specified which part of your GoldMine information you want to see in general and how to filter it if necessary hit the Finish button MasterMine will now extract your selected information from GoldMine gather it into a pivot table object in Excel and present it for your further arrangement and formatting This should take only a few seconds per thousand records queried Progress Box MasterMine displays a
125. ed set of dynamic tables reflecting key company processes updatable at the click of a mouse e Add any GoldMine field to existing MasterMine templates e Easily format tables for formal presentation to colleagues and customers e Develop new spreadsheets from all MasterMine templates making full use of customized fields and data items e Graphically present data using Excel s full native charting functionality Advanced MasterMine Users have the following additional knowledge Thorough knowledge of Excel Pivot Table and other Excel functions Knowledge of MS Query functionality e Ability to use SQL functions for refined querying in MS Query and can do the following with MasterMine Present and analyze any conceivable data relationship by modifying template queries or constructing original PivotTables from GoldMine data e Integrate data from other applications such as accounting order processing production or customer support software e Optimize queries to enable faster refreshing of large source data files New features in Version 5 0 amp 5 1 Version 5 includes a multitude of small feature enhancements and bug fixes but some top features are these 1 Combined Pending History reporting The usual activity level reporting but combines pending and history into a single report even allowing you to limit a report to calls appointments etc or any combination 2 Primary E mail address as a common f
126. eeze Columns Analyze Rearrange ea LA Delete Sheet tab a m gt F Eds T3 ag 7 2 Ly Delete LogSheets A me Hide Unused Page Security Share Snapshot Schedule Open User About List GX Delete Sheet and Logs Filters Setup Report Print Report Manual MasterMine Clean Up Deliver Application ig Refresh All Refresh All Available at any time while a MasterMine workbook is open this ribbon contains functions that apply in any area whether pivot table drilldown or regular spreadsheet The functions are arranged in groups ranging from right to left in the same sequence you would use to create modify and analyze then share or deploy a report Refresh Refresh Re queties the database and returns current data to the selected pivot table or if Refresh All is selected to all pivot tables in the workbook specify a single pivot table for refresh or if the Refresh button appears disabled you must select a cell ON the pivot table 67 JEE E Clone Worksheet Freeze Unfreeze Optimize Columns Field List Delete Sheet tabs Analyze Rearrange Ribbon Group Use this sub ribbon together with the tools in the MMTools ribbon to organize field items fields and worksheets and generally take advantage of the flexibility of your pivot table reports Clone Worksheet Creates a duplicate of the current worksheet at the end of the tab row
127. elp Technical Support Free support for installation and set up issues is available every business day between 8 30 and 5 00pm CST at 877 877 7212 This support does not include normal use training customization ot report development support To report bugs or to inquire about functionality please send e mail to Support mastermine net or visit the Knowledge Base on our website at www mastermine net Report Writing MasterMine Software s services include online report development which can give you the most immediate possible results For the most efficient start have customized templates reports set up for you by your GoldMine Solutions Partner or by MasterMine report engineers See our website or contact your local GoldMine Solutions Partner for details Training Set up and use of MasterMine to generate basic reports requires no special training However advanced reporting and integration of non GoldMine data can be somewhat ttickier Some GoldMine Solutions Partners provide local classes or one on one training in MasterMine Further training is available directly from MasterMine Software Inc including online one on one courses or classroom training for larger groups See our website fot details 20 Chapter Installation Demo The demo allows you to expertence dynamic reporting and analysis on your own data before you purchase The demo works for a limited time and is the same software as the actual lic
128. en The pivot table fields list is not necessarily needed for reports with stable design and for which fields will not be dragged in and out of visibility Hiding the fields list automatically reduces visual clutter when the report 15 opened Note that the list can be opened any time from the Pivot Table toolbar in Excel Document visible during refresh on open Sometimes reports are set to refresh on open reading data from the GoldMine database to make them current while loading rather than waiting for the user to manually click the refresh button Checking this item makes them visible before the refresh operation begins so that the user can see the progress of the refresh the number of queried items appears at the bottom of the Excel window Close dialog after report created By default the MasterMine Create dialog stays in computer memory when it finishes creating your report If you prefer to have MasterMine shut down automatically each time you a report check this box on Excel visible during creation of report Instead of the MasterMine progress message checking this box allows you to see the creation of the pivot table in Excel beginning with the querying of the data including formatting fields orienting them in the report etc Some users may find this view confusing so it is best to leave it off unless you are debugging 42 Chapter Creating New Reports If you ate too impatient
129. ensed product To unlock the remaining toolkits and workbooks you must purchase a MasterMine license and enter it using the register now button on the initial welcome screen You can install and register as many MasterMine installations as you need all using the same demo or setup file On most systems installation should be very automatic and won t take more than five minutes See Setup Procedure on page 24 License Options Each MasterMine software license is associated with exactly one GoldMine master license designated during the setup procedure If you have more than one GoldMine master license determine before you begin which license will be associated with this installation of MasterMine software and have the license number s ready when you call to register MasterMine licensing is structured several ways to allow you the most advantageous and cost effective distribution of reporting and data management capabilities for your company Named User Full License You may choose to license only a few MasterMine users independent of your GoldMine user count Full report creation and opening using capabilities are available to named user licensees Named User Share Licenses At a reduced price additional users who open and use reports provided by Full users can still take advantage of much of MasterMine s dynamism and GoldMine integration functionality Share users are able to do everything a full user can
130. ently group Licensees in regular groups like 0 10 11 20 21 30 etc Non numeric values found in this field will be returned as 0 zero As we ve noted in the Installation Section page 28 you can bypass this setup and get better use of Details in GoldMine by using DetailsPlus an add on product from Solica Consulting LLC In that case with Preferences set to read the DetailsPlus initialization file see Preferences page 37 MasterMine automatically sets up fields with appropriate types and labels 138 Appendix Sample Session Here is a sample of creating and formatting a MasterMine report This example uses the Sales Pending report to give you valuable tips and tricks for use with all MasterMine templates Follow along by duplicating these steps using your own database This will result in a report that looks similar but not identical to the images here After this run through try following similar steps within another report This will give you a good feel for the many possibilities of reporting using these simple MasterMine techniques Create the Sales Pipeline report 1 2 4 5 On the GoldMine View GoTo menu select Create MasterMine Report Click Pending to specify future activities In the list box to the right click Sale to specify only sales records Give your report a unique name like Sales Pipeline Leave Save to as is for now You only need
131. entually making the table very difficult to read Line Listing Reports To create common list listing report simply drag all the fields you need into the Row Area of your report the sequence you need them to appear This kind of report typically shows a single line per row in your query You DO NOT need to drag fields into the report that will have only a single value These fields can be left in the Page Area of the report and the specific value simply selected in the listbox to the right of the field This vastly improves the efficiency of your report as well as creating an explicit heading at the top of the report indicating what is shown below Once you have dragged all necessary fields into your report you can make a choice about which fields to subtotal Typically in this type of report only the first one or two fields in the row area will be left with subtotals Turn off subtotaling for each field by clicking on the field and hitting Subtotal On Off in the MMTools ribbon 92 A typical line listing report appears below This report has five fields in the Row Area with all subtotals turned off except for the first row field and no column area fields Note that the right most column is really the Data Area of the report containing all 1 s because each full row of data is unique in this report 11 wv r
132. eport can be created instantly by simply double clicking on data area number This automatically creates a new worksheet and your data no longer in the form of a pivot table appears in rows going down the page You can think of this report in two ways as a taw line by line listing of the contents of the drilled down part of the pivot table report or as another report formatted differently looking at a segment of data from the pivot table This report shows all rows of your report s underlying query that underlie the double clicked Data Area number Every field from your quety is included in this query with the more interesting fields toward the left of each row and the more technical fields like Accountno and RecordID toward the right om D E Um K 215 State Source Contact Type i CreateOn C1AccountNo 2 Tara Tooley Orthodontic Solutions SC Radio Advertising Suspect Aviation Gertrude 12 7 2005 99120926269 D Lx Tar c tooley amp 2orthoso 3 Elizabeth Roberts Abacor Inc NC Customer Referral Suspect Aviation Tammy SE 3 25 2005 99102131609 4 A elizabethp abz 4 Brooks Barbee Triangle Technology NC Yellow Pages Prospect Aviation Laura 2 22 2006 0022423074 5 llan Flowers Service Plus Machines GA Customer Referral Prospect Aviation Laura SE 2 6 2006 002083
133. erMine QuoteWerks must v H DocType QH AdditionalChargeCode QH ExpectedCloseD ate QH AlternateAdditionalCharge be defined in the same server as GoldMine and QH GrandTotal QH AltemateCurrency opened using a username and password that i accesses both Select fields to include To create reports based on QuoteWerks data select the Templates menu dropdown and click Report Name I WEN SaveTo Path c MasterMine Reports E QuoteWerks Toolkit In the resulting Filter Finish Cancel dropdown list you will find a large selection of reports on Quotes Orders and Invoices each of which is configurable to virtually anything you want to report on in QuoteWerks Each report has a version that shows either Document or Item level analysis and each can be created optionally including linked GoldMine data Licensing Workstations The first time you run MasterMine and any time you run it in demo mode the software gives you the option of entering a valid license for it Obtain a license from MasterMine directly or from your GoldMine Solutions Partner A valid MasterMine license functions ONLY with the GoldMine installation for which it was created If GoldMine licensing changes and this requires a change in the GoldMine master setial number a new MasterMine license must be obtained from MasterMine Softwate Inc website www mastermine net Click License Now
134. erMine Pivot Query Information Display for the current worksheet The MasterMine Pivot Query Display The MasterMine Display Dialog gives technical information about the pivot table you are using and the data query that underlies it You can use this information to better control how your pivot table displays information and to investigate connections between what you see in the report and what you see in GoldMine itself The Display dialog indicates the sources and criteria for the data that were queried to create the PivotTable on the sheet These criteria are set at the time the worksheet is created and may be changed by an advanced user in MS Query via this dialog The Display is useful as a reminder of the source data being analyzed As such it helps prevent misinterpreting reports by giving background information that helps you trace the appearance of certain data in your report back to specific records in GoldMine The Display has six tabs to present different aspects of the pivot table 83 Data Type SQL LA Last Refresh 8 19 2008 4 00 57 PM 18 2004 Records Queried 9 442 19 2005 Query Size 1 180 KBytes 20 2006 CacheIndex 1 of 1 in this workbook 21 2007 Statistics In addition to information about the pivot table overall Stats includes background on the selected pivot field Again this helps a user understand the source of data in the report Here the user can determine the type of underlying data usually SOL or
135. erral Past Client Pharmaceuticals Pete SE 1 24 2005 0020749959 lt 07 30 The order of the columns here was set when you originally created the MasterMine report See Field List Controls on page 53 for instructions on setting the order at the time of report creation These fields can also be re arranged after the report exists See Resort Columns for Drilldown on page 125 Charts and Graphs Any MasterMine report can be converted into a chart simply by clicking on the PivotChart button ku on the Options ribbon under PivotTable Tools This creates a graphic view of the same table you are using on another worksheet in the same workbook 94 The full range of Microsoft Excel charting is available to make dozens of types of charts with coloring and formatting options that run the gamut See Excel help for further information Multi table Reports and Digital Dashboards As your reporting becomes more sophisticated you may develop reports that contain any combination of these styles Your reports might have worksheets that contain multiple pivot tables charts and even cell formulas created to read data from other locations for instance lookups from pivot tables on other worksheets To view the same data in multiple ways on the same worksheet you can copy an entire D Ep G H 1 pup L M N pivot table from one sheet to A OnYesr 2007 z 5 OnMonth Mar 28 User ID another
136. ers of the field in Cal and ContHist where n is a preference set in the MMINI xls This assists efficient loading since the REF fields in these files are 80 and 65 characters long respectively If you need the entire REF field select it specifically on the Fields tab in Expert Mode when creating a report The REF field in History is stripped of the contact reference This reference appears separately in the Contact field e Sales projection reports include calculated fields for probable sales That is projected sales counts and dollar amounts are multiplied by the probability taken from the NUMBER1 field in Cal e The Company field in the CAL database contains either contact or company information according to settings GoldMine It s best to rely on a report that joins Cal and Contact and use C1 Company for true Company information e Field buttons are re named as described in the table in References called GoldMine Data Sources e The DURATION field in Cal and ContHist is interpreted according to context __ format is converted to a decimal number of minutes for easier summary If the first character is a number the value of numeric characters up to the first non numeric character is returned If first character is a string 0 is returned If the field data is null 0 is returned 173 The corresponding field button is named Minutes
137. es in the order selected If you make a mistake simply click Stop Sorting e and begin again You need not select every field that will be included When finished click Stop Sorting and continue 53 ial Show GoldMine Database names You may toggle between seeing local field names and seeing the actual GoldMine database field names under the list view of fields by clicking the GoldMine button Uncheck default fields MasterMine checks a typical selection of fields to include in your report based upon the area of GoldMine in which you are working You may wish to reject this selection and start with no fields selected If so click the Uncheck button To restore the default selection of fields click the check button again 21 Sort unselected fields The default order of fields in the list box is either the order they appear in a typical GoldMine dialog or for custom user defined fields in Contact2 the order in which they were added to the database To make it easier to find a desired field the Sort button alphabetically sorts fields within the table In combination with the Show GoldMine Database names button this allows you to find and include fields using any known name or label Choose a Report Name MasterMine assigns a default name to every report but it makes sense to customize the name you put on every report you create Not only will this protect your report from being overw
138. essfully Workbook Name Description GM Tables Analysis of pending sales including probability schedule summaries and linked to basic client info such as source key Sales Forecast by User fields etc CAC1C2 Analysis of pending sales including probability schedule summaries and linked to basic client info such as source key Sales Forecast by Product fields etc CAC1C2 Sales History by User Analysis of completed sales by user CHC1C2 Sales History Current User ONLY Analysis of completed sales by user CHC1C2 Top Customers by overall Amount sold descending from the Top Customers top Rearrange to see by year month sales rep etc CHC1C2 Pending activities dated before today by user type of activity Past Due Pending Activity and standard contact information CAC1C2 Analysis of sales progress reflected in record of updates to key History Log Analysis fields CHC1C2 Weekly Activities by User Analysis of completed activities by user in selected week CHC1C2 Analysis of records newly added to the database within the New Prospects past 365 days C1C2 All prospects by how recently contacted linked with full contact info Last Contact is most recent call appointment or e mail successfully completed See GM Help for Last Contact On definition Use reports in Activity Analysis toolkit for finer Most Recent Contact distinctions of what constitutes contact C1C2 Prospects not contacted in
139. facilitate the mixing of data from various similar tables The most commonly used as follows CX Contactl and ContSupp Mixed includes main AND supplementary contacts in the same query CX can mean either table because the report overlays addresses from supplementary contacts records where this information is missing but present in the Contact1 record PH Pending and History is a special table name designating Cal or ContHist for reports that pull data from both tables in parallel For instance the PH ActivityCode field pulls data from both tables and presents them as though Pending and ContHist were really one table so your report can combine both and ignore the distinction Field Selection In the list box in the bottom half of the report creation dialog simply check to the left of every field you want to include in your report either as content OR as filtering or selection criteria Think not only of what fields you want to display but also what conditions you want to use to select or sort what will be displayed Obviously your selection of fields determines the data that will be available in the reports you generate from the template you select The more fields you include the more flexible will be the reports you create HOWEVER pulling more fields also requires more system memory so you should select your fields wisely with both eventual usage and system limitations in mind Because you can include fields ju
140. fied name Thereafter user defined templates appear alongside standard templates in the MasterMine template finder MasterMine Toolkits are collections of templates for producing a variety of pre defined reports workbooks each one named for its function and designed to anticipate GoldMine management related information need For instance the Sales Manager toolkit contains templates to generate workbooks like Call Value and Past Due Pending Activities In turn each of these workbooks is capable of displaying the targeted information in infinitely many formats sorts and filters to get at a true picture of your business Database Terms In the modern world formerly scientific terms like database field and query have seeped into the language of ordinary people though usually without full understanding of what they mean MasterMine attempts to make reporting easy for people who know nothing about databases but it is helpful to understand how the technical parts of database structure and usage relate to the more common user understood concepts A Query is a technical instruction to a database specifying the body of data to be pulled from the database into the pivot table for processing In MasterMine queries are in the form of Transact SQL scripts A single Query returns a result set of data also called a cache of data in computer memory which may provide the basis for one m
141. formation in the integration tab in Preferences see page Error Bookmark not defined Profiles that are defined in Details Plus will have D appended at the end of the name For these details the fields list below will show the field labels defined in DetailsPlus rather than the generic fieldnames like CS CSAddress1 etc or the user defined fieldnames from GoldMine s own setup These fields will also reflect the proper field types Character Date Numeric defined in DetailsPlus Opportunities Projects and Cases If you have these options turned on in preferences they are available here on the front of the create dialog MasterMine produces a simple default report for each of these if selected under Design New but the majority of reports for these areas of GoldMine are launched using the Use Template option described in the next section Click Finish when ready Having selected your target GoldMine area you could just hit Finish now to create a wotkbook of GoldMine accounts information This workbook alone could provide you with a multitude of views into your GoldMine database However there are many further refinements available to you Technical Point Table Joins Those familiar with Transact SQL may want to know how MasterMine includes and joins tables For most reports MasterMine queries an Outer join all activities plus their associated contact information if you include only data from the ac
142. fresh Lookups excluding Zip codes than Lookups report LK group members shows all memberships by company or all Group Members companies with membership C1CGG2C2 Company Resources scheduled for usage typically in pending Resource Usage appointments RICA 146 Activity Analysis Toolkit MMActivities xls Activity Analysis templates are account centric reports that focus primarily on Most Recent Activity and Next Pending Activity These views into your database can be used for many purposes but we recommend using them at least to find neglected customers and opportunities missed assignments and well or poorly covered territories Workbook Name Description GM Tables For all contacts shows only most recent completed Last Completed Activity Any type activity or none if there is none C1CH For all contacts shows only most recent non e mail Last Completed Activity Excluding E mail activity or none if there is none C1CH For all contacts shows only most recent successful closed sale Contact information is included for ALL contacts Last Closed Sale including those with NO sales C1CH For all contacts shows most recent completed sale whether closed or lost Contact information is included for Last Completed Sale Closed OR Lost ALL contacts including those with NO sales C1CH Most recent call for each contact or none if there is none Contact information is i
143. g pong A lower detail level gives you fewer fields in your report but speeds data querying and refreshing of your reports and may allow you to load many more records than would otherwise fit into your computer s memory higher level of detail gives you all possible relevant fields in the target data files but may result in slow data querying Detail can be fine tuned by selecting or de selecting fields to be included individually The information box below the detail level indicates the number of bytes per record that will be loaded into memory at the currently selected detail level Multiply this times the number of records likely to be included to determine how much RAM will be required for the repott Select fields to include MasterMine defaults to include a selection of fields for the type of report you have selected However every field in the affected tables including all your custom designed fields is available for inclusion Under select fields to include click on fields you wish to include in your report either as filtering criteria OR for display Each field name is preceded by a two character table indicator which tells explicitly which table the field comes from The most commonly used tables are as follows 50 C1 Contact1 CS ContSupp C2 Contact2 OM OpMgr CA Cal GS Gsites GoldSync Sites CH ContHist UL User Log MasterMine reports include a number of pseudo tables in order to
144. g record CreateOn Appendix G Other Field Contents and Conventions OnDate is pre grouped into Year Month Day and Week groups and appropriately renamed Other Date fields can be similarly grouped by the end user e Dates appear as 1 1 1989 if they are null This enables grouping by month year etc Records appearing under this date are good candidates for data integrity checking Special fields Reports involving an outer join where all records from Cal or ContHist file are included and ONLY those in Contact or Contact2 where there is an ACCOUNTNO match have a field called Linked to Contact A Yes in this field indicates that the target recotd is linked to the selected contact set By default this field is set to Yes in templates if there any linked records at all Report results can be misleading if the user fails to pay attention to this field s setting in Cal and ContHist is parsed into three fields for easier interpreting The first character or SRECTYPE if present denotes the general Record Type The left two characters denote a more detailed categorization so the button is called Record Type Detail The third character of RECTYPE U if unsuccessful is interpreted in the Success Field button See the GoldMine Reference Manual for database structures and internal logic e MasterMine provides a Short Reference field consisting of the first n charact
145. ge button on the Ending at 8 20 2008 MMTools ribbon Indicate your desired beginning and ending date for data to include By and highlight the time grouping s desired If a Es yasa certain number of days like 7 for a week is Days desired for the group only days may be Months selected Hit OK to create new fields for all QUAE highlighted date unit groupings Years Grouping 105 Now you can show ot hide any of your new date sub groups including all records dated before the Starting at date or after the Ending at date Simply uncheck or check them as desired in the dropdown list associated with the date field Date grouping requires that ALL items in the field are of the datatype date not character number or blank The MasterMine query ensures this in most templates by substituting the date 01 01 1989 if the date field is null for a given record The user may set the substitute date in MasterMine s preferences MasterMine automatically creates date groups when creating Pending or History reports The OnDate field is the one used even though activity records contain many dates from which date analysis might be made CreateOn LastModified etc When you group dates to make date ranges be sure to use the approptiate date field Ungroup Field Items Select the group item and click the ungroup button on the MMTools ribbon If the selected item is the only group item in the field the
146. he First Date on the opening screen it will reflect the same date here However there are some additional considerations By default the Last Date is disabled unless you check the associated box DO NOT specify a last date unless you want yout report to permanently exclude newer history items than those on the date you set Remember MasterMine reports are almost always reusable rather than re generating and formatting reports repeatedly you can re open an existing report and refresh it Setting a hard last date will cause future refreshes to ignore new history items On SQL systems MasterMine uses optimized index querying against history records This is important because it speeds up querying tremendously relative to queries against dBase systems where every record must be searched and the date compared to your ctitetia View the SQL Query Menu A technical note for users familiar with Transact SQL As a final step before hitting the Finish button to create a new MasterMine report MasterMine allows you to view and alter the SQL Query that will be built from your selected settings to extract your data from GoldMine If you are familiar with Transact SQL you make certain changes using the SOL Query dialog The most likely purpose here would be to alter one or more field expressions or the WHERE clause of the quety so as to affect record selection For example in a history report you may wish to include only r
147. he first eight fields of the source row Open new window in GoldMine For Found record Note Drilldown preferences affect oniy fhe currently active workbook e Open new window in GoldMine for found record By default drilldown causes the currently displayed record in GoldMine to change to that of the drilled down row potentially losing the user s place in GoldMine This option opens a new contact window in GoldMine so that the user can easily go back to the previous contact Applies only for GoldMine versions 6 x and lower 0 Sort Columns Sort Columns Opens a dialog that facilitates moving columns of data left or right on the drilldown sheet Optionally click Save to make the new column order permanent for all future drilldowns from the same pivot table The MasterMine Toolbar Excel 2003 Excel 2003 does not have ribbon technology MasterMine toolbar like the one below automatically appears in Excel when a MasterMine workbook is created or opened This toolbar contains significantly fewer functions than that which is available in Excel 2007 and higher is a detailed look at the functions built into the MasterMine toolbar 80 Refresh Data The Refresh submenu gives you several choices to refresh your Pivot Table data Li MaskerMine Refresh r Format gt Refresh Data Refresh All Purge Selected Field of Inactive Items Purge ALL Fields of Inactiv
148. he user to specity a view whose labels will be the dominant ones appearing in the Field List Any field that appears in the selected view will be labeled accordingly Fields that are not used in the selected view are assigned the first available label from among other views in which the field appears To better understand these views you can right click on the upper portion of the GoldMine main contact screen and click Select Primary Fields to see a list of the available record type views Click a specific view to see what labels correspond to that view on the GoldMine contact screen Field List Controls Beyond simply deciding WHICH fields to include you may have additional considerations about your field selection At the top of the field list box are several buttons that can aid you in selecting and organizing your query fields The buttons look like this These buttons help you do the following Sort fields for drilldown presentation The order of fields in your query determines the column order in your drilldown screens see page 111 Drilldown for Detail For this reason you may want to sort the included fields in your query before hitting the Finish button to create your MasterMine wotkbook Click on the Sort Fields button then click ONCE on each selected field name not the checkboxes in the sequence you want for them to appear in your drilldown screens As you click fields will rearrange themselv
149. hemselves sorted alphabetically Thus in the example above Contact Type is alphabetical and within it the types of Industry are alphabetical e g Aviation Engineering Food Media Pharmaceuticals Pivot tables must always sort this way That 15 the outermost fields govern sorting hierarchically from left to right for Row Fields and from top to bottom for Column Fields Manual Sort By default when a report is first created every field is sorted alphabetically but its sort setting is Manual That is the user can drag field items to a new order To manually re sott field items click once on a field item then move the mouse to the outer edge of the E same cell until the mouse icon changes to a 4 way arrow Then click and drag the item to a new location anywhere within the same field The new order of items with the field will remain even if the field is dragged out of the pivot table Sort Ascending or Descending To change any field to another type of sorting double click on the field button itself click Advanced and see the sort settings on Manual you can drag items to rearrange them the left side of the dialog Ascending 2 Descending Using Field Select Ascending or Descending to cause the field to automatically sott all field items within it alphabetically The default medium of sorting is the contents of the field itself Contact Type You may also choose to s
150. hin GoldMine your reports can better reflect reality Without grouping the items in your report can only be summarized by values actually contained in the database For example a call report that shows each user s calls broken out by result code might look like this T Result Code 4 2 21 PRO LM1 LM2 Grand Total 2 1 4 1 2 SON iw gt a 26 Grand Total 101 Grouping these items logically allows us to add a great deal of meaning to our repott even though the GoldMine database itself does not contain groupings of users or of Result Codes First we group users by East and West accotding to their areas of responsibility In this case we used Manual Grouping described below Urvveget AII gt Account Rep C1AccountNo Result Code gt UserlD2 v UserID INP Grand Total 25 Grand Total m Oju CG OEE OWE OOK Then we group Result Codes in a logical way by whether the called person was contacted of not so we can better assess the value of our calling efforts S Unvveek AI x 6 Account Rep i ClAccountNo Result Code2 v Result Code 9 No Contact Grand Total UserlD2 UserID v LM1 East e West Eee E QO qo o5 4 CO N GO 25 26 Grand Total e 04 G OFF O CO
151. his might happen if your report uses old data or data from a database other than the one currently being used by GoldMine If you receive this warning check in GoldMine under File Open to make sure your open GoldMine database is the same as the target of your MasterMine Pivot Table For some reports involving pending and completed activities there may be a Linked to Contact field in the PivotTable that you can set to Yes meaning include only records linked to the currently open GoldMine contact set Create and Use GoldMine Groups Built into GoldMine is an ability to process or update GoldMine records in groups from two to two hundred thousand as many account records as you have Some important functions that are enabled by creating GoldMine groups e E mailing campaigns be managed by using GoldMine Groups together with GoldMine s e mail client e Records can be mass updated Contact level only that is Contact and Contact2 fields by using GoldMine Groups together with GoldMine s Global Replace function e Calling lists can be created or pending activities scheduled for users by creating GoldMine groups e GoldMine s Export feature can be used with GoldMine Groups to export targeted segment of records for say mailing or transferring to another database See the GoldMine user manual for help with these functions Note also that MasterMine reports can be based on either GoldMine Filte
152. ield SQL only The e mail address for main contact appears in the field list as a C1 field the same as any other field in the Contact1 main account table Optional MMUpdater Add on MMUpdater allows users to make changes in Excel and push these changes to GoldMine in a way that is synch aware and conforms to GoldMine data access rules Details Plus and QuoteWerks Integration Automatically uses DetailsPlus field definitions when you select Details Profiles on the main report screen You get all fields from GoldMine Profiles available and the ability to display and analyze them as dates or values just like in DetailsPlus Users of QuoteWerks version 4 0 SOL version only now access QuoteWerks only OR QuoteWerks data linked to GoldMine account data For example show all open quotes for records with a Key2 value of Active in GoldMine Add reports to GM Taskbar for 1 button launch From inside any report click the toolbar icon to deploy the report to GoldMine user for easy 1 button launch Even allows you to conveniently set automatic refresh and to disable MSQuery or drilldown New Templates for Activity Analysis and Administration A dozen new templates including the new Activity Analysis toolkit which presents much requested reports on Last Completed Activity Last Call etc Screen HTML from notes SQL only For SQL users whose notes in Pending or History i
153. im CS ADDRE CX Address3 SS3 CX ADDRESS3 CS ADDRESS3 rtrim CX ADDRESS3 rtrim coalesce su bstring CS ADDRESS3 1 datalength CS ADDRESS3 CS ADDRESS1 space as cii CS ADDRESS1 ascii CS ADDRESS CX Address3 iif CS ADDRESS 1 is Null CX Address3 Filled 1 CX ADDRESS3 CX ADDRESS3 CS ADDRESS3 rtrim CX CITY rtrim Coalesce nullif CS CX CITY IIF CS CITY is null CX CITY CX City City CX City CS CITY 161 Source MM Field Name SQLExpression dBase Expression rtrim CX STATE rtrim Coalesce nullif C CX STATE IF CS STATE is null CX State S State CX State CX STATE CS STATE rtrim CX ZIP rtrim Coalesce nullif CS Zl CX ZIP IIF CS ZIP is null CX ZIP CX Zip P CX ZIP CS ZIP substring CX ZIP 1 3 substring Coalesc e nullif rtrim CS ZIP left CX ZIP 3 left iif CS ZIP is null CX Postal Zone rtrim CX ZIP 1 3 CX ZIP CS ZIP 3 rtrim CX COUNTRY rtrim Coalesce null CX COUNTRY IIF CS COUNTRY is CX Country if CS COUNTRY CX COUNTRY null CX DOUNTRY CS COUNTRY CX Fax rtrim CX FAX rtrim CS FAX CX FAX CS FAX rtrim CX FAX rtrim Coalesce nullif CS CX FAX IIF CS FAX is null CX FAX CX Fax Filled FAX CX FAX CS FAX CX Dear rtim CX DEAR rtrim CS DEAR CX DEAR CS DEAR CX Source Rtrim CX SOURCE CX SOURCE CX KEY1 Rtrim CX KEY1 CX KEY1 CX KEY2 Rtrim CX KEY2 CX KEY2 CX KEYS Rtrim CX KEY3 C
154. in OnDate Calendar DaysTill Days between today and OnDate Prioritizing calculating average days until New Client Pending Sales activities are due etc Short Referenc First N characters of Reference field where N is a default stored in the MasterMine ini file MMINI xls Summarizing on Reference field without including 60 characters per record in the query saves RAM All tables with CAL data HasNotes Yes or No if pending record contains Tracking level of activity data entry by All tables with CAL data data in the notes field creator of pending records Potential Numeric dollar value of pending sales Summing pending sale volume Sales Pending Referral Sales Amount Pending New Client Sales Pending etc Potential Units Numeric value of pending unit sales Summing pending unit sales Probable Amount Dollar value of pending sales times probability Weighted Sales projections Probable Units Pending unit sales times probability Weighted sales projections 171 Special Fields cont d ContHist table of completed activities 172 Field Name Contains Useful For Featured in these toolkit reports OnDay Day of the week on which activity took Building calendar type tables History Calendar lace DaysSince Number of days since event occurred Ageing prioritizing activities LogUpdate Designates how many fields were updated H
155. ine data the number of records in the query and memory size of the query The user can also see how many data caches are contained in the workbook and which one is being used by the current pivot table This can be significant if there are memory issues or if the report is a fairly complex one containing many pivot tables with different data sources i e different underlying queries 74 9 10 Title 11 CreateOn All LY All LY Grand Total Potential Amount User ID2 gt User ID Grand Total Statistics on currently selected objects Purge Inactive Items 5 Search Field Content Show Caches Caches Current Workbook Worksheets 3 Pivot Tables 2 Pivot Caches 1 Selected PivotTable Data Type SQL Last Refresh 9 7 2012 4 46 16 PM Records Queried 537 Query Size calculate CacheIndex 1 of 1 this workbook Selected PivotField Display Name Code Field Name Activity Code Field Expression Rtrim CA ACTVCODE Selected Item d Active Field Ribbon Group There is also information about the field currently selected on the pivot table which can help the user trace a value that appears in the report to the field in GoldMine that contains it In the image here the user selected the pivot item Quote Amount within the field Code when calling up the information display The Stats dialog reveals that the GoldM
156. ine field Activity Code has a local name of Code in this report The latter may be a more meaningful label in the context of the current report but it helps to know what field it represents in GoldMine Likewise the item Quote Amount is a report label for the value in the GoldMine Activity Code field These functions apply to the selected field in the pivot table Purge Selected Field Purges the field of inactive items The pivot table field remembers all items that have ever appeared in a field Over time adding new data and changing or deleting old data in your GoldMine database can cause the item list in a field to include many obsolete items valid especially after doing significant data corrections We recommend purging old values that are no longer Search Field Content Search a field for specific elements or words All field items in the group containing the sought elements are grouped and moved to the top of the field containing it This is an excellent way to search through large volumes of data for specific lost items or to efficiently pull together variations on a particular name or character string for processing or reporting MasterMine offers both a simple search dialog and a more advanced one for searches that require wildcards and such See Content Search page 101 75 Apply Filter Across Tabs RollDown Field RollUp Field X Subtotal On Off App
157. ing c1 accountno 1 6 iif c1 accountno is null 1 substring c1 accountno 2 5 1 isdate NullDate datevalue formatiiif left c1 2 Substring c1 accountno 2 5 6 N accountno 1 A 200 mid c1 accountn C1 CreateOn ullDate 0 2 5 left c1 accountno 6 C1 Owner Rtrim C1 OWNER C1 OWNER C1 Acct Last User Rtrim C1 LASTUSER C1 LASTUSER iif C1 LASTDATE Is C1 Acct Last Modified Coalesce C1 LASTDATE NullDate Null NullDate C1 LASTDATE C1 C1AccountNo C1 ACCOUNTNO C1 ACCOUNTNO isnumeric substring C2 ACCOUNTNO 2 C2 Linked To Contact2 1 C2 ACCOUNTNO Is Not Null C2 USERDEF01 C2 USERDEF01 C2 USERDEF01 C2 USERDEF02 C2 USERDEF02 C2 USERDEF02 C2 USERDEF03 C2 USERDEF03 C2 USERDEF03 C2 USERDEF04 C2 USERDEF04 C2 USERDEF04 C2 USERDEFO05 C2 USERDEF05 C2 USERDEFO05 C2 USERDEFO06 C2 USERDEF06 C2 USERDEF06 C2 USERDEF07 C2 USERDEF07 C2 USERDEF07 C2 USERDEF08 C2 USERDEF08 C2 USERDEF08 C2 USERDEFO09 C2 USERDEF09 C2 USERDEFO09 C2 USERDEF10 C2 USERDEF10 C2 USERDEF10 iif C2 CALLBACKON is null C2 Call Back On Coalesce C2 CALLBACKON NullDate NullDate C2 CallBackOn C2 Call Back Freq C2 CALLBKFREQ C2 CALLBKFREQ Coalesce C2 LASTCONTON NullDate iif C2 LASTCONTON is C2 LastContactOn null NullDate C2 LASTCONTOn iif C2 LASTATMPON is null C2 Last Attempt On Coalesce C2 LASTATMPON NullDate NullDate C2 LASTATMPOn Coalesce C2 MEETDATEON NullDate iif C2 MEETDATEON is null C2 Meeting On Nul
158. ins or 15 a comma change the delimiter to some other value such as 827 Check Case Sensitive Search to include only items that match precisely the case of the elements being sought Check Begins with to include only items that begin with the elements being sought It None is selected above only items that do NOT begin with the sought elements will be included You may enter any group name to assign to the group after it is created If a single element is being sought the default name is the element MasterMine searches through all the items in the selected field groups the ones containing the target values under NewGroup and moves this new group to the top of the list Now you can use NewGtoup or whatever name you choose as a selection 104 criterion in the page area You can also leave it in the display area and double click on it to roll up or roll down detail Group On Content Search can find and isolate groups that contain any all or none of the elements you list in the Enter elements box Furthermore you can use wildcards in these elements to get all records that contain some value except for a particular character use as the default wildcard or character string using by default Group On Content Search Example You want to isolate completed Call records that users have coded different ways in the Reference field over time Sometimes they wrote in ABCD sometimes ABXD
159. irst box and clicking paste Shortcuts for multiple MasterMine installations 1 Installing on Multiple Machines You can expedite the process of installing MasterMine on a number of machines with the same non standard INI parameters Do this if 1 youhavea SQL installation with multiple MasterMine users OR 2 you are a GoldMine Solutions Partner and you wish to have clients call you instead of MasterMine when they are ready to license the software In this case update the VARName and VARPhone fields with your own information before installing generally Copy a MMINI xls with your preferred settings into the same folder as the mm5setup exe on the CD desktop or other folder from which you launch it then run the setup as normal MasterMine will detect the presence of your customized MMINI and substitute it for the default one 2 Installing for Multiple Users on One Machine In a site license situation you have as many MasterMine licenses as GoldMine licenses multiple users can use MasterMine on the same machine launching while logged into their own GoldMine account To set up the necessary View menu items after MasterMine has already been installed on the workstation log into GoldMine under the 30 new users username In the MasterMine application folder double click MMconfig exe The next time the user launches GoldMine the View menu will contain the MasterMine launch items and the MasterMine add
160. istory Log reporting works best if all LOG History Log at once and recorded in a history LOG records 175 Use this field to multiple record update LOG records LogField Field whose updating is recorded in a Tracking sales progress and general History Log LOG record in history contact updates LogChange Change that was made to LogField and Tracking sales progress and general History Log recorded in LOG record contact updates CH Contact Person actually contacted Blank if none Seeing who was actually contacted given in history record CH or Person actually contacted Contains Tracking actual contact instead of merely C1Contact field from Contact if there is lead contact from Contacti None given in the ContHist record HasNotes Yes or No if there are notes in the Tracking level of activity data entry by All tables with ContHist data Contact record creator of history record Minutes Duration field converted to a decimal Tracking time on phone time doing Calls Completed Call Value Number of minutes various activities timesheets billing records etc Hours Duration field converted to decimal Tracking time on phone time doing Timesheet Number of hours various activities timesheets billing records etc Days2Sale Days difference between the date of sale Calculating sales cycle tracking followup Sales Cycle OnDate and date the sale record was by sales reps created as a pendin
161. it will be used and to limit the information available to users It can also help optimize the size of a query thus speeding processing and query refreshing Caution Novice users tend to assume that filtering in the Create dialog is the best way to go However remember that as long as your data source is not large enough to make it cumbersome and slow it is frequently much easier and more beneficial in most situations to filter inside the report History First Date filter The simplest way to do this is with the History First Date field that appears below the field list whenever you have selected a report involving the history ContHist table This dialog allows you to choose a starting date after which records are eligible to be included in the report For installations where GoldMine has been in use for many years this can be extremely helpful Howevet note that you can typically do much finer and more flexible date grouping and selecting within the report itself see Grouping Field Items page 101 Don t accidentally make your report too limited by setting date parameters that prevent you from doing worthwhile analysis later say comparing this year s sales rep call Create New MasterMine Workbook File Templates SQL Query Preferences Help GoldMine Pre Filtering Options GoldMine filter Active 3 Use GoldMine Group EHEGESSECPCI I IIIIIIITT ITIZEIHI counts versus last yeat s Fite on Key Val
162. itten when you create a new repott of the same type Copy and Send Reports Outside of MasterMine Sometimes you need to share the results of a MasterMine report with a non MasterMine or even non GoldMine user The easiest way to do this is to use the snapshot feature on the MasterMine ribbon under Deliver to generate a non MasterMine workbook containing the report The snapshot can be attached to an e mail or copied to another uset the same as any Excel workbook 122 Chapter Modify Underlying Query Once you have created MasterMine report you typically finished with SOL expressions for the purposes of that report The rest of your slicing and dicing is handled graphically within the pivot table With a well chosen base query using the pivot table functions gives you many of the same results formerly available only to those who could build a sophisticated SOL quety With this in mind there are often cases where a report could be made mote efficient or updated or easily improved by modifying its underlying query Rather than go back to the report creation dialog and start over it s sometimes better to tweak and existing one For that purpose Microsoft Excel has the MSQuery utility Working With MS Query amp MSQtety is a graphical SQL query builder provided by Microsoft to manage the query that underlies pivot tables With MS Query you can more closely define the data set returned from your GoldMine
163. k Account Rep CONNIE DAN GAIL KEN LAURIE NANCY PAUL PENNY ROB RYAN STEVE THERESA TRISHA VAN AII though it doesn t exist as a field in the database this allows you to treat Region as a field in your report with all the capabilities of a real data field As you learn about grouping field items in the next section consider how the Rollup Rolldown capability combined with this type of grouping creates a powerful interactive tool for executive level management It frees the user to see information summarized in full detail or at any level in between Combine Rollup Rolldown capability with skillful grouping to create components for a digital dashboard that any executive can easily use to comprehend large amounts of data Even if the executive learns nothing else about MasterMine reporting these two skills alone are enough to provide key levers to manage their business through GoldMine Grouping Field Items Grouping items within your report is one of the most powerful and useful features of a pivot table With Groupings you can isolate display or compare not just data elements but whole subsets of data that are meaningful to you and to re use those subsets in a vatiety of ways You can build Groups on the fly in seconds using the following methods One common example is grouping UserIDs by Sales region or division so that even if those users ate not formally grouped or otherwise associated wit
164. lDate C2 MEETDATEOn Source MM Field SQLExpression dBase Expression C2 Comments C2 COMMENTS C2 COMMENTS C2 Previous Result C2 PREVRESULT C2 PREVRESULT 2 Next Action C2 NEXTACTION C2 NEXTACTION iif C2 ActionON is null NullDate C2 Action On Coalesce C2 ActionON NullDate C2 ActionOn iif C2 CLOSEDATE is null NullDate C2 Close On Coalesce C2 CLOSEDATE NullDate C2 CLOSEDATE C2 Contact2 contains your user defined fields Fields are automatically formatted depending on their field type C2 CharacterField RTrim CharacterField C2 CharacterField lif C2 NumericField is null 0 C2 NumericField Coalesce C2 NumericField 0 C2 NumericField lif C2 DateField is null 1 1 1989 C2 DateField Coalesce C2 DateField 1 1 1989 C2 DateField CA Activity Type CA RECTYPE CA RECTYPE CA Activity Company Rtrim CA COMPANY CA Activity Contact Rtrim CA COMPANY CA COMPANY CA COMPANY iif CA ONDATE Is CA OnDate Coalesce CA OnDate NullDate Null NullDate CA ONDATE substring datename weekday Coalesce CA OnDay CA OnDate NullDate 1 3 WeekDay CA OnDate CA OnTime CA OnTime CA OnTime CA OnHour substring CA OnTime 1 2 left CA OnTime 2 iif CA OnDate is null NullIDate CA DaysTill Datediff day getdate CA OnDate CA OnDate date CA User ID Rtrim CA USERID CA USERID CA Activity
165. lated Fields 96 123 173 Change a Field Button Name 109 Change an Item Name 109 Changing Data Connection Strings 85 15 83 134 Conga s Du de 68 81 Column Area ccena 64 176 Column 53 Content Search eee 104 Create MasterMine Report 43 139 19 123 124 Data 64 Data Cleanup eniti tst ttn 135 14 131 132 Ran Gen scu ene 77 Date Ranges tee 98 105 dBase 125 Delete Field sisinio 73 Delete worksheets 68 Demo Limitati ns e tee 21 Detail kevelerien nite trien tentent 50 Details Plus titre tinte 28 DetailsPlus eet trn 46 Digital Dashboard 2 108 Disable data refreshes 86 Disable drilldown 86 Disable drillthrough 70 87 Display Box ertt 134 Jr M 129 Display Bos 83 Display Dialog eee 83 Drill Preferences assetto 79 e 84 Drill Down 14 23 111 134 135 Duplicate Worksheet 68 81 142 Edit Activity 79 Edit Quety nette eerte tte 73 Saa 71 88 178 Field Button ctore 65 Field Tems 65 ete
166. lds as they appear in your Pivot Table Field List and more importantly the order of columns in your drilldown sheets To re sort fields in your query click once on the column header of a field in MSQuery Once it is highlighted you can grab the field with another click and while holding down the mouse button drag the field left or right to another location Add Fields to a Query You may wish to include additional fields in a query for several reasons among them e To include some regular GoldMine fields that were left out of the base MasterMine template include customized fields in Contact2 dbf beyond those distributed with GoldMine originally e To summarize on a date field grouped both in Months Quarters and Years as well as in day groupings like 7 day weeks you need an additional instance of the field order to group In Query just below the toolbars find the box for the table that contains your target field If the table is not present reconsider whether you started with the right template In the list box under that table s name find the target field click and drag it down to the column atea To make any adjustments such as to specify a dBase or SOL expression using the field s name double click the column head and change the field name to the desired expression Apply SQL or dBase Functions and Expressions Once you have added a field to your report you may wish to apply functions You must kn
167. le Tools Set Subtotaling Behavior Select a Row or Column field right click it and select Field in the submenu Indicate Automatic or None to add ot remove subtotaling for the field and click OK Add or Remove Grand Totals Right click anywhere on the table and use the submenu item Table Options Select or de select the appropriate box for Grand totals for columns rows Include Hidden Items in Totals You have the option of hiding page field items in a table By default hidden items are excluded from totals To change this setting for the whole Pivot Table right click on the table and select Options from the submenu Check or uncheck the box by Subtotal hidden page items Format Numeric Field Items Right click a data item you wish to format and select Field on the submenu Then hit the Number button and format the numeric data in the field as desired Working with Notes Notes fields GoldMine special because they are of indefinite length This poses unique problems for reporting which are discussed at length in Appendix E of this user manual 110 Chapter Data Management MasterMine can not only easily creates traditional style reports from your GoldMine data but also can interacts with reports and with the data itself including directly changing and reorganizing the data within GoldMine Here are a few of the key techniques Drill Down Double click on any numeric or date i
168. lipboatd for pasting elsewhere Drag files into any folder listed on the left side so that you maintain a manageable list of active reports under each folder Sort out unused workbooks to archive folders or delete them Launch Dialog Menu Create a new report by clicking on the Create menu The details of this action are covered in the next chapter Open any existing report by navigating to it using a traditional windows directory dialog Click Recently Used to launch a workbook from a list of the ten most recently used MasterMine workbooks in descending order from the most recent With Help you can launch the MasterMine User Manual in pdf format go to the MasterMine website where you can find many resources to help you learn more about MasterMine or purchase support services or additional licenses And finally you can register as a MasterMine user by entering your license number 35 36 Preferences Chapter Preferences Launch the Preferences menu from the MasterMine Launch Create New Analysis Workbook dialog It is not mandatory to change preferences at setup time but you may wish to go through this dialog at least once to familiarize yourself with available options Preferences apply at the workstation level and are relevant to creating reports but not to users who only share reports created by others Initial settings are held in a file called eg MMINLxls in the Support folder in
169. ly Filter Across Tabs Fields in the page ate are used to filter a report For any filter set in the Page area top of the page select the cell containing that filter and click this button to apply the same filter across all pivot tables in the workbook that have the same field in the Page area For example if a sales report is opened and refreshed monthly users may need to go through each tab setting the OnMonth field to the current month to ready the report ready for use With this function set the OnMonth field to May on the first page then click this button to set all other pivot table s to May as well RollUp RollDown Show or hide detail for the selected field Any field that is further broken down by another field to the right rows or below it in columns can selectively roll up or roll down all lower levels of detail Similar to clicking the or next to each and every item within that field these functions provide a convenient way to show only as much detail as is needed while leaving greater detail immediately available Subtotal On Off Toggles subtotaling for the selected field Group Ribbon Group Group selected items Add to group Ungroup Grouping is key set of functions for managing analyzing and reporting on your database Grouping is explained in depth further below on page 101 The ribbon buttons provide enhancements to native Pivot Table functionality to help you ma
170. m any other kind of report that would contain more than one row per GoldMine account Once you have created the group switch over to GoldMine itself The Group you created is sorted under the group code by default MM some users like to use the date to help identify groups that might be kept for a long time and may be activated using normal GoldMine procedures 113 MM Updater File Edit Help There are many potential uses of groups in GoldMine You now have a capability that makes creating them far easier and faster even without technical knowledge MMUpdater The combination of MasterMine to build GoldMine Groups and GoldMine s built in Global Replace capability is powerful but limited You can use it to modify data only at the account level Sometimes you need to update pending or history activity data data in your custom profiles or data in your opportunities or projects MasterMine offers an optional component to handle this need which also makes it even easier to modify Contactl and Contact2 data in a single step If your GoldMine administrator has licensed you to use MMUpdater and you have Master rights as a GoldMine user you can use MMUpdater to mass update records in almost any GoldMine table Remember Always back up GoldMine data before making mass changes It is much easier to restore a database from backup than to recover lost or damaged data record by record On any drilldown sheet use ordi
171. m size to Pivot Table cache memory The maximum size is usually limited only by the amount of available memory on your computer Data Intersections Column Fields and Row Fields For Office 2003 and below your Pivot Table limits the number of fields you can put simultaneously in the Row and or Column areas of your report There is NOT a fixed limit on the number of fields however The limit is set by the product of all unique items in each of the fields in the row or column area This limitation is much less significant for later versions of Office As long as the data in the page area the limitation is primarily a function of RAM However once they are brought down into the Pivot Table Row or Column Area the data start running into these pre defined limits The key issue is the number of data intersections that are set up Suppose for example you add three fields to the Row area of your report and each of these fields has 100 possible values unique items within it There are then 100 cubed 100 3 possible combinations or 1 000 000 intersections With Office 97 or Office 2000 Excel creates a memory location for each possible combination of these values because any given record might have any combination of these items in it In the Row area your pivot table is limited to 2 1 billion intersections In the column area the limit is 32 768 intersections With Office XP and later Excel holds these intersection
172. nage groups and group names across MasterMine tabs The new Add to group function in MasterMine version 7 provides an important convenience when adding an item that was overlooked during a previous long manual search through a list for items belonging together in a group Date Field Functions Ribbon Group Date functions make it easier to group and create various date centered calculations using any date field in GoldMine 76 Date Range E Fiscal Year Week Grouping Si Age from today pan Text as date Date Range Convert any date field into a convenient set of fields like year month and date from which calendar groupings can be easily made or filters or well grouped month by month or quarter by quarter reports See the extended discussion of Date Ranges below on page 105 Fiscal Year Converts any date field to return the fiscal year within which that date falls Select the date field that will be the basis for the fiscal year field Click the Fiscal Year button and specify the first calendar date of each year s Fiscal Year A new field is created accessible by dragging it into the report from the Pivot Table Field List dialog Week Grouping Creates a new field derived from the selected date field which contains all weeks from the earliest to the latest represented in the queried date fields If DateField is the base field the newly created field will be named DateFieldWeek
173. napshot of the current worksheet with all pivot table attributes frozen This is a great way to create an archived version of the worksheet within the same workbook You may also use this to export the current sheet to a new workbook that can be transferred to non MasterMine users Schedule kant Schedule Print Uses Windows Scheduler to schedule a report to automatically print while unattended On a pre set schedule the report automatically launches refreshes and prints to the designated network or local printer Enter Print Schedule For Mastermine Report Orts be scheduled to run weekly Of monthly Schedule the current worksheet or the whole workbook to print on a regular basis Weekly computer on which the item is scheduled must be left on during the time of printing If a network printer is to be called be sure that the Windows user on the Monday Thursday Saturday scheduling computer the one where the schedule Tuesday Friday Sunday item is set up has administrative access to the Wednesday selected network printer Monthly Print Current Worksheet Option C Entire Workbook Copies Printer Schedule Task Cancel 71 a Home R eport User Manual About MasterMine Insert 2 Add Field Delete Edit Field Query Active Report Show Stats Page Layout Purge Inactive Items Application Ribbon Gro
174. nary Excel processes including simple typeover drag fill find replace cell formulas etc to change data in any cell Typically changes like this will be made in a single column at a time When finished making changes for a column highlight the entire column OR only the changed cells containing data you want to push into GoldMine The selected cells need not be in contiguous rows since you can use E3 Ctrl click to highlight cells one at a time or Ctrl drag select to add groups of cells to the highlighted set MM Updater will With cells highlighted click MMUpdater on the MasterMine update the data in one GoldMine field for each record found in the 19 selected rows Drilldown ribbon Update existing data in this GoldMine table Contact1 Up date exis ting data in this GoldMine table Select the Use this MasterMine column to match AccountNo or RecordID of target records CHAccountNo 5 v target GoldMine table to update Tables are labeled with both a user friendly name and the technical database table name Replace the contents of this GoldMine field swith the contents of Activity Code H RecordID of target records A MasterMine report field this MasterMine column Options Add numbers to existing Field data Add strings to end of existing Field data Do not update GM data if source cell is blank Empty target field For ALL GoldMine records before starting Delete records from GoldMine
175. nclude HTML coding only text is displayed Formatted drilldown data Change field names or field items in your pivot table as easy as typing over the original so that changes follow through to drilldown sheets New Search Grouping options In addition to grouping on and of several elements contained in a row field s items new options include grouping those that contain none of the elements listed and allows the use of wild cards Greatly improves onscreen grouping ability and therefore improves data segmentation and formatting 10 Management of Background Excel New Display box on MasterMine toolbar in Excel allows user to see undetlying quety change connection string elements and quickly investigate data soutce info New features in Version 6 0 Version 6 includes a long list of enhancements which can be viewed in detail on our website www mastermine net Here are the top 7 Simpler Report Builder dialog Users will find it even easier to go from I need a report that does x to actually having the report in seconds simpler cleaner dialog makes choices clear and easy Template finder and many more templates Find needed templates from more than 125 pre designed reports by keyword with full description and context provided in advance Each template is the starting point for thousands of immediately available variations Save new templates launch recently use
176. ncluded for ALL contacts including Last Completed Call those with NO calls C1CH Most recent appointment for each contact or none if there is none Contact information is included for ALL contacts Last Completed Appointment including those with NO appointments C1CH For all contacts shows only most recent completed call or Last Completed Appointment or Call appointment or none if there is none C1CH For all contacts shows all Pending activity for each Pending Activity for All Contacts account or Blank if none C1CA Pending Activity except E Mail for All For all contacts shows all Pending activity except e mails Contacts for each account or Blank if none C1CA Next Pending activity for each contact record or None if Next Pending Activity only All Contacts none exists C1CA Alarms for all pending items organized into a calendar Alarm Calendar format CAC1 All pending items organized by UserlD Report defaults to Alarms by User show only those with alarm 1 147 Sales Manager Toolkit SM Toolkit xls Sales Managers need to monitor every aspect of their sales force s efforts to report to THEIR managers in order to train coach identify opportunities and successful techniques and share them to motivate and discipline the sales team These workbooks and the ones available in the more advanced Sales Tracking Toolkit give Sales Managers the ability to easily get the necessary information to do their jobs succ
177. nction of the form udfDBO udf MMStripHTML CS NOTES For users of dBase based GoldMine Standard edition no such filter is possible However we recommend turning off the HTML feature in GoldMine for any notes field you intend to use in reports Remember there are notes fields in several different tables Contact1 ContHist Cal and ContSupp To turn off HTML coding and thereby leave only text in your notes fields add the following lines as appropriate to your GM INI file in the GoldMine section HTML CAL Notes 0 HTML CONTHIST Notes 0 HTML CONTACT Notes 0 HTML CONTSUPP Notes 0 This will disable HTML notes for whichever tables you include in the list you need not do all four Remember this will affect only newly saved notes entered after you make this change When finished editing GM INI log into GoldMine again All future notes you create will be without HTML 170 Appendix F Special Fields In addition to fields loaded without any formatting a number of important expression fields are included for more penetrating analyses Fields of detail level 4 are included only if pre defined as part of a report or if you expressly select them on the tab Fields Used in expert mode They can all be added manually if necessaty after a report exists by going to MSQuery and adding them to the query Contact main table containing basic contact information contact if Primary is designate
178. ng GoldMine users Another way to put it is Who needs reports Answer Anyone who is responsible for the quality and quantity of workflows that are reflected in GoldMine data should have a licensed copy of MasterMine available Anyone responsible for producing measured output GoldMine is a workflow management tool and that makes MasterMine a tool for anyone using GoldMine to increase the efficiency of their daily activity For example sales representatives responsible for making a certain number of calls or appointments can record their results in GoldMine and can measure their success against standards using MasterMine Managers with MasterMine can measure and rewatd or punish ordinary users can do better by self managing to expectations because they know how they are doing at every step of the way Anyone needing questions answered Is MasterMine only for doing sophisticated analysis Hardly Anyone who has asked for information from GoldMine and waited hours days or weeks while someone else builds a report NEEDS MasterMine to get their own quick answer Yes sophisticated reports are possible but they are not the only reason to use MasterMine The person who asks questions knows what he or she needs for an answer and often this requires deeper knowledge of one s own business that only the questioner has Knowledge Requirements This manual presumes that MasterMine users have at least the first level of knowledge described below
179. ng in the MSQuery environment Even if you are such a user note that MSQuery has important limitations that may prevent using syntax that works in other situations It 1s often best to use the graphical interface rather than typing changes directly into the SOL text In this way the most MSQuery compatible syntax is automatically inserted If you find that something you ve done really should work but doesn t paid support is always available from MasterMine to get you unstuck Modifying Your Query Following is a series of functional instructions to achieve specific results with MSQuery that can t be achieved any other way We cannot provide a complete guide to using MSQuety although help is available directly from Microsoft Formal MasterMine training at the higher levels includes significant work with MSQuery in order to enable users to achieve almost any report configuration imaginable Accessing MSQuery 1 With your cursor anywhere on a PivotTable click Edit Query on the MMTools ribbon 124 2 Click Back and then Get Data 3 You may encounter an error that says Query Wizard is unable to open the query or something similar Click OK This opens MSQuery and contains the data previously queried Once MSQuery is loaded you can do any of the following Resort Columns for Drilldown The order of fields in query is significant in several ways Sorting fields within your query affects the order of the fie
180. nked to Contacts toolkit turned on Likewise turn on EITHER Projects Linked to Contacts or Projects Unlinked to Contacts but it is unlikely you will use both Integration Preferences Integration is covered under setup in Chapter 2 Please see Integration with GoldMine Add on Products on page 28 Compatibility Preferences Since the release of Microsoft Office 2007 not all Excel workbooks are created equal For optimum use of MasterMine store Office 2007 workbooks in a new format that enables background macros extension xlsm This allows MasterMine workbooks to take advantage of much higher memory limits and field item count limits than before Once created these reports may be difficult to share with users of Office 2003 and earlier While it is possible for users of Office 2003 to acquire a free add in from Microsoft that Preferences General Integration Compatibility allows opening and reading xlsm files full compatibility between versions is not possible If you have Office 2007 or higher compatibility with earlier versions is optional Saving Pivot tables that use the higher memoty limits a file in Office 2007 format may render it unusable by those with Office 2003 or earlier of Office 2007 become invalidated when Always save in Office 2003 or earlier format xls safer for sharing opened in other versions Always save in Office 2007 format xlsm most f
181. nly Sale records in the Cal Database that are scheduled to occur before the end of 2001 Add two criteria as follows Field RECTYPE OnDate Operator Equals is less than or equal to Value S 12 31 01 126 Complex Example If you want to limit your query in ContHist to include only sales of more than 10 Units enter as follows Field if ContHist UNITS is null 0 val ContHist UNITS Operator is greater than Value 10 The dBase expression is necessary because you need to make a numeric comparison with Units which is a string field As a string 2 evaluates as greater than 10 Also because UNITS may be null in some cases the val function will not interpret it without special handling Adding Tables MasterMine provides templates for all key GoldMine database files most useful combinations If you ate building a report from scratch careful selection of your template makes this step unnecessary However if you already have a report you wish to modify or you wish to include dbf files from outside GoldMine here s how to do it Click on the menu Table Add Tables Select the table you wish to add even if it is outside the currently selected contact set and click once on the Add button Even if you don t see it yet you have already added the table Drag the Add Tables box to the side to check Now hit the Close button Your query now includes one record in each
182. nning an enterprise wide distribution scheme Opening Existing Reports MasterMine reports are saved in a way that requires them to be opened using the licensed MasterMine application Even though MasterMine reports are stored in Excel workbooks they are protected from viewing or manipulation by unauthorized users Attempting to open a MasterMine report directly in MS Excel results in the report opening then immediately shutting down without displaying any data 120 There are two typical ways to open an existine MasterMine repott Open via Windows dialog Click Open MasterMine Report on your View GM versions 7 and lower or GoTo menu to open a standard Windows directory dialog and navigate to your report By default this dialog opens to the stored SaveAs folder designated in your MasterMine preferences You have all the usual file handling capabilities in this dialog so in addition to simply opening existing workbooks you can copy paste move rename or delete files as needed To open an existing workbook double click on the filename or select it and hit Open If you have MasterMine reports saved elsewhere you may navigate within the Open dialog to another folder on your system Launch from a GoldMine Taskbar An even easier way to open a MasterMine report is to launch it from a taskbar icon requiring merely a single click Even the least computer skilled person can launch a MasterMine report
183. ny image file that Excel can handle gif are the most common to automatically print the image in the upper left corner of the report and automatically link it into the header of each page of the report After opening the report it can be edited or removed in Excel by going to print preview hitting the Setup tab and then hitting the Customer Header Footer button Always save SQL password in new reports y P P For maximum security in SOL the default Excel pivot table requires the user to enter a valid SOL login username and password in order to access the underlying data each time Typically this happens when refreshing the report or entering MSQuery to modify the underlying quety Check on this preference to store the SOL password within the Excel wotkbook and to use it automatically when needed Be aware that the password 15 not encrypted when saved in the Excel wotkbook and can therefore be hacked by a savvy user MasterMine does NOT expose this password unencrypted in any of its functions Always dock toolbar on report open For cleanest startup in Excel 2003 and lower some users prefer to have the MasterMine toolbar dock with the other toolbars by default The alternative for frequent MasterMine toolbar users is to move it manually to the top of the Excel window when not in use This is not an issue with Excel 2007 and higher which does not offer floating toolbars 41 Hide fields list on report op
184. o Opportunities OM OpMgr fields Opportunity Tasks OK Task fields OMOKC1C2 Opportunity Details Details and Linked Documents relating to Opps OMODC1C2 Opportunity Influencers Influencers relating to Opps OMOCC1C2 Opportunity Teams Team Members relating to Opps OMOTC1C2 Team Members and Opportunities they link to For team Opportunity Team with members that are GM Contacts Contact info of Team member Team Contact Info is included OMOTC1C2 Opportunity Competitors Competitors relating to Opps OMOPC1C2 Opportunity Issues Issues for Opportunities and Opps OMOIC1C2 Forecast sales using only info in Opportunity record not the Opportunity Forecast attached Sale records on Pending tab OMC1C2 Opportunity Pending Sales Forecast Pending Sale records associated with Opportunities OMCAC1C2 Opportunity Sales Completed Completed Sales associated with Opportunities OMCHC1C2 150 Workbook Name GM Tables Description II Opportunities and linked Pending Activities II Opportunities and linked Completed Activities fluencers and all associated pending activities fluencers and all associated completed activities ppportunity Pending Activities DMCAC1C2 Ppportunity Completed ctivities DMCHC1C2 Ppportunity Influencers Pending Activities Ppportunity Influencers listory Activities 151 Projects Toolkit MMProjects xls and MMProjects Unlinked xls As with Opportunities GoldMine s Projects may
185. o seamlessly enhance your GoldMine management capabilities Security MasterMine has read only access GoldMine data except ContGroups so there is no danger of directly changing underlying GoldMine data Access to GoldMine itself is through the usual log on and other security measures although MasterMine offers a powerful Drilldown feature that expedites the process of finding individual target records No MasterMine user can directly affect GoldMine data that is not otherwise accessible to that user through GoldMine s security However because MasterMine renders powerful overviews of your entire business including individual and group performance data you may wish to restrict the use of some MasterMine toolkits to the management level and those who have master rights of access in GoldMine itself 23 Certain capabilities be denied selected users simply by removing them or by purchasing appropriate licenses For instance the ability to create new reports can be removed altogether by appropriate Share licensing OR by manually removing the Create MasterMine Report line item from the user s Userini in the GoldMine application folder Users with Share licenses can be restricted to only those reports created for them by full license users They retain the ability to work with flexible pivot capabilities but cannot change which fields appear in their reports at the query level Also consider using Excel
186. of a chart is always to make a grand presentation to someone else Sometimes it can provide you with a key to understanding you would have otherwise missed Dynamic Management Reporting MasterMine is to management reports what the internet is to television You actively ask questions and probe some say surf your data rather than simply accept what s there By adding interactivity MasterMine can replace much of your static management reporting Apart from the sheer fun of noodling in your data you should aim to create a series of dynamic management reports that give you a comprehensive view of the unique key processes by which your company operates We can t dictate to you what these are because your processes are unique but these guidelines can help you work your way toward them Creating Functional Workbooks By now you know that dynamic management reports are much easier to create and manipulate MasterMine than static reports created with GoldMine s built in report generator or a third party software like Crystal Reports MasterMine reports also refresh much more quickly and are easier to copy and modify In addition since they allow drilling down back to your GoldMine database MasterMine reports can help you clean up your data instead of just showing it to you For a dBase installation of GoldMine a new folder called MasterMine is created in the contact set folder associated with each GoldMine contact set The folder c
187. oin otherwise you may trick yourself into thinking you are seeing all data when you not To re define your join as an Outer Join double click the joining line between the two table boxes in MSQuery Using the three radio buttons in the Join window select the type of join you desire and click Add then Close If you selected an Outer Join the connecting line between the tables is now an arrow Notes on Joins Only inner joins ate allowed when the query includes three or more tables MasterMine templates based on Cal dbf use only inner joins by default since installations with multiple contact sets include many pending records that don t relate to the selected contact set It may sometimes be useful to use outer joins to view the entire schedule regatdless of contact set MasterMine templates based ContHist dbf use only outer joins by default except where one or three tables are involved To summarize Inner Join Includes only records with counterparts in both tables Outer Join Includes all records in one table and only records in the other that have a counterpart in the first Finishing Query Changes and Returning Data If you are happy with the result of your changed query you can return the data to your Pivot Table from the new quety by clicking File Return Data to Microsoft Excel To cancel without returning new data click File Cancel and Return to Microsoft Excel Now from the wizard you must incl
188. olbar To accomplish this tight click on Categories Commands the menu bar in the empty Space 4 ec 2 HE cieanupDosNotes to the right of Help and Edit choose Customize Menu Go To i Print a Report 3 Tools esa Click the Commands tab and i witch User ipu v 3 SUR scroll down on the right side to Tria m ene Launch MasterMine Click w i MAN E Login to deer and drag this text up to the Help 7 Open MasterMine Report immediate right of the word All Commands 1 Mew Menu Create MasterMine Report Help in the menu bat Now Exit right click on the new menu button that has been created and adjust the menu item settings to your preferences Troubleshooting Installation If you encounter any difficulties your first resort after this document is MasterMine s online troubleshooting page and online Knowledge Base under support at www mastermine net Secondarily you may get help by calling the contact number in the title page of this manual Setting up for SQL Installations MasterMine includes an automatic function that sets up your system to use SOL databases For GoldMine Version 6 7 and below this function requires that the current Windows user have administrative access to the Borland Database Engine BDE folder If this setup does not finish successfully you can manually set up access to your SQL database by updating the
189. olkit from the Templates menu The following pages document the contents of these toolkits which contain the bulk of templates available in MasterMine GoldMine Administrator Activity Analysis Sales Manager Toolkit Opportunities Linked to Contacts Projects Linked to Contacts Combined Pending amp History Workbooks by GM Table Name QuoteWerks no gt gt To aid in report selection the following tables list the templates available in each toolkit Note on Custom Fields Contact2 fields which are custom user defined fields ARE available for any workbook that shows Contact2 in the GM Tables column Checking any C2 field on the Fields Used tab will add the Contact2 table to the query and change the join type to inner if it was not already MasterMine Aliases for Database Tables In MasterMine documentation as well as in MasterMine SQL queries MasterMine uses a 2 letter alias for each GoldMine table In the following template descriptions the GM Tables are referred to with these codes or aliases Most Common Tables Special use tables Alias Table Name Alias Table Name For C1 Contact RF Contact1 Referrals C2 Contact2 GS GSSites GoldSynch Sites CH ContHist GH GSSites GoldSynch Headers CA Cal AH InfoMine Knowledgebase CS ContSupp AL ContSupp Alarms OM OpMgr LD ContSupp Linked Documents UL UserLog UserLog SL SysLog System Log EM ContSupp E mail Addresses LK Lookup Lookups
190. ommon Fields and Expressions The following tables summatize the logic behind report field contents including the SOL expression used to extract them The source column indicates source files in GoldMine aliased as follows Most common tables Special use tables Alias Table Name For Alias Table Name RF Referrals Ci Contact GS GoldSynch Sites C2 Contact GH GoldSynch Headers CH ContHist AH Knowledgebase AL Alarms 5 ContSupp LD Linked Documents OM OpMgr UL UserLog SL System Log EM E mail Addresses LK Lookups Group Headers G2 Group Members RI Company Resources Source MM Field Name SQLExpression dBase Expression C1 Contact Rtrim C1 CONTACT C1 CONTACT C1 Company Rtrim C1 COMPANY C1 COMPANY isnumeric substring C1 ACCOUNTNO 2 C1 Linked To Contact 1 C1 ACCOUNTNO Is Not Null C1 Last Name Rtrim C1 LASTNAME C1 LASTNAME C1 Department Rtrim C1 DEPARTMENT C1 DEPARTMENT C1 Title Rtrim C1 TITLE C1 TITLE C1 Secr Rtrim C1 SECR C1 SECR udfDBO udfMMPrimaryEmail C1 ACCO C1 PrimaryEmail UNTNO udfDBO udfMMPEmailMergecodes C1 C1 PrimaryEmail Merge ACCOUNTNO C1 Phone Rtrim C1 PHONE1 C1 PHONE1 C1 Phone2 Rtrim C1 PHONE2 C1 PHONE2 C1 Phone3 Rtrim C1 PHONE3 C1 PHONE3 C1 Fax Rtrim C1 FAX C1 FAX C1 Ext1 Rtrim C1 EXT1 C1 EXT1 C1 Ext2 Rtrim C1 EXT2 C1 EXT2 C1 Ext3 Rtrim C1 EXT3 C1 EXT3 C1 Ext4 Rtrim C1 EXT4
191. on exising Excel capabilities to make Pivot Tables even more user friendly and more integrated with GoldMine at the same time Active Report Ribbon Group These functions ate available to modify the current report 72 H Add Ai Add Field Allows the user to add a GoldMine field to the existing report although it was not included in the original query when the report was built The restriction is that only fields in tables that are already present in the report are allowed In the first field select the table from which the desired field will be added then select the specific field under Database Field Name In most cases the data type of the source field will default to the cotrect one and the other fields New Query Field Builder masm new field Name and New expression will populate automatically with the defaults from the Source database field to include MasterMine toolkits Table Database Field Name Pata 1 1 2 Numeric Field Name will be the default name of the field in Date your repott F griis ves Convert to Ted Selecting an alternative option under Convert to 7 Numeric automatically modifies the New Expression to provide appropriate formatting of the incoming data For example if you bring in a GoldMine field that contains mostly numbers and you want that Add after field Company data to be treated only as
192. on territory Contacts Inner Joined region other key fields and user defined Contact2 fields C1C2 Missing C2 Detects Contact records with missing Contact2 C1C2 Pending unlinked and unsent faxes FX or FAX in UserlD Faxes Pending FaxRush standard CA Analysis of completed faxes both individual and mass faxes Faxes Sent Result code is FAX FaxRush standard CH All Contact records and their associated Details Includes Contacts and linked Details contacts with NO Details profiles C1CS All Accounts and linked Contact records and any pending activities associated with pending them Includes contacts with NO pending activity C1CA No Pending Activity Contacts with no pending activities nothing scheduled C1XXC2 Contact records and history associated with them Includes All Accounts and linked history contacts with NO history C1CH 145 Workbook Description GM Tables No History Activity Contacts with no history no completed activity C1XX Sync Log Full log of synchronizations SL Last Sync History Report of most recent sync activity for each sync site GSGH Sync Report of sync activity by site GS Alerts GoldMine Alerts assigned to contacts in record properties AHALC1C2 Alerts by Date GoldMine Alerts sorted by date last modified AHALC1C2 Lookups All Lookup values Includes Zip code lookups LK All Lookup values except Zip codes Faster to load and re
193. ontains a series of Excel workbooks extension xls for each template you have opened The Toolkits that MasterMine providesgive you an excellent start in developing this set but you will quickly move beyond what mere templates can do for you Change the names of these workbooks to reflect the functions they serve Some like Calls Analysis and Sales are obvious Others might look at your Production Processes Customer Service Financials or other data and should be named accordingly as you build them Troubleshooting Reports While you are still new to data mining it is a good idea to double check your results against your old static reports to be sure that you re getting what you think you are If there is a lack of agreement between a MasterMine spreadsheet and a static report here several possible items to check e Make sure data is refreshed 133 e Check the selection criteria in the MasterMine display box for the query against the parameters for your report e Check the selection criteria in the page area of the table e Check to see if you have hidden items in any of your fields e Check the logic of your table joins see Adding or Adjusting Joins in Chapter 10 Clean up After Yourself Drilling down and using Show Pages can add many sheets to your workbook in a hurry Remember to select these sheets and delete them before you finish working Otherwise you may find that yo
194. ook in a location where the original data is not available i e away from the network where the SQL server 69 Share Report resides it will invalidate the workbook until the SOL database is again available and a successful refresh is performed e Disable data refresh Freezes the report as is with the currently queried data set e Disable access to Pivot Table Settings e Require user to enter SOL password for each refresh To password protect your security settings enter a password in the text box at the top and when the settings are as you want them click Save next time you enter the security dialog the settings will be invisible until the user enters the correct password To remove the password delete the password from the text box before clicking Save Be sure to save the workbook itself after saving your security settings There is no way to retrieve a forgotten password without help from MasterMine technical support Share Report Adds the current report to a GoldMine taskbar for one button launch either in your own GoldMine or in another user s This is the quickest easiest way to deploy a report for easy repeated use Note that other users must have MasterMine licenses to launch these reports Add Report to GoldMine Taskbar This dialog allows you to select any GoldMine user Add this report to a taskbar in GoldMine for easy one button launch whose taskbar will have a button which will l
195. opriate versions of the reports as you make them Simply click Share Report on the MasterMine ribbon in Excel Then enter the user and name of the GoldMine taskbar to deploy to Several security and convenience options are included See Report Deployment ribbon button on page 101 End Session and Return 27 Save your changes when you exit Excel When you want to return just select Open MasterMine Report on the GoldMine View menu If you return on a later day be sure to Refresh the data so that your report is always current You do not need to keep track of where you put your report workbooks as long as you use the default save to location The Excel worksheet we have been using was automatically saved under the name Sales Pending xls the path directly beneath the target GoldMine contact set unless you specified another location before creating it For example if we have been looking at data stored in Z Program FilesNGoldmineNCommon this wotkbook is at Z Program Files Goldmine Common WMasterMine Sales Pending xls 143 Appendix C Pre formatted Reports Toolkits and Templates MasterMine s pre formatted report templates grouped into job function or content related Toolkits to make them easier to find These Toolkits and the templates they contain are accessed by clicking template on the upper right of the main create report dialog They can also be found listed by to
196. ore pivot tables in a single workbook A database Table is a set of records all with a consistent structure containing data that logically belongs together A database typically contains a set of tables that fit together to form a coherent set of information The GoldMine tables used by MasterMine Contact1 etc are listed elsewhere in this manual Each table contains a number of records 62 Record in GoldMine is considered to be a single company or account contact unit The major screen consists of an Account Record that has many ancillary points of data tied to it In a database context a main Table called Contact contains one record per company But each company can also have many records associated with it contained in related tables like ContHist History Cal Pending etc In MasterMine we speak of Account rather than record to refer to a main company contact in the top part of the GoldMine contact screen This is because at the database level there are many Records associated with each account namely all of the history records each line on the History tab is a record in this sense calendar records supplementary contact records detail records etc that comprise the full body of data related to a single Account A Field in GoldMine 15 a single box on the data entry screen into which you can type an item of data In MasterMine a Field roughly corresponds
197. ott by the values in the data area corresponding to each field item Thus for instance selecting Descending and then in the Using field list box below this selecting a field in the Data area to sort by will result in a report showing the number of occurrences of each item within the database in descending order When refreshing your report causes new field items to appear within the field these new items will appear in the field at a location determined by the type of sorting that is in effect for the field If the field is sorted Ascending or Descending new items will automatically sort into the list at the logical location according to the sort New items in a field that is under Manual Sort will appear at the end of the list 99 5 Amount B Region 7 CN 8 Mw NE NW 1 SE 2150 23 SW 24 Grand Total 2 USer IUZ Acuve Reps 3 Region2 North America 4 Status v v Active Inactive Dead Grand Total 62 352 61 106 750 78 142 373 64 17 745 80 87 730 30 56 361 43 114 208 12 587 523 58 62 014 69 186 754 01 855 302 38 manager perhaps may want to know how one particular region MW breaks out by UserID thus answering the question Within the MW region how much sales revenue is each user bringing in Roll up Roll down With multiple fields in the Row or Column areas double clicking any field item Rolls down or Rolls up the detail for that item This simpl
198. ow SQL or dBase expression syntax to accomplish this or use a reference book that covers these functions There are a number of such resources online In this example we will change the source field to return only the first three characters of GoldMine s source field With MSQuery open showing sample data below with each column topped by a header open the Edit Column dialog by double clicking on the field header you wish to modify 125 In the picture the user has double clicked on the Source field header bringing up the Edit Column dialog In this dialog the user can change the field expression by making changes in the box labeled Tig Fie E thus altering the data that is returned To return the first 3 characters of the 4 s ACCOUNTNO Column J Source field the new syntax ACTIONON CALLBACKAT bel would be CALLBACKON Rtrim C1 SUURCE CALLBKFREQ Microsoft Query Query1 Column heading pn Left rtrim C1 SOURCE 3 Florence Flagg Harvey s Parts Other Maury Millford Skanda Systems Trade Show Pamela Nelson Henley Supplies NV Magazine Ad Patricia Phan Qualified Systesm NC Yellow Pages Note that the new expression Ivan Polanski Assembly Control Systen Unknown Mary Stafford Commerce Associates Trade Show il n 1 twi n Arthur Lawson PCM Systems NY New York Times Suspect Aviation il contains ested Sandy Price Worldwide Warehou
199. p Rob MA STERMINE Desktop Documents Release 7 0 126 Folder Treeview Content Exit H H For new users of MasterMine this Created acw list from april 7 14 2011 2 32 22 PM ware namens folder tree will be empty at the all countacts with mm stage xlsm 5 4 2011 2 45 39 PM 831 KB 5 4 2011 2 45 40 b 5 f thi h Bounced email addys from newsletter 8 3 2011 1 8 3 2011 3 28 45 374KB 8 3 2011 3 28 45 PM gl nnin Call History Nancy Workable Accounts for nanc 4 14 2011 8 58 16 PM 369KB 4 14 2011 8 27 09 PM S even 1 o er users ave Customer Maintenance Report xlsm 3 28 2011 11 20 41 1628KB 3 2 2011 2 21 42 PM gt FD QW List xlsm 7 12 2011 9 47 25 AM 165KB 7 11 2011 4 33 32 PM shared reports to you Over time find email addys for nancy xlsm 7 18 2011 8 51 11 1317KB 7 18 2011 8 27 52 AM find lost demos xlsm 9 15 2011 4 52 06 PM 1722KB 39 15 2011 4 52 07 PM this treeview will exp and to include i ivities All except E mail demo fu xlsm 5 11 2011 10 04 32 AM 11411 KB 5 11 2011 10 04 33 AM ll except E mail xlsm 7 11 2011 6 26 03 PM 2140KB 7 11 2011 6 26 10 PM iti i Appointment add slsm 5 11 2011 10 18 29 AM 795KB 5 11 2011 101828 AM all additional locations where you Appointment check xlsm 5 9 2011 7 30 03 790KB 5 9 2011 7 30 05 History Activities Call amp Appointment xlsm 4 13 2011 7 47 32 PM 796KB
200. parameters on the GMSQL tab of MMINI xls found in the Support folder within the MasterMine folder Note that you MUST obtain working username password combination for the SQL database from your system administrator If your GoldMine installation uses MS SQL the first time you run MasterMine you will see this dialog 26 n Enter SQL Password GoldMine Contact Files MMSales 501 Server Name GOLDMINE VM Cancel Contact Set Database Name GoldMine GM Base Database Name GoldMine SQL User Name sa br GoldMine InstallShield ard gt SOL Password x Save SOL password in each new report for automatic refresh InstallShield Wizard Completed Save Reports To CAMasterMine Reports 8 The InstallShield Wizard has successfully installed MasterMine 6 0 For GoldMine Click Finish to exit the wizard Completing installation Please walt Enter a working SQL username and password High security environments may require the use of a SOL username and password that have read only capabilities in SQL For further security uncheck the box for Save SOL password in each new report for automatic refresh Unchecking this preference causes MasterMine to ask the user for a working SQL password every time the person refreshes a report or uses MSQuery If you have multiple SQL GoldMine databases we recommend that you insert additional rows by hand into the GMSQL work
201. pe v C1 Status v Partner v C1 amp ccount Rep v C1 Product Inl v C1 CreateOn CA Company CA 0nDay CA nTime CA nl lour CA Product l Report Next Pending Activity only All Contacts SaveTo Path C MasterMine Reports eu Save To Template Filter Finish Cancel detailed explanation of the template in the information bubble to the right Use this information to decide which template to select without clicking through each one You can sort the Report Host Pending Activiy only Al Contacte list by report name Toolkit Activity Analysis Next Pendng activity for each contact record or alphabetically None if none exists default Of by toolkit then report name by right clicking on the list and selecting the appropriate sorting option How to see all available templates For the broadest selection of templates click List All Templates at the bottom of the area selections on the left If you use this option you will probably need to search by keyword to find the right template Search for the right template by keyword You can use keywords to find the template that best suits your needs In the space above the template list enter keywords separated by spaces and click Search The list is 48 Toolkit Sales Manager narrowed down still further to include only templates from the GoldMine area
202. pes in GoldMine detail records See Appendix A Details Tab Reporting on Page 137 37 Standard length to pull from Reference Product field 0 all The Reference field in history records is often used to contain multiple pieces of information If you want to pull only the first x characters from the Reference field enter a number here Another usage References are especially long fields and can resultin Out of Memory errors when querying large amounts of data on older computers using older versions of Microsoft Excel In order to keep this to a minimum MasterMine allows you to query Reference data in a field called ShortRef which contains the first x characters of the Reference field by default You can adjust this length for all subsequently created reports by changing the number here Set this parameter to 0 to have ShortRef pull the entire reference field Note that there is a full Reference field also available in the field list as well as Product for sales related repotts all of which pull data from the same REF field in the GoldMine data Default start date for history data When running a history report the user designates a starting date so that queries on very large databases won t unnecessarily bog down the process This is the default date that comes up in the Start Date field on both the front screen and the filter screen Date to substitute when date fields contain no data or un
203. port without rebuilding it yourself This 1s the only way you can tuin an otherwise functional report in MasterMine If you are not confident in your skills with MSQuery we encourage you to seek further MasterMine training either with your GoldMine Solutions Partner or from MasterMine directly or have us prepare some customized templates for you Technical Note MSQuety is a wizard for building query statements using a simplified set of SOL System Query Language conventions called Transact SQL The syntax of your Transact SQL statements will vary depending on the underlying database type GoldMine uses The currently supported GoldMine versions v7 0 and higher use Microsoft SOL or a variant SOL Express or MSDE depending on SQL version as its database engine Older vetsions of GoldMine used dBase as a database engine so MasterMine was built to work as seamlessly as possible with both back ends MSQuery uses ODBC Open DataBase Connectivity data drivers which supplied with various releases and service packs of MS Office to connect to the GoldMine database If you have trouble with some templates or difficulty setting up your own Pivot Tables especially if you are working with an older version of Excel like Office 2000 or 97 outdated drivers may be an important cause Get the most recent service pack from Microsoft Fairly technical users may be already familiar with Transact SQL and so will be very comfortable operati
204. pp OM OpMgr CX Contact1 QH DocumentHeaders Ql Documentltems Workbook Name Description GM Tables All Quotes in QuoteWerks regardless of links to GoldMine Quotes accounts Quotes GoldMine linked Quotes linked to GoldMine Accounts C1C2QH Quotes at the Item level of detail Only Quotes not marked Quotes by Item lost are included QIQH Quotes linked to GoldMine Accounts Only Quotes not Quotes by Item GoldMine linked marked lost are included C1C2QIQH Orders All Orders All Orders linked to specific GoldMine account records Orders GoldMine linked Includes access to GoldMine account fields C1C2QH Orders by Orders at Item level of detail No GoldMine detail included Orders at Item level of detail GoldMine contact detail Orders by Item GoldMine linked included C1C2QIQH Invoices All Invoices All Invoices linked to specific GoldMine account records Invoices GoldMine linked Includes access to GoldMine account fields C1C2QH Invoices at Item level of detail No GoldMine detail Invoices by Item included QIQH Invoices by Item GoldMine Invoices at Item level of detail GoldMine contact detail linked included C1C2QIQH Forecast Forecast by part QIQH All documents linked to GoldMine Accounts Summarized Forecast GoldMine linked at individual item level C1C2QIQH Forecast based on GoldMine forecast sales linked to QW with GoldMine Forecast QuoteWerks documents C1C2CAQH 154 Appendix C
205. progress box while creating the report loading the necessary data from GoldMine and naming field buttons so far as possible according to your customized GoldMine setup Please wait MasterMine is constructing your report Adding Field Labels amp Color 1 of 1 When finished it tells you where your report has been stored Click to begin wotking with the new repott in Excel Now the hard part is done come up with the report you want you now need to organize and format it as desired That s it With these few simple steps you are now able to extract a large portion of the most interesting information from GoldMine Here s where the fun begins Once you ve selected your criteria and hit Finish the data are extracted from GoldMine and presented for further arranging and formatting in your Excel environment Before you go on however consider these thoughts about the selections you make in the MasterMine interface e The fewer files and fields that are referenced the quicker your data refreshes This is a very important consideration if your data files are large e If you are working with more than 100 000 records in your queried files be sure you have at least 100MB of unused RAM available Otherwise data refreshing and re calculating can be very slow sure sign of memory shortage is if your 58 hard drive seems to be working very hard during a long data loading refreshing p
206. ques and TFiCks 3 de eee pd be aee ate eee um Oe 103 PIVOT PABEE SETTINGS Oa ec PEE GO er RO PEDE er cree Ue eem RE 107 Format Options ustus haah RE P 107 Grand Totals for Columns Rows Turns on off totaling for columns and rows 107 Data Options etate tu re e 108 MORE TIPS amp TRICKS IN EXCEL asd nte pe t p e E et eer ee ERE 108 Branch Off From Existing Reports stes a re Eo eee peer a deii 108 Auto Refreshi cs eet p ape e Ede a P is 109 Set Filters Across Worksheets Page Selection 109 Working With Notes e teret Pa rto o e Dp e be a P e ue t D DR ardere ient 110 DATA MANAGEMENT Meses Q 111 DREL 111 DRIEE THROUGH TO POP GOLDMINE RECORDS vice ertet ie 111 CREATEANDIUSEGOLDMINEGROUPS iu erue Ex reve Ex eee 112 MMUPDATER UH ERR 114 MM Updater Options it e tp e Rae ER t np editi nee des 115 MMUpdater Eoosheetius i pav EHE OU Pas pum EU nnn DOE e dne E 116 Undo Changes gua aU utet achete d atte freto
207. r Schedule a report to automatically print while unattended On a pre set schedule using Windows Scheduler the report automatically launches refreshes and prints to the designated network or local printer Enter Print Schedule For Mastermine Report Reports may be scheduled to run once weekly or monthly Schedule the current worksheet or the whole Weekly workbook to print on a regular basis C Monthly Monday Thursday Saturday Tuesday Friday Sunday Wednesday Print Current Worksheet Option C Entire Workbook Copies Printer Schedule Task Cancel 88 18 Customer 19 Past Client fan Grand Total Chapter Formatting Reports Once the MasterMine Create Report dialog has been used to extract your GoldMine information into Excel the genius of working with data in a pivot table becomes immediately apparent You can now shape and organize your data on the screen with immediate results without the usual procedure of going back and forth to a report designer or a wizatd In this chapter we ll give you the basics for organizing data on the page and an introduction to some tools added by MasterMine to the Excel interface that make using pivot tables together with GoldMine data and built in features a powerful combination Moving Fields Around drag and drop involves simply left clicking on the field you wish to move and holding the clicker button
208. r or a GoldMine Group so you can use this feature to make other MasterMine reports easier to produce 112 Within GoldMine creatine Groups requires either some technical knowledee the logtc of building a SOL query a great deal of patience clicking on individual records and adding them one by one to an existing group MasterMine vastly increases the power of these functions by allowing you in seconds to define a complicated target set of account records using the slicing and dicing capabilities of the pivot table then drill down to a line listing of the records from which you can pick a subset or send the entire set of records to be grouped Group Creation In your pivot table report select items the Page area and include fields in the Row or Column areas to define segments graphically By showing the number of records that meet your criteria or many potential sets of criteria this replaces the work you would normally have to do creating many complex SQL queries to isolate your target records From there drill down to a line listing page showing a row by row listing of the target records You may wish to aggregate records from several different cells in your pivot table into a single GoldMine group Do this by grouping items see Grouping Field Items page 101 within the pivot table to bring them all into a single subtotal then drilling down on the subtotal Alternatively you can drill down on separate items creating sepa
209. rate drilldown sheets then copy paste data from one sheet to another If you use this method be sure to create only one header row in row 1 3 Once you have created drilldown sheet displaying your MasterMine will create a new group in GoldMine out of the records on this page Please supply a valid GoldMine group name below Group Name Sort Members By Reference Field Group Code Assign to User target records simply hit the GoldMine Group button on the MasterMine Drilldown ribbon and specify a name for the group You may optionally specify a field only if it is part of the original query that will be used to sort the group E mail These members as well as a field whose items can help you to OnDate reference records once you return to GoldMine Y Optional Optional Group Selected Rows If you want to build a group on only some of the rows represented in your MasterMine drilldown screen highlight the rows or individual cells in only one column for the rows to be included MasterMine will detect that you have done so and build the group of only the selected rows OK MasterMine creates only one group member for each account number appearing on the page It colors the rows of would be duplicate members blue and the rows of members not found in the current GoldMine contact set red This means you safely create non duplicated groups even from activity centric reports or fro
210. rd or sub recotd Test run do not update GoldMine By default every time you use MMUpdater this option is checked on If you leave it checked you WILL have another opportunity to commit changes to GoldMine after viewing the before after on a log sheet We recommend leaving this value checked when making important changes When you click the button MMUpdater passes through all selected records and if Test run is unchecked updates the data in GoldMine 115 MMUpdater Logsheet As it processes records MMUpdater creates a Logsheet that displays your data in before after form This allows you to double check that your intended changes really the ones that will occur It also provides you a to keep in the workbook so you know what changes were made on this date If you did a test run you can now commit your changes to GoldMine from the Logsheet by clicking Finalize on the MasterMine Drilldown ribbon A dialog appears asking if you ate sute you want to update GoldMine You may also update only a subset of the displayed records on your Logsheet simply by deleting the rows of any records you do not wish to update from the Logsheet Undo Changes If you have made updates to GoldMine as long as the Logsheet exists and undo has not yet been performed you can undo these changes in GoldMine undo click Undo on the MasterMine Drilldown ribbon You can save the Logsheet within your MasterMine
211. rea of your report This limits the display area simple report to get used to them below to only those records for which the related page field contains the selected before moving on to create a real report field item This simultaneously creates a visual confirmation of the filtering which you will find very useful by displaying the selected filter value to the right of the field With this technique you can easily set multiple parameters for your report by selecting items within several fields in your Page area 96 Beginning with Excel 2007 it is possible to select multiple items within a single field in the Page Area When you select multiple items a filter icon appears on the dropdown button next to the field so you know a filter using that field is active Earlier versions of Excel include a technique available to filter multiple field items in the Page area To do this you need to create a group within the field See instructions on grouping below under Grouping Field Items The steps ate 1 Move the field to the Row Area 2 Create a group of the items you want to select and give that new group a logical name 3 Move the grouped field back to the Page area 4 Select the named group as a filter Thus your report shows only data for records where the field contains one of the items in the group An added benefit is that you can use this group in a way similar to how you would use a single field i
212. readable date value Querying dates into a MasterMine report can provide powerful date range groupings etc Howevet to accomplish this all items in a date field must contain a valid date If the source field is blank null or a character type field that contains non valid date MasterMine substitutes the default Null date Save SQL Reports to MasterMine saves GoldMine reports to this location when the source data is MS SQL For reports with dBase source data the software automatically saves reports to the MasterMine folder within the GoldMine contact set folder to which they refer Toolkits Preferences Toolkits are sets of report templates listed under the Templates menu You can turn off toolkits you don t use on this tab in preferences Removing some toolkits not only reduces the number of options a user has on the Templates menu thus possibly reducing confusion but also makes loading of the software faster Another consideration is your use of Opportunities and Projects in GoldMine If your company does not use Opportunities or Projects it makes sense to simply turn them off in this tab 38 MasterMine provides toolkits that work with systems where by the choice of the GoldMine administrator and formal user rules all Opportunities are either linked to specific Contact not For reporting purposes you will want to have EITHER the Opportunities Linked to Contacts or the Opportunities Unli
213. ritten by the next similar report that is created it also makes it much easier to reuse and modify useful reports Choosing a report name may seem trivial but you will find that if your name accurately but specifically reflects either the content of the data included i e Completed Calls for Prospects with Qualitying Info or the specific use to which it will be put i e Friday Calls and Appointments Report you will be able to re use and branch off of your earlier work much often Save To The default SaveTo location is stored in MasterMine preferences For dBase usets the SaveTo path is automatically a MasterMine subfolder of the contact set to which they refer However if you wish to store them elsewhere you may specify another location in the Save To list box or use the Browse button Be aware that reports stored outside the default SaveTo folder will not appear when you use Open MasterMine Report from the GoldMine menu 54 Limiting Record Selection Filtering In addition to shaping your query at the field level you may also want to limit the quantity or type of records table rows included Although it is frequently easiest to simply query in a mass of data and set yout filters within the report itself where they can be changed later as needed sometimes it helps to pre filter your query This makes a report more user or job specific and therefore easier to dictate how
214. rocess It s probably swapping data with your memory which is a tedious and unnecessary process Getting more RAM is well wotth it The end of this guide includes a handy reference see page 137 that tells you the fields and functions contained in various GoldMine files Excel 2000 and eatlier can display only fields containing fewer than about 9000 unique values This DOES NOT mean that MasterMine can t be used on your system if you have more than 9000 records in your database Here are several suggestions for dealing with this limitation 1 Get Office XP or higher Each successive version dramatically raises the memory limits 2 Consider that fields with many unique values like Company or Contact can still be accessed drill down mode So any time you need a detailed list of companies that meet various criteria simply double click on a pivot table segment that targets the records you want to see and all contact info will be there 3 Use filtering criteria see page 55 above to limit your overall query LOOSELY around the specific information you want to see There is plenty of opportunity to further refine your selection once you have the information in your MasterMine workbook Using filtering criteria up front however may help reduce your overall selection to a manageable level 59 60 Chapter Getting Oriented Report Parts and Features This chapter orients you to the various parts of a MasterMin
215. rue return to the status before the update in that GoldMine transaction logs will reflect both the change away and the change back to the original value Drill Preferences Sets parameters for automatic formatting when a new drilldown sheet is created or when drilling to GoldMine popping the GoldMine record Selections 79 e Do not format data or headers drilldown sheet When the user double clicks any Data area element a new drilldown sheet is created showing in rows each record that comprises the element MasterMine adds some formatting to this native Excel process by passing through fieldname and label substitutions the user has added to the pivot table Checking this box disables this feature for the current workbook Drilldown Preferences xi Drilldown From PivotTable to Line Listing e Vertical alignment of rows When the report contains notes or other very long data that wraps other columns in the same row must align to the top centet or bottom of their respective cells Set the default here Do not format data or headers on Drilldown sheet Top Y Vertical alignment of rows Drilldown From Excel to GoldMine Show sample of source row fields inside GoldMine Show sample of source row fields inside GoldMine When drilling through to GoldMine by double clicking anywhere in a row of a drilldown sheet to pop the underlying record this feature shows t
216. s enabled or disabled in the preferences page in your MasterMine interface In addition to the MAIN REPORT BUILDER Toolkit which Full calendar of Past due activities renders the most global overviews of GoldMine data files MasterMine Past due calls by user Past due forecasted sales by territory comes standard with a GoldMine Administrator Toolkit Sales Past due calls amp appts by month Manager Toolkit and a toolkit for building workbooks from Past due activities by user activity type and scratch called by GM Table Name Additional toolkits include product category or any custom field more templates to handle general Activity Analysis Combined Almost any combination you can imagine Pending amp History Projects Opportunities and more discussion of each of these toolkits is available in Chapter 9 References starting on page 137 A customized toolkit may be added by your GoldMine Solutions Partner or by MasterMine Software to simplify and speed up your implementation or to facilitate handling interaction with databases outside GoldMine Although these toolkits look like Excel workbooks they are password protected and not for end user manipulation 49 Create New MasterMine Workbook Fie Templates SQLQuery Preferences Help Selecting a toolkit on the Templates menu changes GoldMine Administrator the list templates available the Template Template E Mail v TeMesCIEM
217. s R i 3 2 E PrejPost Sale Aviation 2 FirstSale Engineering 1 OnDate2 Food 1 1 Media 2 6 4 5 4 2 El ProdRef Pharmaceuticals 1 1 1 SalesRep System Design 8 1 28 Customer Engineering 1 30 Media 1 Row Area v 31 Pharmaceuticals 1 32 Past Client Aviation 6 4 3 2 5 1 3 3 27 33 Engineering 1 2 2 3 3 1 12 34 Food 1 2 2 3 2 1 1 12 Media 1 1 1 1 4 36 Pharmaceuticals 1 1 2 37 Grand Total 8 30 37 39 23 34 19 36 28 254 The Hidden area contains all available fields including additional page fields not displayed on the worksheet The latter may be added to the table unhidden by dragging them from the Pivot Table field list to the desired Pivot Table area Fields appear bold in the hidden area if they are also displayed in the pivot table or normal font if they are not 64 Field Buttons in row column and page areas have a gray background and usually correspond to specific fields in GoldMine database files Not all GoldMine fields are available in MasterMine templates but advanced users can add any field or portion of a field For a full list of available fields see the GoldMine Database Layout Reference in the back of this manual Field Colors Note that the Field Button Color in MasterMine tables reflects the underlying data files from which the fields come The color scheme is as follows Blue Contacti Red Contact2 Green Cal Brown ContHist Pink ContSupp Orange OpMgr
218. s com QuoteWerks is a popular stand alone or GoldMine integrated quoting and order processing application QuoteWerks enables companies to handle much more sophisticated quoting forecasting and order processing models than native GoldMine can support 28 P iGreate Now dMasterMine Workbook MasterMine reads QuoteWerks v4 0 or higher SOL only document data allowing QuoteWerks users to perform simple or sophisticated analysis Buotewerks Toolkit O 3X w3 X HH Tables GH Of any QuoteWerks data even in conjunction STER with linked GoldMine account data Detail Level Quotes GoldMine linked Quotes by Item Query Quotes by Item GoldMine linked Integrate QuoteWerks launch the Description Qiders ee Preferences menu in MasterMine s Create Orders GoldMine linked 3 ii P Orders by Item New Analysis Workbook dialog Click the Orders by ltem GoldMine inked Integration tab In the QuoteWerks section check the box to Enable then browse to or enter the path to the QuoteWerks application EER rdg a Cue Typically this is a folder named something like v QH CompletionD ate v OH ShipDate C Program Files QuoteWerks Next in the drop down box below select the of J QH DocNo Oh AdditonalAdchess QuoteWerks database in your SOL server To QH DocStatus QH AdditionalCharge report through Mast
219. s in memory ONLY if there is actual data that would occupy them That is an intersection is used only if your query actually contains at least one row whose fields contain the item in each of the three fields represented by that intersection In practice your data probably will not have a representative of each of these combinations in it so beginning with Office XP your pivot table can accommodate vastly more fields in the row ot column area without hitting the limit Example Assume you cteate a Pivot Table that contains five column fields The fields contain 10 5 2 40 and 3 items respectively The product of these values is 10 x 5 x 2 x 40 x 3 or 12 000 possible intersections 176 If you try to add one more field that contains three items the product would be 12 000 x 3 or 36 000 Because this number exceeds the maximum product of the items you receive the following error message Not enough memory to completely display Pivot Table Note that worksheets in Microsoft Excel are limited to 256 columns Because of this even if you successfullycreate a Pivot Table that contains a large number of column fields you may not be able to display the entire expanded Pivot Table Managing Row Fields The product of the number of items in all row fields in a Pivot Table cannot exceed 2 31 2 raised to the 31st power or approximately 2 1 billion items The same logic that applies to column fields also applies to tow fields A
220. s into a few levels the numeric range function is invaluable Number formats by field 9 so 29 E Number formats Select any numeric value in a pivot table and use these buttons to format all parallel field items or data area aggregations of numbers This powerful tool makes it unnecessaty to select whole ranges of cells containing number which might change in shape and size with refresh order to format them Just select a single item within a field to apply the change to all values in the field Ha Text as numeric Text as numeric Returns a true numetic version of a field stored in the database as text data Converting to numeric for reporting purposes enables grouping and sorting by numeric values which would otherwise be difficult or impossible The MasterMine Drilldown Ribbon id 9 c Gail s AMR xIs Compatibility M Home Insert Page Layout Formulas Data Review OUZ E m A GoldMine Pop Edit MMUpdater Finalize Undo Drill Sort Group Record Activity Preferences Columns GoldMine MMUpdater Format Drilldown This ribbon appears under Excel Table Tools when you ve drilled down from a pivot table double clicked on a data area number to create a drilldown sheet These functions help you interact directly back with GoldMine or to format the drilldown itself GoldMine Sroup GoldMine Group Build a group in GoldMine from the selected rows on the drilldown sheet If only a single cell is selec
221. s of information both potentially very useful and easy to create from the other 141 Create New Data Groupings 22 Now return Reference to the Page Area leaving USERID as the only Row field 23 Most companies group their sales people by function by territory or by product category If your users fall into such groups you can group them accordingly and use these groupings as items in yet another field button First arrange the users in order by selecting and dragging them into the order you desire within the row area Then drag select the top group of users When they are highlighted click Group selected items on the MM Tools ribbon This creates a new field button named USERID2 which includes an item called Group 1 instead of the users selected in USERID Click on Group 1 once and type a name for the group that reflects the group s function Similarly select and group the other users in the list Note that there are subtotals for each of the groups created Now you can treat the new grouped field button the same as any other field in the Pivot Table Click on the USERID2 button and type a new name such as Sales Groups Drag the USERID field up to the page area to see your sales broken out by sales group Switch the USERID and Sales Groups fields then select a single group in Sales Groups to limit your table to one group or another Save Useful Report to New Sheet 24 Suppose you wish to use yout
222. s some other ways to calculate and compare data using the field definition form including custom calculations calculated fields and calculated items Most of these options are quite sophisticated and require more in depth discussion than we can provide here If you wish to explore these options use the built in Excel Help topic Summarize and Calculate Data In a PivotTable to learn mote While you te here click on the Number button to format how this number is to be presented using decimal places etc Date Fields Date fields can be displayed in the Data area By default dragging a date field to the data area results in it being counted like any character field However you can set the field to show the or Min date for its row and column by doing the following Drop a date field into the Data area double click the field name set to or Min under Summarize and click Number to format the date as desired Tools amp Skills for Formatting and Analyzing Once you ve created a MasterMine report you can begin to hone it to your specifications setting up groups and parameters to meet your daily information needs Filtering in the Page Area anything else to see a working report you can play around with Try these basic skills on your The easiest way to filter a report is simply to select an item in the dropdown list of any field or fields in the Page a
223. sable drilldown GoldMine the report designer may disable and or passwotd protect certain capabilities Enter a password to prevent other users from altering the report LE Disable access to Pivot Table Wizard MSQuery Prevents Save SQL password with pivot table MasterMine Pivot Table Control Stats Drilldown Connection Query Text Security Help About MasterMine Save users from tampering with the underlying query thereby gaining access to data they may otherwise be curtained from in GoldMine See Working With MS Query chapter 6 Disable data refresh Prevents users from updating the report with current GoldMine data Disable drilldown Prevents users from double clicking on data area numbers to see the underlying information in a line listing format Do not save data with Excel workbook Reduces size of Wasa MasterMine workbooks to as little as a few KB Also prevents GoldMine data from being stored within the report thereby MasterMine Path c program Files mastermine mastermine exe increasing security of your data MasterMine License 124720 sc Hb RO 04 Front end application GoldMine GoldMine path goldmine vm goldmine GoldMine user ROB Master Save SQL password with pivot table A pivot table may have the SQL login data including password saved with it when the Excel path C Program Files Microsoft Office OFFICE11 workbook is saved Microsoft warns that saving your SQL
224. sales forecast by sales group on an ongoing basis and you don t want to re create it from scratch every time Save this worksheet under a separate name so that you can continue to tweak the original sheet while preserving your wotk on this form Simply click Clone Worksheet on the MasterMine ribbon to create a duplicate sheet Right click the tab at the bottom of the new sheet and select rename When name Original 2 is highlighted type a new name for the tab such as Group Sales Forecast Then return to the Original tab to continue developing variations Save Vatiations at the Workbook Level 25 You may want to save various versions as separate workbooks especially if different usets will be using these reports If so use the normal Save As function of Excel to save the report in various formats These can easily be shared with other licensed MasterMine users simply by sending them around as e mail attachments or by deploying them as explained below Deploy Reports to Other Users 142 26 You will probably create several different versions of this report for various users in yout organization Although based on the same information the report needed by an individual sales rep is different from that needed by the sales manager and still different from what top executive management needs you ve seen making variations on a single report is very easy by repeatedly cloning and reorganizing So SHARE appr
225. say 250 000 records in the tables you are pulling from may need to be careful to limit the field selections to necessary fields Trial Queries You may need to make several passes at creating your initial query to determine the optimum fields to include MasterMine makes this convenient by leaving open the create dialog after you create a report If your first query is too large if refreshing the report seems to take an unreasonable length of time or you receive an Out of Memory error or a message saying some fields have too many unique items to be displayed you can quickly run the same query after unchecking some fields 52 The Field List Short Menu Two important functions avallable within the Field List short menu that appears when you right click on the field list area of the Create dialog First you can elect to sort Contact table fields those within the Contact1 and Contact2 tables either separately or together If you sort them separately all Contact fields labeled C1 are listed before the Contact2 or C2 mostly user defined contact level fields This change makes it easier to find your fields alphabetically Second you can now select a governing GoldMine view from which labels are assigned to each of the fields Contact1 and Contact2 Because GoldMine allows single field to have many uses they can therefore have many possible labels according to each account s record type MasterMine allows t
226. scoscececceececessoscscecsoeceseccesescecceccesectescscecseccesecceseseecsescsseccescsseesosessescoseseessososseseoses 25 TROUBLESHOOTING INSTALLATION eee n una usaq oqa nn nn nn nnn nr nsns ssepe i au 26 SETTING UP FOR SQL 8 8 40 102 0002001 nennen a rennen sr en tene eren re ap oaea e sese Epe EN Ee innen entere seni 26 INTEGRATION WITH GOLDMINE ADD ON 28 Integrating Details Plus sires ascen e Een e Ee eb cele A ep eet tte ete de eh eee 28 28 LICENSING WORKSTATIONS 29 SHORTCUTS FOR MULTIPLE MASTERMINE INSTALLATIONS 30 2 Installing for Multiple Users on One Machine 30 HIEEDOCATIONS Se g sm Le aee IE NH 31 TERMINAL SERVICES INSTALLATION eee 31 UNINSTALLING MASTER MINE MENU IGAUNGH eee q suq cues u ey ves eee abe ee eee eoe oye ce Uo ea eee y Eu Ede Pea ee tie Sevens 33 THEREPORT EAUNCH DIAEOG Ire t ere ede eene Ue 33 FOLDER TREEVIEW CONTENT ETE qe eet 34 LAUNCH DIALOG MENU GENERAL Qhatun n et el ete Q ee eet EE 37 Character s ending Profile field names to indicate Treat field as
227. seseasevensessnssvonssesnsevensesensess 133 Creating Functional WorkboOks 133 Troubleshooting Reports esre it EHE EU eL ep de ta gea exp de AT e pde 133 Clean p After Yourself ee re t e e Net t d cnt eH pet et epe 134 Presentation FeadtWres iu e E que PP e e de Reed 134 DATA INTEGRITY TESTING tero ere derer onte ha qashan ete ee dete e eite tene vet eoe ere fae pore d ee xe EEUU 135 Finding Me 135 Exception Reports cero EE D E MR EU RE ed sees sade ea khus aD E e eter qe tt 135 REFERENCES nente Sete NSS SEA SS SS q s uw S qu S UG QURE SERE TET ES UE 137 APPENDIX A DETAILS TAB 2 1 1 00 enne nenne n teet E EEE earn REE S 137 APPENDIX B S AMPEE SESSION tee a eer eye Neue eur ime h e uS EN A edes S Sa EE Sa Sa 139 APPENDIX PRE FORMATTED REPORTS TOOLKITS AND 2 144 MasterMine Aliases for Database Tables eene ene enne 144 GoldMine Database Administrator s Toolkit DBMToolkit xls
228. sheet of the MMINI xls file to accommodate each database s SOL parameters This eliminates the need to re enter SOL parameters each time you access a different GoldMine database from inside GoldMine ServerName DBName UserName Password and BDEName should be well known to the SOL GoldMine administrator These settings are easily obtained using the Borland BDEAdministrator In GoldMine 5 x above go to the Tools menu and select BDE Administrator In the left column find the BDE alias that matches your current GoldMine contact set as named in the GoldMine Open Database dialog and click on it once The parameters you need will be available on the right side of the screen SaveTo Indicates the default storage location of MasterMine reports generated for SQL contact sets 27 Integration with GoldMine Add on Products MasterMine reporting and analysis extends your ability to work with some of the more popular GoldMine add on products If your GoldMine installation includes any of the products listed below you can integrate them by entering path information in Preferences Integrating Details Plus By Solica Consulting www solica com DetailsPlus is a very popular add on for GoldMine greatly extending the capability of one to many user defined Profiles on GoldMine s Details tab Native GoldMine w Preferences Details Plus Path to Application exe Enable g Details Plus Browse Q
229. sinc Customer Referral Suspect Engineering i i i Grady Dermott DLP Systems Inc LA Times Prospect Media functions including the Stephen Carnevale Madison Manufacturing NJ Trade Show Customer Engineering ii 1 1 Aaron Jamison Global Corp IL N A Employee N original one Rtrim 5 which Kenneth Spaulding Global Corp N Employee 44 George Vaughn Restoration Systems TX Web Import Past Client Aviation trims trailing Spaces from the Kam Smith Atlantic Machines NJ New York Times Prospect Media Danny Kinner Lambert Solution Techn TX Customer Referral Suspect Pharmaceuticals C1 SOURCE field Glenn Ramos GESCO International LA Trade Show Suspect Media 14 4 the contents of the field to be returned it is also logical to change the column heading the field name returned to the MasterMine report to reflect the new contents by typing a new wotd ot label in the Column heading box In this case it makes sense to change the heading to Source3 When finished click and MSQuery will automatically re query the data Check the new tetutned data below the header to make sure it is the desited result Adding or Changing Selection Criteria On the menu above click Criteria Add Criteria Select the desired Field Operator and Value from the list boxes provided You may enter a dBase or SOL expression instead of the Field name Simple Example You want to include o
230. source for just this month or for this month next to last month or the same month last year The possibilities quickly become apparent How are your users grouped in your business Group them the same way with MasterMine Compare their performace against each other and show trends over time What business processes do the reports show Calls per day and hour Sales follow ups by month Use MasterMine to compare plans projections and goals with reality Also consider reporting problems that you have had in the past Are you getting too many reports that tell you only partial information or that require you to juggle several printouts to find out what you really want to know As you get on top of what s currently happening in your business you may move on to planning for the future by asking What if If so you can use your MasterMine derived data as a source of realistic givens while you build scenarios and models to consider different possible outcomes from altering one or two variables A highly skilled Excel user can use MasterMine together with other scenario building tools built into Excel to reliably plan for the future based on solid information about the past The Art of Presentation Discovering important facts about your business is often more an art than a science When working with pivot tables your changes from one report to the next are so immediate that you can easily let your creativity take over without f
231. ssuming you wanted to build a report whose first several columns consisted of personal data such as names and phone numbers and that each name and number was unique in the report you could include the following before running into the 2 1 billion limit 3 columns of 1 285 unique items each 1 285 to the 3 power is less than 2 1Billion 4columns of 215 unique items each 215 to the 4 power lt 2 1Billion 5columns of 73 unique items each 73 to the 5 power lt 2 1 Billion 6columnsof 35 unique items each etc 35 to the 6 power lt 2 1 Billion Items per Field This is the most significant pivot table limit as far as reporting is concerned A field in the Page Row or Column areas of your pivot table may not contain more unique items than the limits shown in the table above If you attempt to pull in a field containing more items than he limit you will be shown an error message This limitation is the best reason to upgrade to a later version of Office if you have a large database that is one containing more than say 20 000 account records or if you wish to report on details of completed activities mote than 30 000 history records 177 Index JeButt on launch qana 70 87 Add Field tenete 73 frfrOWYtoday serene 77 Apply Filter Across Tabs sss 76 AutoFormatting 134 Automatic Refresh sussistere 134 Background Query ses 108 Bug Reporting eet eterne 19 Calcu
232. st by checking them in the list box this is the easiest time to include fields you may want later Therefore as long as it does not unduly slow your query or cause the pivot table performance to be sluggish you should include any related fields that may be needed for the report you are currently building AND any derivative reports you may wish to make in the future How to find the fields you want to include In most cases MasterMine displays fields using the User defined Labels assigned by your GoldMine database administrator This is so that you do not need to know and translate GoldMine labels to the underlying database fieldnames in dBase or SQL However the fields ate sorted by database Table Contact1 Contact2 Cal ContHist ContSupp etc so that the user can find and connect these fields in a logical manner Therefore fields appear with a prefix of C1 C2 etc corresponding to the table from which they derived Note that MasterMine includes many fields that are not really fields in GoldMine That is they are logically derived from data that is stored GoldMine but the data has been converted to a more useful form for reporting purposes To take simple example GoldMine stores the duration of an activity in the form HH MM SS for hours minutes seconds which is not an easily reportable format In addition to providing you with the raw Duration field from completed or pending ac
233. sterMine Pivot Table Control Stats Drilldown Connection Query Text Security About database name This will simplify updating existing MasterMine reports to use the new data location because you will need to change the reference only to the server here Query Text The entire Transact SQL statement Query that underlies the pivot table may be viewed and analyzed but not altered within the Query Text tab Users who know SQL expressions can see precisely what data transformation if any a field has undergone prior to being presented in the MasterMine report Most MasterMine fields include some type of formatting error trapping or other data transformation so it is helpful to be able to view the expression that underlies a field here If you wish to alter the underlying query using MSQuery you can hit the Modify Query button beneath the query display OR hit the Query Wizard button Excel PivotTable toolbar while a field ON the pivot table is selected see Modify Existing Query Chapter 6 E Note that if you hit this PivotT able toolbar button and the cursor is not on a PivotTable the PivotTable Wizard will attempt to create a new table with a new query Security Parameters for Current Workbook Security Selections will affect all pivot tables in this workbook Enter password to To prevent tampering or to disallow access to sensitive data in protect selection Disable data refresh Di
234. t fields to include a x are user defined Profiles relate to the rest of C1 Contact v Status v CS ccountNo 2 B v 1 v CS VAR Contact v CS CSRecords GoldMine s data you may find it difficult to make CS CSRecordT ype v 5 Company v 5 5 1 CS Detail Type v CS CSAddress3 CS CSNotes sensible Pn learn More about Profiles v CS Detail Ref v CS CSDear CI State in GoldMine s Help or in the GoldMine User v CS GM License CS CSFax vi C1 Source v 5 License wv CS CSCreateOn v C1 Account Type Manual This will prepate you to report on this vital CS Version CS CSLastUser v C1 Status GoldMine data v CS Date issued v CS CSCity v C1 MM Partner v CS Userstit v CS CSLastM odified v C1 Account Rep T Once you understand Profiles you can use MasterMine to leverage this powerful component of Report Name GM Master License SaveTo Path C AMasterMine Reports E 45 Save To Template Filter Finish Cancel GoldMine even better This knowledge will also help you to set up preferences and tweak Profile field definitions so that you can get the most from the information contained here If your reports do not work as expected see the section on Appendix A Details Tab Reporting on page 137 If you use DetailsPlus an add on for GoldMine from Solica Consulting Ltd and you have entered the proper in
235. t was at the time the report was built If you remove members from a group those members will no longer be refreshed into an existing MasterMine report Also note that GoldMine allows the creation of multiple groups with the same group name If a group name is selected for which there are multiple groups MasterMine combines all group members from all of the groups into a single report You can use MasterMine eff to quickly and easily build GoldMine Groups See Create and Use GoldMine Groups page 112 These groups can in turn be used to filter a new report This circular technique is often used to methodically hone a report down to a set of records that meet many different kinds of criteria without needing to build a single filter or query that logically includes all the criteria Filter on Key Values Allows you to select a section of GoldMine data according to the contents of the key fields from GoldMine i e those fields in the lower right quadrant of the standard record screen In most cases these fields represent key points of information about your clients and prospects and therefore allow you to include only major segments of your account database For example if you have a Contact Type field that includes lookup items Clients Prospects Employees you might use Key filtering to set up your report to exclude Employees since they will never be required for the report By default all poten
236. table entirely Prospect Custome Past Client Grand Total Pivot Table Field List which appears when you click anywhere on the pivot table and the Field List is turned on To turn on the pivot table field list right click on any cell on the pivot table and click Show Field List at the bottom of the short menu By dragging and dropping fields to different areas of your pivot table you can create all the basic reports you need Some additional organizing and formatting 1s desirable but this one simple skill gets you most of the way to a finished report in seconds Note This example is drawn from an Excel 2003 environment If you have another version your environment may vary slightly from this one so try it on your own to see the differences Report Types You can create an infinite variety of reports in MasterMine Here are some basic report types and steps to create them Summary Report The simplest report is a summary that rolls up information into an overview Any report you create in MasterMine can be quickly formed into a summary like this one In this simple summary report a single field Contact Type has been dragged into the Row atea The result is a breakdown of the database showing each value in the Contact Type field in GoldMine and a count of the occurrences of each one Note that the Field Items shown are those that actually occur in the database not a list of possible items or the list
237. ted MasterMine assumes the entire sheet of records is to be added to the group Select multiple rows or simply cells in a single column Use GoldMine groups to track campaigns send mass e mails do global replaces and many other valuable cross account activities in GoldMine 78 E Pop Record Edit Activity MMUpdater Finalize 2 Lindo Drill Preferences Pop Record Switches to GoldMine and loads the account record that corresponds to the currently selected row This action is the same if you double click on any cell in the target row on the drilldown sheet Edit Activity For reports that contain pending or history records this function switches control to GoldMine loads the account record AND opens the selected activity record for editing MMUpdater For the selected cells or entire column push the highlighted data into GoldMine records This extremely powerful utility is an optional add on to MasterMine available by separate licensing Full instructions on MMUpdater are in Chapter 9 Data Management under MMUpdater Finalize On an MMUpdater Logsheet after a test run that created the log commit the changes on the logsheet to GoldMine Undo Return updated fields on an MMUpdater Logsheet to their original values After updating GoldMine whether by finalizing a test run or after a non test run of MMUpdater click Undo to reverse the changes made to GoldMine This undo process is not a t
238. ted dollar values of sales pending e Probability CARecords adjusted for probability per sales records a sale with 70 probability is counted as 7 of a sale and summed accordingly e Probable Units Sum of units adjusted for probability A 3 unit sale with 70 probability counts here as 2 1 units 140 13 14 e Probable Sales Vol Sum of dollar values adjusted for probability A 500 sale with 70 probability counts here as 350 The fields in column A stacked above the table itself are Page fields available for dragging into the table itself or by selecting elements in their list boxes for setting parameters for the report Blue fields are Contact fields from the Contact table in GoldMine green fields are Calendar fields from the Cal table GoldMine Because the parameter Linked to Contact is set to Yes our report includes onl P P y pending sales that are linked to a contact in the current GoldMine contact set Manipulate Table Layout 15 16 17 18 19 20 21 To view the data for a single user click the down arrow list box to the right of USERID and select that user You can do this for any of the criteria shown on the screen or any combination of them Try this Show the potential and probable sales for prospects from one source like Trade Shows for a given product and a particular salesperson If you keep additional prospect group information in in
239. tem Set Page Filters Across Multiple Pivot Tables and Worksheets sophisticated reports often end up with many views of the same data cloned into many wotksheets within a single workbook You may wish to set your filter selection once for similar reports across the entire workbook rather than going to each worksheet Here s how after selecting a Page field value to filter data in one pivot table double click on the same value MasterMine asks if you want to set this value for this Page field in all pivot tables in the workbook Filtering in the Row or Column Area simply but with fewer visible cues you may filter your report by hiding some field items in a displayed field With your field in the Row or Column area click the dropdown arrow on the right side of the field This shows a checkbox list of all items in the field This list includes all values that have been in this field in your GoldMine database any time this report has been refreshed Uncheck any items that you would like to hide from your repott This filtering effect follows the field from then on even if you drag the field to another area unless you check these hidden items on again It only stops filtering on the data shown if you drag the field off the pivot table entirely to the Pivot Table Field List Effects of Hiding Field Items Having hidden items in your fields can have several important implications 97 e Hiding field items reduces
240. tem in the Data area that interests you MasterMine creates a new worksheet giving a line item view of all underlying data for the item selected on the PivotTable The column heads are your fieldnames as they appear in the pivot table version of your MasterMine report The drill down screen itself can be viewed as an instant report as in Give me a list of Columns appear in the order they are listed in the underlying query You can control this order either by sorting the fields at the time you create the report or by modifying the underlying query using MSQuery as described in a later chapter If you have substituted new labels for any of the fieldnames or for field items the substitute name will appear in the drilldown sheet by default This feature can be turned off so that you see the raw data instead MasterMine Pivot Table Control Stats Drilldown Connection Query Text Security About You have several options regarding how to display data in a drilldown sheet which you can control in one of two ways From inside a drilldown sheet double click on the header row row 1 Or from the pivot table Drilldown from PivotTable to Line Listing sheet click on the information button and go to the Do not format data or headers on Drilldown sheet Drilldown From Excel to GoldMine Drilldown tab Check Do not format data or headers on Drilldown sheet to ignore field or field item substitutions as well
241. the MasterMine application tree on each workstation This ini file is updated by changing the settings in Preferences Ir Character s ending Profile field names to indicate Treat field as Date ending Profile field names to indicate Treat field as Numeric Ini settings may be shared among multiple workstations by copying the file MMini xls from 20 7j Standard length to pull from Reference Product field 0 all one workstation to that of any other MasterMine user They may also be updated directly by 1 1 1989 v Default Start Date for History Data opening the MMINI xls file in Excel and applying 1 1 1989 gt Date to substitute when date fields contain no data or unreadable date value changes manually Save SQL Reports to C MasterMine Reports Browse GMSQL MasterMine keeps track of the SQL login information needed to access the SQL tn DNE ERE database This information is required during installation and again later if MasterMine fails while attempting to log into SQL when launched On a separate tab in MMINLIxls called General Preferences Preferences set on the General tab affect how MasterMine builds field expressions whete repotts ate stored Character s ending Profile field names to indicate Treat field as Date and Character s ending Profile field names to indicate Treat field as Numeric These 2 character codes designate field ty
242. the past 90 days e g no successful call appointment or e mail See GM help for Last Contact On definition Use reports in Activity Analysis toolkit for finer Last Contact Over 90 Days distinctions of what constitutes contact C1C2 148 Workbook Name Description GM Tables Analysis of all prospects by how recently an attempt was made to contact including GM phone dial See definition of Last Most Recent Attempt Attempt in GM help C1C2 Referrals Analysis of client referrals by quantity and quality CSC1RFCFC2 Analysis of pending sales linked to the original referring client Referral Sales Pending including probability schedule summaries CSC1CARF Referral Sales Completed Analysis of closed sales linked to the original referring client CSC1CHRF Analysis of pending sales by client creation date including Pending Sales by Original Entry probability schedule summaries and linked to basic client Date info like source key fields etc CAC1C2 Analysis of pending sales from clients added in the last 120 days including probability schedule summaries and linked New Client Sales Pending to basic client info such as source key fields etc CAC1C2 Analysis of sales cycle which is number of days between the date the sale was forecast CH CreateOn date and date sale occurred CH OnDate Shows count of sales summaries Sales Cycle by Date Forecast etc CHC1C2 Analysis of sales cy
243. their query If you need more than the first 253 characters check on additional segments as necessary Be sure to start at the first notes field and check on additional segments sequentially Checking too many notes fields will make your report querying very inefficient and may overflow machine memory in extreme cases In your pivot table these segments behave the same as any other field except as follows 1 Ifyou display a notes field in your pivot table Row Area the Optimize Columns button on the MasterMine toolbar sets the width of that column to 50 characters and wraps its content into multi line cells for easier viewing 2 In the Row area non printable characters in the field such as carriage returns and line feeds appear as square boxes and do not cause an actual carriage return 3 When you drill down all note segments are re joined into a single column and re formatted for easy reading Inexperienced users often don t realize that seeing notes is very easy to do by drilling through a MasterMine report to the relevant GoldMine record If possible include notes only if you know you will need to see them in your report HTML code in Notes fields GoldMine includes HTML formatting codes in notes fields in its default setup SQL versions of MasterMine since 5 1 have automatically included an HTML filter to prevent these codes from appeating in reports This filter is a user defined SQL fu
244. them sequenced properly starting with Opt1 Opt2 etc MasterMine adds a series of user defined functions to the SOL Database as well Your SOL administrator will find these functions by looking for Scalar Valued Functions with names beginning with udfMM These may be safely deleted if the rest of MasterMine has also been deleted Uninstall will not remove xls files initiated and saved from MasterMine templates after installation is complete By default these files are located for dBase in MasterMine sub folders of the contacts sets to which they refer or for SOL in the folder indicated by SaveTo in MMINI xls 32 Chapter Launch and Manage Reports You have a choice whether to launch MasterMine from a GoldMine menu from the taskbar in GoldMine or from its own GoldMine menu MasterMine Menu Launch MasterMine s installation creates an entry in GoldMine s File menu ot GoTo Menu or View Menu in earlier GoldMine editions only for the user who was logged in during installation After installation log out and back into GoldMine to see the menu item New Import and Export Print a Report Another launch item is added in the GoldMine taskbar under the name MasterMine if the user elects to allow its creation during installation The MasterMine taskbar item can be removed using the Log Away taskbar Customize dialog It can be moved or removed from the GoldMine menu item by editing
245. tial values are included Build your filter the most efficient way either by eliminating a few of the checked boxes to exclude only a few items or by switching off whole fields and then re including one or a few items Hit the Count button to see immediately how many records match your criteria Pre counting is only possible for relatively simple queries N A will appear in the Number of Matching Records box if the query is too complex to be pre calculated Remember that if you set criteria for more than one field a record must meet the criteria for BOTH fields to be included in the query If the count is 0 your criteria may be too restrictive That is you may have eliminated all records in the database from the query When you hit Finish to run such a report a warning message box appears and you must re select filtering criteria 56 When dealing with large databases there are several reasons to hone your quety in advance Faster loading and refreshing are obvious benefits Most importantly pre filtering allows you to handle limitations in Office 97 and 2000 on the number of unique items that may appear in a pivot field Filter on History Dates If your selected report includes a query of history completed activities the history filter is enabled so that you can limit the query by date This 1s the same First Date field that appears on the main MasterMine dialog screen If you have already set t
246. tions Settings Now you can hide any of Data source options External data options the items within the field by selecting V Save data with table layout V Save password them the box below Watch the Enable drilldown Background query Pivot Table Grand Total as you hit Refresh on open Optimize memory the button after hiding some Refresh every minutes items The Grand Total will decrease by the count of the items you hid cen Be careful There is no other indication on the report that it excludes certain items in this field or that subtotalling in the Pivot Table excludes them You may wish to make a note on the sheet to this effect so that you don t draw false conclusions later on Preserve Formatting Should always be left checked if you want to retain field formatting colors that reflect source files for instance 107 Page Layout Gives you the option of listing page fields in several parallel columns instead of one long one This can be very useful if you like to keep a lot of fields in your Page Area fot easy access Data Options Save Data with Table Layout Unchecking this box saves disk space when saving large Pivot Table reports However when reloading you will always have to explicitly refresh data before you can see anything unless you use Refresh on Open This option automatically refreshes the PivotTable upon opening In the case of large source files this
247. tivities as GoldMine stores it MasterMine converts this field into a numeric field called Hours and another numeric field called Minutes which can be easily grouped and summed for time based reporting This manual includes a faitly comprehensive description of the GoldMine data structure in the References section at the end Obviously the references here cannot include fields unique to your customized GoldMine installation In general note that Contact level user defined fields found in the Contact2 table and their database names begin with the letter U MasterMine also includes fields from user defined Profiles Details and from the Opportunity Manager and Project Manager tables Depending on your access rights in GoldMine you can Ctrl DoubleClick on a field in the main GoldMine screen to see that field s database name and definable attributes Why limit fields to include System performance is directly affected by the quantity of data both number of fields and number of records from which those fields will be drawn With a fast machine and Office XP or higher you are limited only by the available RAM on your computer and to some extent by the potential complexity of your displayed data see page 174 In Office 2000 and eatlier Excel reserved only 100 MB of RAM for a given pivot table query so bear this limitation in mind when selecting your fields Excel 2000 users with a very large database more than
248. tivity table and Contactl If three tables are involved such as Cal Contact1 and Contact2 an inner join is used Some templates expressly reverse this join including all contacts regardless of whether they have activities linked to them but also include the pertinent activities An example is the All Accounts and linked pending report see Use Template below 46 Design New MasterMine is designed to make it easy to create reports from scratch to go from idea to report in only a few seconds without necessarily loading a template Many users will take the route offered by traditional report writing software and simply create a new 4 report for every use enjoying the short time to outcome confident that there Create New MasterMine Workbook File Toolkits SQL Query Preferences Help Which part of GoldMine s information do you want to see Design New C Use Template Contacts forgotten filters or setup quirks in their new Main report Additional Activos gp arm a caa s For this approach the default Design New serves the purpose If you have selected the Activities area of your GoldMine data to view the window under Design New will also display a list of Activity Types tracked by GoldMine In the list check one or more activity types to include in your report By default MasterMine produces a count of each of the sele
249. to read this user manual and you are already familiar with Microsoft Excel PivotTables at least read this chapter to get started It contains evetything you need to know to generate new MasterMine reports You can learn the rest by doing or by reading later chapters Open MasterMine Report is a standard Windows dialog that provides access to the MasterMine generated workbooks reports you have created and saved Initially of course there are none so this dialog will be empty More on this dialog later Create MasterMine Report Launches the MasterMine report generator featuring an intuitive interface that makes generation of new reports a snap The rest of this chapter covers the usage of the MasterMine Create dialog Generating a New Report MasterMine is designed to make extracting information EASY You simply select which category of information you want to report or analyze and MasterMine presents it to you in the flexible analytical format of a pivot table Typically the process includes these steps e Select data category Select fields to include optional Sort fields for drill down presentation optional e Add macro filtering criteria optional e Hit finish 43 E Create New MasterMine Workbook File Toolkits SQL Query Preferences Help Which part of GoldMine s information do you want to see Contacts Main Additional C Activities Pending History Details
250. to say Workbook or Worksheet to refer to the specific item rather than a Report Since Report is the most common way of referring to MasterMine output we use it frequently here with the expectation that users will understand in context Once a Report is created initially as a single worksheet in a new Excel workbook it can then be quickly cloned tweaked and multiplied into a wide range of derivative Reports some as additional worksheets within the original workbook and some as 61 whole new renamed copies of the workbook Users therefore sometimes think of every report as a template of sorts although the term template has a specific meaning in MasterMine Templates and Toolkits A Template is a model or set of pre determined parameters against which a Report is created Templates cannot be changed by the user The reports they create however can be infinitely varied MasterMine comes with more than 125 templates each of which can be quickly filled with GoldMine data to create a new Report Since each time a template is used a different set of fields might be included or a different filter applied These templates are infinitely re usable Beginning with version 6 0 MasterMine allows users to create new User defined Templates Creating a new template starts by selecting an existing basis template selecting fields to include and sorting them then saving the result with a user speci
251. to this manual are made the latest release will be posted for free download at MasterMine s website www mastermine net Likewise current upgrades product fixes and enhancements can be retrieved at any time from our website xi Chapter Introduction Is MasterMine Right for You What MasterMine can do for you MasterMine data analysis and reporting tools are for users and managers of enterprises using GoldMine as their Customer Relationship Management CRM system Your GoldMine data is a mother lode of up to the minute information about your business its internal processes and its future prospects MasterMine tools allow you to easily and flexibly extract organize and analyze that information to vastly increase the value your company gets out of GoldMine Following is a brief explanation of some ways you can use MasterMine to help master evety aspect of your business Any organization that tracks its interactions with a large number of outside contacts in short virtually any organization that uses GoldMine can benefit by analyzing the flow of activity in relation to those contacts with MasterMine Like GoldMine itself much of the functionality in MasterMine anticipates uses in a sales environment But remember that you can use MasterMine to create meaningful analyses for every part of your business that GoldMine touches Who should use MasterMine Every manager MasterMine software is designed for anyone managi
252. ts by opening the Information Display Dialog see The MasterMine Pivot Query Display page 83 and going to the Connection tab On this tab overwrite the old Server name value with a new one and click Apply 129 Changes below When you next refresh your report is current and can be saved in the same location as the old one If you changed both the GoldMine database name SQL and the path to the GoldMine data dBase you need to change both in the underlying query We recommend calling MasterMine for online help to do something this significant 130 Chapter Managing Your GoldMine Business MasterMine reports can be used to improve management productivity and effectiveness in a variety of areas data mining simple daily reporting and data integrity testing You may find that your own best uses are not even on this list Keep your eyes and mind open to new opportunities to learn about your business at all times Introduction to Data Mining Data Mining is a relatively new concept for most business managers but a very powerful one Simply put Data Mining is about knowledgeably digging through and arranging your data to elicit information about evety aspect of your organization MasterMine gives you a tool to do just that Data Mining asks the same questions you ve been asking all along How ate we doing What are we doing well Where are the hidden weaknesses in our business processes What parts of our processes should
253. ty in managing and sharing existing reports and on making MasterMine s report re design and slice and dice functions in Excel more accessible and user friendly 1 Report Management Interface Launch to directory dialog showing paths to all MasterMine reports previously used Easily navigate to recently used reports create or open Excel Ribbons Excel 2007 and higher Functions in Excel to facilitate analysis reporting and data updating now reside in Ribbons organized functionally Many new functions make it easier than ever to modify existing reports to do new tasks rather than require building new reports Improved communication with GoldMine Using recent API calls interruptions and slow downs formerly caused by DDE are eliminated providing instead a faster and more reliable drillthroughs group building and updating to GoldMine New time saving functions in Excel Add fields to existing reports delete un needed ones re arrange fields for drilldown are a few examples See the chapter on Excel Ribbons below 5 New Templates New user friendly templates make use of user interrogation functions to broaden the scope and specificity of new reports Note Interim releases of MasterMine since December 2011 have included a large number of bug fixes and minor enhancements continue to be enumerated in the Release Notes txt file included in the installer installed to the MasterMine application folder Getting H
254. ude any new fields in your Pivot Table by clicking Next to get to Step 3 of 4 and arranging the fields for the new table as desired Formatting After Query Modification e Your new fields will remain hidden if you do not explicitly place them in the Page Row Column or Data areas e Any changes to field names or dBase expressions invalidate previous aliases you may have assigned These fields must be re introduced to the Pivot Table active areas and given new aliases e When done click Finished to see your Pivot Table refreshed with the new data e You may wish to leave your user defined field buttons black or for consistency to re format the color to match the appropriate source database Use the table of colors under References GoldMine Data Sources as a guide 128 e If you have changed the tables or selection criteria we recommend refreshing your MasterMine Display Box to reflect the changes Otherwise you may misinterpret future reports taken from this data To refresh click once on the yellow down arrow button on the Display Box at upper right Redirect to a New Data Source You may occasionally need to redirect a MasterMine report to a new data source This might happen for instance if you install a new version of GoldMine and re host data to a new server Especially if you have a lot of reports with sophisticated setup in them you might want to preserve that work by re pointing to the new data source
255. ues MasterMine remembers the last entered A Al Key Field Values first date and defaults to it next time All Values for Contact Type All Values for Status IJ All Values for Reseller Additional filtering criteria All Values for Account Rep MI All Values for Product If desired click Filter at the bottom of the page to pre filter your query so that your workbooks can more elegantly pivot around only the part of data of interest to you Filtering options are as follows Number of Matching Records Count Use Active GoldMine Filter If checked on and a filter is active in GoldMine that xj L filter will be applied to the new query The checkbox is disabled if no filter is active in GoldMine i Finish Cancel 55 Use GoldMine Group May be used in combination with GM filter This powerful option limits the query to members of a GoldMine group After the report is created if membership in the group changes and the report is refreshed the new group membership will be represented in the report Upon selecting Use GoldMine Group the user is given the option of selecting a different GoldMine user whose Groups are then made available in this list box Tricks Using GoldMine Groups A MasterMine report based on a GoldMine group will change as membership in the group changes That is each time you refresh a MasterMine report it references the group as it is at the time of refresh vot as i
256. unctionality C Ask user each time which Office format to save to 5 Therefore when creating new reports with Office 2007 it is necessary to choose which version s format to store the report Typically if every computer that might be used to share MasterMine reports has Office 2007 you will want to automatically save every report as Office 2007 compatible Cancel Save and Close If only some wotkstations have been upgraded you may wish to select compatibility each time a new report is created You may set the preference to always create in Office 2003 format but note that this will limit your memory usage to Office 2003 limits and this may deprive you of some useful functionality 39 Preferences Defaults Preferences MasterMine offers a number of options regarding the initial setup of newly created MasterMine workbooks Users who have some experience with MasterMine can shortcut some of the formatting choices that would normally be made later in the process In setting yout choices here bear in mind that doing so might leave users unaware of formatting choices that are available Hide page fields set to AIP Compatibility 002 000 New Report Defaults Hide page fields set to All Hide page fields with no valid items long list of fields in the Page filtering area of the report The user is expected to make filtering selections Turn off subtotals for all fields ot to pull these fields into
257. uoteWerks Path to Application Enable g Quotew erks Browse QuoteWerks Database Demo zl Cancel Save and Close account information makes ten text type fields plus one notes field available in a Profile DetailsPlus makes available all 14 fields plus two notes fields in the ContSupp table Most importantly each field can be defined as a character numeric or date type field with full data entry validation on a uset configurable screen layout MasterMine reads this profile configuration so that DetailsPlus fields are formatted automatically using the proper field types This allows you to take advantage of MasterMine s sophisticated numeric and date grouping and analysis capabilities correlating DetailsPlus profile records with main To set up the integration launch the Preferences menu in MasterMine s Create New Analysis Workbook dialog Click on the Integration tab Check the box to Enable DetailsPlus then browse to enter the path to the DetailsPlus application Typically this is a folder named something like C Program Files VSolica DetailsPlus containing the file DetailsPlus ini Once this integration is set up MasterMine presents DetailsPlus defined profiles in the Profile Type window and Details Plus fields in the field list box as though they were native to GoldMine Integrating QuoteWerks Quote management software by Aspire Technologies www quotewerk
258. up Open Report Opens another MasterMine report within the same instance of Excel currently being used This allows users to transfer tabs and copied text including whole pivot tables between masterMine workbooks for easy sharing As a means to aggregate a series of reports from various selected workbooks this function is very useful in creating Digital Dashboards User manual Opens the MasterMine for GoldMine user manual as a PDF document You must have Acrobat Reader installed on the workstation About MasterMine Displays current version and location information about MasterMine GoldMine and Excel The MMTools Ribbon Gail s AMR xls Compatibility Mode Microsoft Excel PivotTable Tools Formulas Data Review View GoldMine MasterMine Options Design MM Tools d 2 RollDown Field 3 Group selected items Fiscal Year e gt o Number formats by field 1 ne LE v RollUp Field 2 Add to group t Week Grouping d 45 520 Search Field Apply Filter Bate Tetas Numeric Text as Content AcrossTabs Subtotal On Off Ungroup Range Age from today date Range numeric Active Field Group Date Field Functions Numeric Field Functions The MM Tools ribbon is available whenever you have a MasterMine workbook open in Excel AND a cell is selected on a pivot table The functions on the MMTools Ribbon in Excel provide easy shortcuts to manipulate your pivot tables and to format your data These functions build up
259. ur system RAM is quickly used up when you load the workbook again Presentation Features Excel provides a number of formatting and display features that can help make very impressive presentations from MasterMine reports You can leatn about them in depth from the Excel help menu or by using a number of fine books on Excel AutoFormatting Once your data is arranged as you like it you can select the most impressive format for presentation Start by clicking anywhere on the Pivot Table and select menu Format Autoformat Now you can choose from 16 different pre defined formats for your data or at the end none Be careful Excel has not yet worked out the details of combining autoformatting with Pivot Tables So when you select none your Pivot Table will no longer have borders We hope Microsoft will resolve this issue in the next version of Excel Charts amp Graphs One of Excel s most powerful features is its built in charting capability You can use your MasterMine reports as the basis for any chart Data must be arranged in a similar fashion when creating an Excel chart Use the PivotChart button on the Options ribbon built into Excel Set the parameters for your chart just as you would with an Excel chart Automatic Refresh Setting a refresh time on yout live reports gives you current information at any moment on key business processes without intervention on your part Among the many formatting feat
260. ures available on your Pivot Table Options panel right click on the table and select Table Options is Refresh every __ minutes on the bottom left This allows you to turn your dynamic report into a real time display Anyone familiar with Microsoft s Digital Dashboard will appreciate how easy this makes building your own dashboard element 134 Data Integrity Testing Finding Out liers One of the most powerful uses of MasterMine is finding data that don t fit your company s prescribed policies or that are inaccurate simply because of data entry errors Some can be merely irritating while others like a sales follow up call scheduled in the wrong year ot a missed appointment might cost you money As you wotk with your regular management reports you will often come across out liers odd records that stand alone in a schedule or that don t fit your regular data pattern Before changing the data check to make sure that the user who made the mistake is well informed about the cotrect way to enter data You may uncover similar mistakes in a pattern that suggests training issues Next to correct the errors you have uncovered MasterMine s built in Drilldown feature becomes very handy Drill down to the original GoldMine record to correct the data While there check around fot other errors in the same record Each successive drilldowncreates new spreadsheets in your workbook Don t forget to delete these when
261. vities linked to contacts and any profile record Pending Activities amp Counts one of EACH for every occurrence of a match so Contact amp Details Profiles filtering must be done on the page CACSC1C2 Completed activities linked to contacts and any profile Completed Activities amp record Counts one of EACH for every occurrence of a Contact amp Details Profiles match so filtering must be done on the page 5 1 2 Supplementary info including user defined profiles referrals document links and other specialized GoldMine info Supplementary records profiles referrals doc links etc linked to primary contact info including user defined fields CSC1C2 records of completed activities Analysis of ContHist log records generated if GoldMine s History Log feature is turned on Will result Records History Log Analysis message and aborts if feature is turned off CHC1C2 Supplementary Contacts Additional Contact records linked to main contact info CSC1C2 CS H QuoteWerks Toolkit MMQuoteWetks xls MasterMine for GoldMine includes a QuoteWerks toolkit that integrates GoldMine data with QuoteWerks data into seamless reports Integration with QuoteWerks is described elsewhere this manual Here are details on the reports and tables available from QuoteWerks for reporting Alias Table C1 Contact C2 Contact2 CH ContHist CA Cal CS ContSu
262. will be analyzing To work with relatively small GoldMine files you should have at a minimum a Pentium processor with 512MB of RAM Larger data files process much mote conveniently with a faster processor and more RAM Since Pivot Tables operate by holding and manipulating large amounts of record level data memory it follows that the more memory available the better To estimate memory requirements assume you will need roughly 25 to 75KB per record and multiply by the number of records in your largest database file probably ContHist For example a ContHist file with 100 000 records requires 80MB plus the roughly 48 needed for the program files involved totaling roughly 128MB of RAM How MasterMine Works The MasterMine analysis engine loads your current data into MS Excel Pivot Tables to create dynamic overviews of all GoldMine data in every possible useful combination Based upon the internal logic of GoldMine and your customized setup MasterMine formats the data and renames fields per your local labels in GoldMine Managers who have used Pivot Tables in the past know that they are very easy and powerful to use but are notoriously difficult to set up MasterMine handles the part so you can reap the benefits features contained in the MasterMine Toolbar in report Group Building functions Drilldown to GoldMine and GoldMine Group Creation all uniquely integrate the power of Pivot Table reports with GoldMine t
263. word Where password is the SQL password and the line terminates with a semicolon Changing Data Connection Strings Note that changing the DATABASE name here may not fully accomplish a transfer of your report to a new server database combination The database reference may also be contained in the Query Text which must be updated on the following tab In many cases it is Stats Drildown Connection Query Text security About not possible to update both the SQL Server name AND the This text defines the data returned to your pivot table Select Rtrim C1 CONTACT AS Contact Rtrim C1 COMPANY AS Company CA RECTYPE AS Activity Type Rtrim CA COMPANY AS CAContact Database references simultaneously Therefore we recommend removing explicit database qualification from the Query Text first then making changes to the SERVER and DATABASE parameters on the Connection tab Coalesce CA OnDate 1 1 1989 AS OnDate Datediff day getdate CA OnDate AS DaysTill Rtrim CA USERID AS User ID In general it is a good practice when moving a GoldMine Rtrim CA ACTVCODE AS Activity Code database from one server to another to avoid changing the Rtrim CA REF AS Product substring CA Ref 1 20 AS Short Reference Coalesce CA OnDate 1 1 1989 AS OnWeek Convert float Coalesce CA Duration 0 100 AS Probability Coalesce CA Duration 0 AS Duration n 85 Modify Query Ma
264. workbook as long as you wish That is you might save and close your workbook containing the Logsheet then open the wotksheet some days later activate the Logsheet and click Undo on the MasterMine Drilldown ribbon Ideas for MMUpdater tasks The most common process is to type over the data in cells you wish to update in GoldMine However if you apply some imagination you can use MMUpdater to accomplish many other useful functions Note that MMUpdater does NOT require you to update data in place That is you may insert a new column in your spreadsheet and use Excel formulas to construct an entirely new value from other data on the spreadsheet or a calculation of some kind If you do make sure you add a header in Row 1 and format that header the same as others in the row You may also update for example a Contact2 field with the total sales to a given client for a particular date range thus allowing GoldMine users to see within the contact record an accurate number representing total sales for the client This may also help you create some otherwise tricky reports since you can use such fields in a new MasterMine report to correlate filter or sort on sales figures together with other demographic data A final example is a common real life GoldMine need updating codes in data to match a new coding schema for pending or completed activities Say your organization sets up new rules for coding completed calls including
265. y Company C amp OnTime CA DaysTill CA Short Reference C Product CA Probability CA Duration CA Meeting Confirm Report Name Pending Activities All SaveTo Path C MasterMine Reports 29 Save Template Filter Finish Cancel These steps are explained in detail here Select data category Select the part of GoldMine you wish to analyze or report The top left of the main screen shows the available areas GoldMine from which you pull information These include at least e Contacts e Activities e Details with subcategories under Contacts Main and Additional and Activities Pending and History If your organization uses GoldMine Opportunities Projects or for GoldMine Premium Edition higher Cases these can also appear in the list They can be turned on at instalation time see Installation page 21 or at any later time using the Preferences dialog page 38 Your first choice specifies which GoldMine area you intend to report Once you ve selected the area you can easily build a report from scratch but specifying more narrowly which subtypes of each data with which you wish to work Alternatively the following section discusses existing template selection once the GoldMine area is specified Contacts You can report on only main contacts by checking Additional you can include the contacts on the Contacts tab GoldMin
266. y Wizard is a simplified querying tool that is too simplistic to handle the existing quety which causes this message to be raised Click to launch MSQuery the built in graphical interface that Office provides for the purpose of modifying Transact SQL Note that MasterMine uses some syntax within its queries that provides some complex relationships in the data while at the same timing making graphical management of the query in MSQuery impossible In order to prevent MSQuery from automatically attempting to repair the quety which would actually invalidate it MasterMine surrounds the alias of the first field with square brackets thus disabling both the automatic repair and graphical query management Where do you want to put the PivotTable report C New worksheet Existing worksheet er Click Finish to create your PivotTable report If your quety is too complex in this way to be presented graphically you can still modity the query manually by clicking the SOL button under the menu bar For more on editing the underlying query see Modify Underlying Query Chapter 6 Show Stats In addition to information about the pivot table overall Stats includes background on the selected pivot field Again this helps a user understand the source of data in the report Here the user can determine the type of underlying data usually SOL or dBase the date the query was last refreshed against the GoldM
267. ype OT RECTYPE OT RECTYPE OT Team Member Rtrim OT CONTACT OT CONTACT OT MemberDepartment Rtrim OT COMPANY OT COMPANY OT MemberTitle Rtrim OT NAME OT NAME OT MemberRole Rtrim OT STATUS OT STATUS OT OTAccountNo OT ACCOUNTNO OT ACCOUNTNO 164 Source MM Field SQLExpression dBase Expression TeamRecords OT RECID OT RECID OP OPRectype OP RECTYPE OP RECTYPE OP Competitor Rtrim OP COMPANY OP COMPANY OP Product Rtrim OP NAME OP NAME OP Strengths Rtrim OP STATUS OP STATUS OP Weaknesses Rtrim OP CYCLE OP CYCLE OP Rating Rtrim OP SOURCE OP SOURCE OP Status Rtrim OP STAGE OP STAGE OP CompContact Rtrim OP CONTACT OP CONTACT substring No Yes 3 datalength OP ACCOUNTNO 20 OP Linked 1 3 iif OP ACCOUNTNO is null Yes OP Comp Notes udfDBO udfMMStripHTML OP NOTES OP NOTES substring udfDBO udfMMStripHTML O OP Comp Notes2 P NOTES 254 253 mid OP NOTES 254 substring udfDBO udfMMStripHTML O OP Comp Notes3 P NOTES 507 253 mid OP NOTES 507 substring udfDBO udfMMStripHTML O OP Comp Notes4 P NOTES 760 253 mid OP NOTES 760 substring udfDBO udfMMStripHTML O OP Comp Notes5 P NOTES 1013 253 mid OP NOTES 1013 OP OPAccountNo OP ACCOUNTNO OP ACCOUNTNO OP CompetitorRecords OP RECID OP RECID Ol OlRectype OI RECTYPE Issue
268. z Group Field Items This button groups selected field items and creates a new field in which the new group is one item Many enhancements on this item make this the 82 E b B amp preferred method of grouping compared to Excel s native group function See Grouping Field Items page 101 Ungroup Field Items Ungroups selected group Same as PivotTable s normal Ungroup function Search Field Items Search a field for specific elements or words All field items in the group containing the sought elements are grouped and moved to the top of the field containing it This is an excellent way to find lost items as well as to group large numbers of records according to content See Content Search page 101 Freeze Panes Freezes panes on the worksheet so that the top row and column of Pivot Table are the crux of the frozen pane If there are several Pivot Tables and none is selected user is prompted to select one Optimize Column Widths For selected Pivot Table or if there is only one Pivot Table automatically resets column width to accommodate display of all data on the table Chart For selected Pivot Table or if there is only one Pivot Table creates a simple chart for all data and innermost row and column of labels Excludes grand totals automatically Users need to further customize the chart by using standard Excel charting techniques Pivot Query Information Display Shows or hides the Mast

User Manual - MasterMine Software

Contents

Download Pdf Manuals

Related Search

Related Contents