...
The report management view shows all reports in a list including information about the type, the owner, the creation date and the date of last modification. Using the context menu, you can open a report configuration and change its parameters, create a duplicate, use the report as a template for a new report, delete or execute the report.
The Possibilities to execute and automatically distribute Reports
...
Example of a detailed report:
Example of a department level total report
Total report based on target numbers (customer numbers)
Creating a new accounting-report
...
| Info | ||
|---|---|---|
| ||
The format of the import file is <customer name>; <customer phone number>. The customer telephone number does not have to be entered completely. For an assignement assignment to a customer name it is enough if the phone number matches partial, starting from left, to the customer number. For example, the telephone number "+4970217388833" in the CDR would correspond to the customer number "+49702173888". However, the best match available is always selected for the phone number resolution. |
...
After you have determined the report type in "contents of the linesrows", please select a form that suits your requirements.
...
Leave the other fields like they are and continue with "next ".
The “change on execution" option
With the option "change by execution" it can be set that the settings on the displayed page may be changed if the report is executed via the Quick Start Bar. Background: There is a claim that only certain user groups (e.g. administrators) may create and configure reports. These reports are then released to the users via assignment to specific report groups. These users can run reports only through the quick start bar, they don't habe have access rights to open a report in the report management window. To prevent these users from having access to all configuration items, only certain configuration options can be enabled, such as changing the report period (date page).
Page "Organisation Chart": next, select the departments to be included in the report. You can also select a superior level (here "sales"), all elements below this level will then automatically be included in the report. In the first page with the option “new page by” you have defined on which organisation chart level the report is to be carried out.
Page "Date": Select the date range here. If you want to run the report automatically and regularly by schedule, please select a generic date such as "last month".
Page "ArticlesItem": On the page "articlesItem" you can define the call type you want to evaluate. Since we only want to see the business calls in this report, we only tick the box "business call". Equipment costs and service cost are not of interest here, so we don't activate these options.
Page "Filter Tel.": On these Item": Depending on your program configuration it might be that there is a page called "Item II". On this page you can define if call independent costs like basic fees should be considered in the report. In this example we don't need these settings
Page "Filter Telephony.": On these two pages you can define the call directions relevant for the report, the distance zones, which trunk lines the calls were made via, and the used network carrier tariff. Since we only want to look at the calls that cause costs, select the filter "external outgoing calls" and "use all distances" as relevant call directiondistance zones". You could use the distance zones to define a report that for instance only considers international calls. Leave the other filter options at their default values.
On the "Filter Tel. Telephony II" page you will find a selection of "call markers", if the use of "call markers" is enabled via the basic settings in the administration tool. A call marker can only be defined via the administration tool and is a filter for the total amount of data records. For example, one filter can be defined for calls that last longer than X seconds, and another filter for calls that are more expensive than X €. If several call markers are selected, then each one is applied individually for the total amount of data records. A combination of several call markers is thus considered an OR and not an AND of the individual filter conditions. If, in addition to the call marker filters, additional filter criteria have been defined on the page "options", the call markers filters are applied first and based on that dataset the criteria of the options page are appied.The use of call markers is only useful in certain cases. Usually the filter options under options are sufficientapplied.
In addition you can select filters based on trunk lines, used carrier and used data privacy profiles in this page.
These filter options are useful in certain special cases but in most cases not needed. This setting is therefore not displayed in the wizard when creating a new report, but only in the properties dialog of the report when opening the report via report management window.
Page "Output": Here one can specify in which form format the report result is to be generated, as a PDF or CSV file, and in which way the report is to be delivered. We want the report to be sent by email to each of the departments selected in the organisation chart. We do not want to create a separate report for each department, but the report should be generated automatically for each department (each department within the organisation chart selection) and sent to the respective supervisor. A report is generated for each department via one singel single report configuration. To achieve this on the page form we set the option new page newon departments (level 2). You can now explicitly specify a recipient for the issue, who should receive the report, or you can set the option "to invoice list recipient". If you choose this option, the report is sent to the e-mail address defined in the corresponding organisational chart element for which the report is to be created. Here it is the email address of the manager that is defined in the organisation chart elements of the departments (field "Email Address" in the property page of the organisation chart element of level 2). In this way, the reports can be sent automatically to the correct "invoice recipients". For the email body you could indicate a text file in the field "email Email text", whose content would be used as email text in the body of the mail. If no email subject is selected, the name of the report will be used. With the option "issue all All invoice recipients in one file" we could achieve that all reports would be generated in one file again. This option only makes sense if the report is going to one recipient.
| Info | ||
|---|---|---|
| ||
Note that the option "delete file after sending email" should be set, unless you want to keep the PDFs on the server for other purposes. If you do not set this option you have to ensure that the files will be deleted trough some other process. |
...
Page "Options": In options you can define certain conditions for individual lines – or entire pages – not to be issued or exclusively issued. We want our report to contain only lines that are relevant for cost allocation. Therefore we set the option "Do not issue line if amount is 0 or less". This ensures that calls that do not cost anything are not displayed.
Page Pages "Schedule": In order for the report to be executed automatically, we have to activate the option "execute automatically" on the page "Schedule" and define in which cycle the report should be executed and when the next execution should start.
Page "Name": Last but not least, the report must be Options II": Here you could define some special filter options based on the additional text attributes of the subscriber (e.g. include only subscribers for which the attribute "additional text #3" is equal to "basic tariff"). Another option is to filter the recipients of the reports by some subscriber attributes.
Pages "Provider Import": On that pages you can specify some filter options that are relevant if you have included data from imported invoices. Since this is not of interest here, we skip these settings. By default this kind of data is not considered in the report.
Page "Schedule": In order for the report to be executed automatically, we have to activate the option "execute automatically" on the page "Schedule" and define in which cycle the report should be executed and when the next execution should start.
Page "Name": Last but not least, the report must be given a descriptive name (this is also used as email subject if no subject is explicitely explicitly is set). The field "owner" can be used to specify whether the report can be accessed by other UC-Analytics users or if it is only available for the user currently logged in. If the option "Show in Quick Launch Bar" is selected, the report appears in the quick launch bar under the corresponding group selected in the "in group" field.
Click "apply" to save the report. You can view the result as a preview by clicking the "start reportExecute report" button and then "preview" - this will start the preview of the report which is displayed directly in this window.
...
| Info | ||
|---|---|---|
| ||
If you open the properties window of for a report, you will find additional configuration options. These options are necessary for special applications only, and are therefore not included in the wizard for creating new reports. |
Example 2: Total of Business Calls for each Subscriber per Cost Centre (2nd Organisation Chart Level), made available via the Web Suite
...
Mail Box
Goal: A report is to be created and executed for each departmentcost centre which is on the 2nd level of the organisation chart. The report should display the business calls as a total (duration and amount) for each employee in the various departmentscost centre. Every department manager should have the report for his/her department available to download via the Web Suite post box.
...
Page "Form": To get a report with totals per subscriber, select "total(s) subscriber(s)Sum Subscriber" in the field "row contentsContent of rows" on the first page. You can use the field "form type" to select which form to be base for the report. You can see a corresponding preview of the selection in the form preview. Use the field "new New page byafter" to specify the organisational level on which the report is to be summarised. The "recipient" of the report will also be defined with this setting. Since we want to generate a report for each cost centre, select the organisational chart level for the "cost centre", here Level 2 in the field "new page byafter". If you leave this field at "entire company", you would receive one report of all subscribers. In the field "group by" you use the "department" selection to specify that the call data is listed in blocks for each subscriber Level 3 which is in our example the level where the departments are located. With this setting, all subscribers belonging to one department will be listed in the same group (block) within the report. With the "Show subtotal per group" option, a subtotal of the number of calls, call duration and costs are displayed for each blockgroup.
We leave the other fields as they are and continue with "Next >".
Page organisation chart: Select the top element on the "organisation chart" page to consider all cost centres (items on level 2) in the organisation chart. In the first dialog, using the field "New page new byafter" you have defined which organisation chart level the report is based on.
...
The configuration of the page date, article, filter phone, options, execution plan and name corresponds to the configuration from the first example. Since we do not want to send this report by email, but to the Web Suite post mail box of the respective users, we have to make the appropriate configuration on the output page:
Seite Ausgabe: Auf der Seite "Ausgabe" können Sie nun zum einen festlegen in welcher Form der Report generiert werden soll, als PDV oder als CSV Datei und zum anderen auf welchem Weg der Report zugestellt werden soll. Wir wollen, dass der Report an das WebSuite Postfach des Kostenstellenverantwortlichen der jeweiligen Kostenstellen versendet wird. Dafür wollen wir nicht für jede Kostenstelle einen eigenen Report anlegen, sondern dieser Report soll automatisch für jede Kostenstelle (innerhalb der Organigramm-Auswahl) generiert und an den jeweiligen Kostenstellenverantwortlichen an das WebSuite Postfach versendet werden. Dass über eine Auswertungskonfiguration jeweils ein Report für jede Kostenstelle generiert wird, haben wir erreicht indem wir auf der Seite "Formular" die Option "Seite neu" auf "Kostenstellen" gesetzt haben. Für die Verteilung der Reporte kann man hier nun für die Ausgabe einen Empfänger explizit angeben oder man setzt die Option "An Rechnungsempfänger". Wählt man diese Option, so wird der Report an das WebSuite Postfach des Anwenders mit der Email-Adresse versendet, die im entsprechenden Organigramm-Element eingetragen ist, für die der Report erstellt werden soll. Hier die Email-Adresse des Kostenstellenverantwortlichen die im Organigramm-Elemente der Kostenstellen eingetragen ist. Auf diese weise kann man die Auswertungen automatisch an die entsprechenden "Rechnungsempfänger" versenden. Für den Email-Body könnte man im Feld "E-Mail Text" eine Textdatei angeben, deren Inhalt als Text im Body der Nachricht verwendet werden würde. Die Textdatei kann man auf den Server hochladen indem man im Feld auf den "Browse" Button klickt. Es öffnet sich dann ein Datei-Auswahl-Dialog für die Auswahl einer bereits auf dem Server hinterlegten Datei. Über Kontextmenü und den Eintrag "Neue Datei" kann man eine lokal gespeicherte Datei zum Server hochladen und dann im Dialog auswählen.
Page Output: On the "output" page, you can now specify the format (PDF or CSV file) in which the report is to be generated, and how the report is to be delivered. We want the report to be sent to the Web Suite post box - to the cost centre manager - of each respective cost centre. However, we do not want to create a separate report for each cost centre. The report should be generated and send automatically to each cost centre manager (within the organisation chart selection). We have accomplished for one report to be generated for each cost centre via the report configuration. Here on the page “form”, we set the “new page” – option on “cost centres”. For the distribution of the reports, you can now explicitly specify one recipient for the output, or select the option "to invoice recipient". If this option is selected, the report is sent to the Web Suite post box of the user with the corresponding email address defined in the organisation chart element for which the report is to be created. Here it is the email address of the person responsible for the cost centre whom is entered in the organisation chart elements of the cost centre. This is how the reports can be sent to the corresponding "invoice recipients" automatically. For the email body you can specify a text file in the field "email text". The text file content would then be used as text in the body of the message. The text file can be uploaded to the server by clicking the "browse" button in the field. A file selection dialog will then open for selecting a file already stored on the server. Via the context menu and the entry "new file" a locally stored file can be uploaded to the server and selected in the dialog.
| Info | ||
|---|---|---|
| ||
The UC-Analytics WebSuite user as recipient for the report is defined through it's email address. Even the report shall not be send by email one has to use the user's email address to define him/her as the recipient. |
If no "email subject" is selected, the name of the report is used as title.
With the option "all invoice recipients in one file" we can achieve that all reports will be generated into one file again. The report would then be sent to the first recipient. This setting only makes sense if the report should be sent to one single recipient. Please note that the option "delete file after sending email" is set if you do not want to save the PDF on the server for other purposes.
After executing the report, each cost centre manager receives a message in the mailbox with the respective PDF as an attachment:
Statistic Reports
Wie die Accounting-Auswertungen, können auch die statistischen Auswertungen über die Auswertungsverwaltung angelegt und verwaltet werden. Anders als bei den Accounting-Auswertungen, bei denen es im Prinzip 2 Typen von Auswertungen gibt - Summen- und Detailauswertungen, gibt es bei den Statistiken eine Vielzahl verschiedenster Typen und Untertypen. Es ist hier nicht einfach ersichtlich hinter welchem Typ oder Untertyp die gewünschte Auswertung zu finden ist. Deshalb ist es empfehlenswert die Statistiken über das Dashboard und dessen Vorlagen anzulegen. Bitte lesen Sie hierzu das Kapitel "Dashboard". Page Output: On the "output" page, you can now specify the format (PDF or CSV file) in which the report is to be generated, and how the report is to be delivered. We want the report to be sent to the Web Suite mail box - to the cost centre manager - of each respective cost centre. However, we do not want to create a separate report for each cost centre. The report should be generated and send automatically to each cost centre manager (within the organisation chart selection). We have accomplished for one report to be generated for each cost centre via the report configuration. Here on the page “Form”, we set the “New page after” – option on Level 2 (cost centres). For the distribution of the reports, you can now explicitly specify one recipient for the output, or select the option "to list recipient". If this option is selected, the report is sent to the Web Suite mail box of the user with the corresponding email address defined in the organisation chart element for which the report is to be created. Here it is the email address of the person responsible for the cost centre whom is entered in the organisation chart elements of the level 2. This is how the reports can be sent to the corresponding "list recipients" automatically. For the email body you can specify a text file in the field "Email text". The text file content would then be used as text in the body of the message. The text file can be uploaded to the server by clicking the "browse" button in the field. A file selection dialog will then open for selecting a file already stored on the server. Via the context menu and the entry "new file" a locally stored file can be uploaded to the server and selected in the dialog.
| Info | ||
|---|---|---|
| ||
The UC-Analytics WebSuite user as recipient for the report is defined through it's email address. Even the report shall not be send by email one has to use the user's email address to define him/her as the recipient. |
If no "email subject" is selected, the name of the report is used as title.
With the option "all invoice recipients in one file" we can achieve that all reports will be generated into one file again. The report would then be sent to the first recipient. This setting only makes sense if the report should be sent to one single recipient. Please note that the option "delete file after sending email" is set if you do not want to save the PDF on the server for other purposes.
After executing the report, each cost centre manager receives a message in the mailbox with the respective PDF as an attachment:
Statistic Reports
Like the accounting reports, the statistical reports can also be created and managed using the report management view. In contrast to the accounting reports, where there are basically two types of reports, (summary and detailed) statistic reports have a number of different types and subtypes. It is not quite obvious behind which type or subtype the desired report can be found. Therefore it is recommended to create the statistics using the dashboard and its templates. Read the chapter "dashboard" for more information.
...