1. Overview Page
The overview page gives you a brief look of your current network status, allows you to switch to another network or create a new one.
- Under the current network name you can see the number of hierarchy levels, the total number of network nodes as well as the total number of sales nodes (last hierarchy level).
- On the top right side you can see the network’s overall performance, for the current reference year and the current reporting month.
- On the bottom right you can see useful information messages having to do with data integrity & synchronization issues.
You can easily create a new network by pressing this button. The following form appears:
- First, enter a name for the new network.
- Second, select the year that initially this network refers to. Later on, you can add a new year from the overview page.
- Then, enter the network’s hierarchy levels. Keep in mind that a network consists of at least two hierarchy levels:
- Level 0 is the highest hierarchy level and only one node at this level can exist (e.g. Network Manager, Commercial Director)
- Last level corresponds to your sales nodes level (e.g. stores, sales reps).
- Intermediate levels (if any) correspond to intermediate levels of hierarchy (e.g. Divisions, Area Managers). Enter as many as necessary.
The same form as above appears, where you can only modify the network’s name and the hierarchy’s level names. If you need a different number of hierarchy levels, then you must create a new network.
You can delete the selected network (all of its reference years) by clicking this button. You will be asked to verify it first because this action cannot be undone.
Set up a new year
This function is not available in the beta version. You can only work on the year you initially created the network for.
Change reporting month
Regardless of up to which month you have entered your sales figures, you may select to set up your network to refer to a previous month. An occasion would be that you have entered updated past months’ figures and you want to generate a new set of reports.
When you change the reporting month, everything is been re-calculated as if the next months’ figures have never been entered. Just to be alert, in the synchronization banner, a message will appear:
2. Network hierarchy page
In the Network hierarchy page you can enter/modify the nodes of your network, in the hierarchy levels you defined when you created it.
In the main part of the page, the network structure is displayed in a hierarchical form. The ID column refers only to the lowest level sales nodes. The Overall Performance Indicator column displays the current overall node performance. If missing, its probably that no sales or quota figures have been entered for the specific node ID.
To add a sibling node at the same level, just select an existing node and click Add Sibling. All levels will be instantiated (see the red italics in the screenshot above). Enter the names and for the lowest level (in our example, Sales Reps), you must also enter the IDs.
Note: You cannot have two siblings with the same name, in the same level. This is allowed only for the lowest level nodes (e.g. Sales Reps), but they must have a different ID.
To drop a node, just select it and click Drop node. All child nodes will also be deleted.
Changes you have made in the network hierarchy are not saved automatically, until you click Save hierarchy.
Note: You cannot leave the page if you have made changes to the hierarchy and haven’t saved them. However, you can revert them by clicking Reload hierarchy.
Clicking Reload hierarchy will revert all pending changes and reload the original network hierarchy.
Import sales nodes from a .csv file
If you want to import a large number of lowest level nodes, such as sales reps or stores, you can do so from a .csv file having only two columns (the node name and the sales node ID).
Note: DINAMIS does not check whether the .csv file is properly formatted, so please make sure that it is formatted as following (comma delimited and with no header line):
Name 1, ID 1
Name 2, ID 2
… , …
Press Load to open the .csv file and its contents are automatically displayed:
Select the nodes you want to import. For the Add button to be enabled, make sure to select the parent node in the network hierarchy, i.e. a node in the level above the lowest, otherwise DINAMIS will not know where exactly to import them. Repeat this for every parent node.
A+ & A- : Increase and decrease tree view font, both in this and the Report Generator pages.
%: Toggle the OPI column in the tree view
@: Toggle the email column in the tree view
3. Products & Activities page
This is where you enter the products that you want to target and monitor. By products we also to refer to activities, services or anything else that you want your network to attain.
You can optionally define product groups. We recommend that you do this if you have more than a few products to monitor. First, you will probably want to monitor the performance at a group level and second, for display reasons, you can choose to group the results at the sales report. Only the Name field is mandatory.
Mandatory fields for products are: Product ID, Name and Target Description. The last two will appear in the sales reports.
4. Performance methodology page
Note: For an elaborate discussion on the performance methodology incorporated in DINAMIS, please read first here. The following presupposes that you are familiar with the subject.
Select performance measurement method
The beta version of DINAMIS only supports the credits method, however this is the more advanced one and we highly suggest you use it. Based on your feedback we will decide whether we will incorporate the more traditional approach with the gravity weights.
- Select the quarter you want to set credits for. If for a new quarter, DINAMIS will ask you whether you want to copy the products and credits of the previous one.
- Start adding product: you don’t have to type in the product name, just double click on the cell and select it from the combo box.
- Note: If you do not set credits for a product for a specific quarter, it is as the product simply does not exist for this quarter. Even if quota and/or sales figures have been entered for this product, they will not count into overall calculations.
If you want the OPI to be calculated annualized, check this (default is yes).
5. Report structure page
Dinamis generates three reports, namely the Sales report, for each one of your network nodes, the Management Dashboard report and the Sales Commission Plan report.
These reports are pre-designed, however you can choose whether some of their components will be displayed or not.
Main sheet tab
Select the Sales report tab and within, the main sheet tab:
- Chain of command performance comparison: Shows OPI figures for all levels of hierarchy where current node refers to
- Monthly performance diagram: Includes a diagram with actual vs expected performance
- Group results: If you have declared groups of products. check this option if you want group results as well to be included in the sales report
- Optionally, if you have a very large number of products, you may choose to initially hide the product rows in the sales report.
Select the Sales report tab and within, the extra sheets tab:
4. Rankings: Include extra sheet with rankings, for all levels of hierarchy
5. Auxiliary tables: Provided that have entered auxiliary data in the Data Management page, check if you want this data to be displayed as extra sheets in the Sales report.
Management Dashboard report
- Include distributions of sales nodes (histograms): Check if you want the two histograms to be displayed (recommended for networks with a large number of sales nodes)
- Default number of histogram bins: Select the initial number of bins, between 2 and 10. When the report opens, you can always change the bins number from that the bar underneath the histograms.
Sales Commission Plan report
There are no components to choose from in this report.
6. Report generator page
From this page you can generate your Sales and Management Dashboard reports. For details on what these reports contain, please have a lookhere.
In the main part of the page, the network structure is displayed in a hierarchical form, exactly as in the Network hierarchy page.
Open a single Sales report
Just select a node from the tree and press the Open Sales Report button.
- Note: Only nodes for which an OPI figure exists can be opened. A missing OPI figure is probably due to lack of quotas and/or sales figures for the specific node and is shown in grey italics (see Mike A. in the above screenshot).
Save Sales reports
Check this option if you want to save one or more reports.
- Select a node from the treeview. If you also want to select its children, click Select branch. If you want to save the reports for all the network nodes, just click Select all. You usually do so when you are ready to generate the monthly results.
- In any case you can see the number of reports that will be generated in the bottom right part of the page.
- Select the folder where that reports will be saved. A subfolder will be created with the network’s name.
- Create reference month subfolder: Check this if you want to create a subfolder for the year and month that the reports refer to. By doing so you can have a different subfolder for every month. The subfolder’s name will be in the form year_month.
- Create level subfolders: Check this if you want a subfolder to be created for every network node that reports are generated for, excluding those in the lowest level. By doing so, every node will have its own separate folder. In our screenshot example, the following subfolders will be created:
- MIKE STEVENS
- Jessica E. (The Jessica E. folder will contain all the sales reports for Susan O., James F. and John P.)
- MIKE STEVENS
- You can combine the above two options to create the folder structure that suits you the most. If you deselect both, all the reports will be saved in the network’s directory. This is not a problem at all, you can always select what you want based on the filenames, which follow the form: year_month_node level_node name_[(node_ID)], where the (node_ID) exists only for the lowest level nodes.
- Press the Save button and the report generation begins. You can always cancel the process by pressing the Cancel button.
Open the Management Dashboard report
Press the Open Management Dashboard and generate the Management Dashboard report.
7. Data Management page
From this page you can handle (import/enter/modify) the quotas, sales and auxiliary data used by DINAMIS.
- Select database table to process: Select a table and its records are automatically displayed. You can add and remove records that instantly update the internal database. You can filter the records by product ID, node ID and quarter or month, the latter for the quotas and sales figures respectively.
- Auxiliary tables: The two auxiliary tables hold the information that you want to share with your network. The first time you choose an auxiliary table you will be asked to select the .csv containing its record. Please note the following:
- The first row will be used as column names
- The first column must contain the IDs of the lowest level nodes, usually stores or sales reps. DINAMIS will import all rows without checking whether they match with existing network nodes.
- You can enter a name for the table. The sheet that will be added in the sales report will be named as such. You can always delete an auxiliary table by pressing the corresponding button.
8. Sales Commission Plan page
Note: For an elaborate discussion on the Sales Commission Plan incorporated in DINAMIS, please read first here. The following presupposes that you are familiar with the subject.
Network & Level Commissions
In this tab you set up the parameters that calculate the commission for the entire network and its allocation to the network levels.
- Plan type: Initially you select the plan type, namely whether commission is due to be paid at the end of the year or on a quarterly basis. Currently, the beta version only supports the end of year plan.
- Commission criteria for the entire network: Enter the minimum commission that can be allocated to the entire network as well at the minimum OPI that must be attained for that to happen. Also enter the maximum commission, and again, the corresponding minimum OPI.
- Network commission: The network commission Is automatically re-calculated when you change any of the above parameters
- Commission share per network level: Having calculated the network commission, you must set its share for each network level. The share sum must of course add to 100.
Open SCP report: The SCP report button shows up here just for convenience. Normally, you must first set up the parameters for allocating the level commissions, on the next tab.
Allocation of level commissions to nodes
In this tab you set up the parameters that determine the allocation of a level commission (calculated above) to its nodes.
- Select the network level you want to parameterize
- Set up the minimum required OPI, above which a level node becomes beneficiary to a commission. The number of beneficiaries is displayed below.
- You can optionally define the minimum and maximum commissions a level node can be awarded with
- Set up the OPI & Sales Credits factor weights for commission calculation. Please note that the weights are the same for all the network levels, however they are displayed here for convenience, so that you can see instantly how they affect the results.
- Changing any of the above parameters, automatically re-allocates the level commission to the level nodes.
9. Quota Allocation Models