Analytics supports reporting and analyses of data from the various cost attributes in the Generic Cost Sheet of Shells with Generic Cost Codes.
Note: You work with a Generic Cost Sheet in the same way that you work with Cost Sheet (CBS Shells); however, the difference is that the data in the Generic Cost Sheet comes from Generic Shells and sub-shells, but the data for Cost Sheet comes from the CBS Shells.
You can access your Generic Cost Sheet from the Analytics node in Unifier (Shell > Admin mode > Analytics > Generic Cost Sheet) and map your Analytics fields to the corresponding Generic Cost Sheet columns.
Double click Generic Cost Sheet to open the Analytics – Generic Cost Sheet Setup window.
The Data Mapping tab (in the Analytics – Generic Cost Sheet Setup window) enables you to map the Generic Cost sheet Analytic fields to the corresponding Generic Cost Sheet columns, defined in Unifier. The Data Mapping tab has the following fields:
- Name
- Data Source
- Label
The Data Source values are the Single Sources and Logical Sources existing in the Generic Cost Sheets of all the Generic type Shells. You can pick the same data source for multiple fields.
The Label field is required field for the user-defined columns. The system supports a total of 40 user-defined columns, for the Generic Cost Sheet.
Note: An asterisk (*) appears for columns where mapping has been completed. The asterisk (*) does not appear if the column is not mapped to any data source.
The system populates the Label column with the Name column for the data source, as set in the Generic Cost sheet column definition. You can modify the values in the Label column, based on your business needs. The Label column supports non-ISO and UTF-8 characters.
The maximum number of characters allowed for this field is 50, same as the maximum number of characters in the Generic Cost Sheet Data Source Name.
Notes:
- The system does not support Custom String translation.
- The system does not perform label uniqueness verification.