Numeric and Text based data displayed in a report can be translated from values held in the database to more meaningful values by adding a reference code to a dimension. This should be used if:
- You wish to translate a value held in the data source into business terminology. For example if male and female are stored as M and F you may want to translate these into ‘Male’ and ‘Female’
- If you wish to apply customised sorting to a field. For example: data returned in a query is usually displayed in Alpha / Numeric sort order. If your result set included: Admin Staff, Managers and Executive Management your report may look like this:
Hierarchically your data may actually need to be displayed in the following way:
50This can be achieved by creating reference codes for the values and assigning a sort order to those codes.
Create Reference Code
- In the format tab the user must select Org Ref Code from the dropdown option; the other option is to choose to display the text which is stored in the database. Selecting to display the org reference code the user is able to create a new type or use an existing type.
- To use an existing reference code the user can simply select the code from a dropdown box once they have ticked the existing type option.
- To create a new reference code the user must tick create a new type option and then select to pre-populate from the database or not. A pop up window will appear so the user can add their new reference code. In this window the user can also edit an existing reference code or delete an existing reference code.
- If you pre-populate from the database you will see values already in the code list. You will have to give the reference code you are defining a name. This is so that the set of translations can be re-used across multiple views.
Editing a reference code
When editing a reference code you can change the values and the sort order of the codes stored in your database.
Click on the code hyperlink to open the edit section in the lower section of the popup to change the name and sort order.