Associated Data can be used within Reporting and validating Bills.
This section will show how to set up the general ones, ie Floor Area, Population, Occupancy etc.
For details on how to set up Degree Days or PPU (pence per unit), click on the links.
Once created, it can be viewed and updated in the Estate Management Activity.
Click here for details on how to update Associated Data Values.
From Database Object Setup Activity:
These types will now be available in the dropdown list when creating the Channel (see below).
Associated Data can be set up at any level, including Supply Point, Site, Account and Meter, depending on what the data is.
For example, adding Floor Area, Population or Occupancy figures.
From the Estate Management Activity:
From the Estate Management Activity:
For example the Pence Per Unit for an Account.
From the Estate Management Activity:
All of the above, will open the Associated Data Editor
Complete as follows:
Field | Suggested Value |
---|---|
Channel Name | Individual to each Associated Data item (Good practice is to prefix the type of Associated with the type chosen, ie Multree Headquarters Floor Area) Note: Complete this after you have chosen the Data type as it will default to whichever Data Type you have chosen |
Data Load ID 1 | Automatically generated (do not change if setting up manually) When data is loaded against the channel in bulk using a CSV file, this data load ID needs to be used. |
Timezone | usually set to Europe/London |
Data type | Choose the most appropriate option from the dropdown to reflect what the data represents. You can use the + to add a new type -for example Electricity Rate 1 PPU |
Unit of Measurement | This is the format that the data will be loaded in. for example m2 |
Conversion Factor | Defaults to 1 |
Asset Type | Choose from the dropdown, types such as Fiscal Grid Import and External Lighting |
Meter Readings | Do not tick for Associated Data Channels |
Click OK to create the Associated Data item
Once you have added the Associated Data Channel using one of the above methods, the pop up will update to show the new added line.
The below example is showing the Site Associated Data pop up (which shows all Associated Data for the Site, Supply Point, Account and Meter
Note: No values have been added yet, therefore the Effective Value, Latest Value and Latest Date columns are blank.
The Add Readings pop up appears
The Associated Data Channel will update with the date and value
For details on how to create the CSV file and import in bulk, click on the below links:
Creating Associated Data in bulk (PPU example)
Creating Associated Data in bulk (using a CSV File)