The Costpoint Analytics data dictionary lists and describes the tables and fields included in the standard data models for Costpoint Analytics. It is an important resource for firms that extend or modify Costpoint Analytics to meet particular business requirements.
There is no data dictionary for CFO Dashboards. However, if you display Load CFO Data.qvw in QlikView Desktop, you can view a list of the fields, the source table and target table for each, and other related information. (Load CFO Data.qvw is located in the <installation location>\Analytics\CFO folder.)
To use the data dictionary...
On the server on which you installed Costpoint Analytics, go to the <installation location>\Analytics\Admin folder.
Open the CpA_Data_Dictionary.qvw file.
In Subject Area, indicate the data model that you are interested in.
Summary — Data model for the Summary Analytics
Project — Data model for the Project Analytics
Labor — Data model for the Employee Analytics
Use the Table Name, Field Name, and Field Type lists to filter the lists of field descriptions that display in the main section of the tab.
To search for a table name or a field name in the lists, click in the search field...
...and enter one or more characters from the name. If the search returns the table or field names you want, select them in the results list. (You can use the SHIFT key or CTRL key to select multiple items.)