| # Statistics The Statistics module enables you to obtain insight in the intake, turnover, and cancellation of orders and schedules. This module controls the activities that are required to define the desired format and layout for transferring historical data or actual data to statistical information. You can create user-defined statistical reports and displays to view this information. As a result, the Statistics module facilitates data analysis. You can also use the Statistics module to enter budgets. The entered budgets are used to compare, both in print and display, the actual sales/purchases (statistics) with the estimated sales/purchases, as defined in the budgets. Procedure for statistics If you want to use statistics in a company, complete the following steps: Step 1. Define master data for statistics Before you can use statistics, you must select the following check boxes: Purchase/Sales Statistics (STA) in the Implemented Software Components (tccom0100s000) session. Maintain Statistics in the Purchase User Profiles (tdpur0143m000) session of Purchase Control. Maintain Statistics in the Sales User Profiles (tdsls0139m000) session of Sales Control. If no user profile (sales) or user profiles (purchase) is defined, a user is authorized to maintain the statistics. Step 2. Define levels for statistics When updating the statistics, the sales, purchase and commission/rebate history is read and compressed to data in statistics. The level of compression depends on the statistical levels, as selected in the Statistics Parameters (tdsta0100m000) session. Before you can select the statistical levels in the parameters, you must first define the levels in the Statistics Level (tdsta0601m000) session. In this session, you must enter the levels on which you want to create/update the statistics for the level types Purchase, Purchase Actual, Sales, and Sales Actual. In the Statistics Level Attributes (tdsta0102m000) session, you can select the level attributes (fields) that must be included in the statistical reports and overviews for the level types. The Sales and Purchase levels determine which attributes are used for compressing the history data. As a result, these statistical levels also determine the sort attributes you can select for the sort (see step 4). For example, if a sort is defined for both sales and purchase, you can select sales attributes and purchase attributes, such as sold-to BP (sales) and buy-from BP (purchase). However, the sales field must be present in the Sales level, and the purchase field must be present in the Purchase level before you can select it as a sort attribute. The Sales Actual and Purchase Actual levels determine which history fields are overwritten by actual data if the Actual Data check box is selected when you update the statistics (see step 7). In this case, the attributes (fields) that are linked to these levels are not retrieved from the history data, but from the actual data for the item or the business partner. If an attribute is not linked to a level, the statistics cannot be maintained or updated for that attribute. Data related to this attribute will be excluded from displays and reports. Step 3. Define parameters for statistics After the statistical levels are defined, you can link the levels to the relevant parameter, such as Sales Intake Level, Purchase Turnover Level, Sales Actual Level, and so on in the Statistics Parameters (tdsta0100m000) session. You must also select the dates based on which the statistics are updated for the levels. In the Statistics Parameters (tdsta0100m000) session, you can also define: The way in which parent business partner data is updated when statistical data is updated. How the gross profit percentage is calculated and displayed in statistics. The various periods of a year, including the period number, start date, and end date that are used in statistics. Whether detailed discounts must be recorded for purchase discounts, sales discounts, rebates, and commissions. Standard item codes to store and retrieve statistical data. Step 4. Define and activate sorts for statistics In the Statistic Sorts (tdsta1600m000) session you must define sort codes, which are used to build a particular report or overview. You must indicate the type of statistical information (intake, turnover, cancellation) that must be kept for the sort and indicate whether budgets are allowed for the sort. From this session, you can maintain the Statistics Sort Sequences (tdsta1101m000) session. In this session, you can select the sort attributes (fields) that are used to sort data in statistical reports and overviews. Sort attributes: Identify specific sequences of a selection of the level attributes, as entered in the Statistics Level (tdsta0601m000) session and as selected in the Statistics Parameters (tdsta0100m000) session. Enable you to fine-tune the level attributes, which can be regarded as a pre-selection from the database, for each individual statistics overview that you intend to build. After definining a sort, you must activate it before you can use it for a report or an overview. You can activate a sort directly in the Statistic Sorts (tdsta1600m000) session, or in the (De-)Activate Sorts (tdsta1200m000) session. If the sort is set up for a budget, the sort need not be active to use it for a report or an overview. In addition, if you deactivate such a sort, the budget data is not deleted for the sort. Step 5. Define budgets Optionally, a company can create budgets to compare with actual results, or to use them as a basis for planning in the Enterprise Planning package. You can use the Budgets (tdsta2603m000) session to enter, maintain, and delete budgets for an active sort, year, and period. However, this is not a mandatory step in the procedure. If you create a new budget, you must first select a sort code. This choice will narrow down the data you can use in your budget. You can use the sort attributes as displayed in the Statistic Sorts (tdsta1600m000) session. From this session, you can: Maintain the Absolute Figures (tdsta2100m000) session, in which you can create or display detailed numbers for the budget in absolute figures. Maintain the Budget Percentages (tdsta2104m000) session, in which you can create or display detailed numbers for the budget in terms of percentages. If the Detailed Discount Specification check box is selected in the Statistics Parameters (tdsta0100m000) session, from the Absolute Figures (tdsta2100m000) session or the Budget Percentages (tdsta2104m000) session, you can start the Sort Budget Data by Discount Type (tdsta2105m000) session in which you can enter detailed discounts for sales and purchase discounts, for rebates, or for commissions. Step 6. Define a layout for statistics Before you can print or display statistical data, you must link a sort code to a layout code and you must define the layout for the data fields in the Statistics Layout (tdsta1610m000) session. From this session, you can: Maintain the Statistics Layout Column (tdsta1114m000) session. In this session, you can enter and view the column content, which defines the body of the report and what exactly is detailed in the report. If no column content is defined for the layout code, you cannot print or display statistical results. Maintain the Statistics Layout Content (tdsta1111m000) session. In this session, you can define the type of report that is printed: different types of statistics on one line, or a fixed type of statistics for each line. Maintain the Statistics Layout Selection (tdsta1112m000) session. In this session, you can select the data that is used and taken into account in the report calculation. Maintain the Statistics Layout Print/Page (tdsta1113m000) session. In this session, you can select the data that is actually printed on the report. Step 7. Update statistics Use the Update Statistics (tdsta2250m000) session to create or update the statistical files based on the history or the actual data. If you decide to do a full update, the statistics are fully updated. Except for the budget data, all current statistical data is cleared and new statistics are created based on the current (history) data. You can also update the statistics based on new (history) data that was not taken into account before when updating the statistics. Step 8. Display/Print statistics Use the Sort Data by Layout (tdsta1615m000) session if you want to display the statistical results for a combination of layout code and sort code. From this session, you can: View the data for the sort attributes (fields) that are linked to a combination of layout code and sort code in the Sort Attribute Data (tdsta1501m000) session. View the statistical results for a combination of layout code and sort code in absolute figures in the Figures by Layout / Sort (tdsta2500m000) session. The figures that are displayed depend on the statistics type. View the statistical results for a combination of layout code and sort code in absolute figures in the Figures by Layout / Sort (tdsta2500m000) session. This session only displays the statistical results for the columns you entered on the Columns tab of the Statistics Layout (tdsta1610m000) session. Display the statistical results graphically. Step 9. Print statistics Use the Print Statistics (tdsta2400m000) session if you want to print the statistical results. From this session, you can: View and maintain the data that is used and taken into account in the report calculation in the Statistics Layout Selection (tdsta1112m000) session. View and maintain the data that is printed on the report in the Statistics Layout Print/Page (tdsta1113m000) session. Step 10. Archive and delete statistics You can use the Archive/Delete Statistics (tdsta2250m100) session to transfer the statistics to an archiving file and/or to delete the statistics. You can display the archived statistics and budgets under the company number as entered in the Archiving Company field of the Statistics Parameters (tdsta0100m000) session. |