Price Index User Help Page

Introduction

This functionality is for externally provided price index, which is a Consumer Price Index.

The system can calculate Price Indices; however there is an option to enter already calculated price indices such as a Consumer Price Index (CPI).

A Price index is a Data Series that records the value of a Price Index for a specific Collection Period for an external price index, typically a Consumer Price Index (CPI) for a Country.

A Price index value is a Data Point that records the value of a specific calculated Price Index (calculated by KDW as a “Calculated Index” or obtained from a secondary source as a Price Index) for a specific Collection Period.

A price index is defined by the following fields/metadata:

  • ID

  • Data Source Organization and Data Source Document

  • Index Name

  • Base period start date

  • Base period end date

  • Base value: (usually 100)

  • Specialization type

  • Created and Modified dates

  • Description

  • Datasets

  • Is calculated

  • Data series

This page provides information on both dataseries and datapoints.

Price Index Value (Datapoints)

Go to Top

Search or filter Price Index dataseries

The Price Indices page lists all the currently available Price Index in the system in a grid format (see below) with column headers: Country, Name, Source document

This page will also let you sort and view the Price Index data by Country, Name or Source Document columns. You can click on the column headers to sort the data in an ascending or descending orders.

  • Country: If you want to see all price indices from one country, sorting with this column will be useful.

  • Name: If you have price indices from the same country, the name provided will distinguish the price indices whilst informing you about the type of data it contains.

  • Source Document: The Source Document is relevant because you might have the same price index from one country but belonging to different Source Documents.

The Price Index dataseries page can be opened from KDW menu: Dataseries Management > Price > Price Indices

Fig. 1: Price Index page

You can search the list by entering a search criteria in the Search text-box at the top of the Price Indices page and clicking on the button to search and display matching results in the grid (see below).

Fig. 2: Search Price Index data

In addition to searching the price index records with a free-text criteria, the system also allows you to Filter the records by specifying a Country.

To set a filter criteria, you can use the button at the top-right side of the page (see below). When you specify a filter by selecting a value from the drop-down list, the system will automatically apply the filter and display the records that match all the filter value you have specified.

Fig. 3: Filtering Price Index data

Go to Top

Adding Price Index

This is a screen where a user can add new Price Index data by providing the geographical unit, scale, scenario and the source document linked to the same. A user can also add a description.

To add a new price index, the following information is required.

  • Name

  • Base value

  • Source document

  1. From the Price Indices page, click on the Add price index button

  2. In the Add price index page that opens, enter all the required information. Please note that the fields shown in bold font are all required fields and the remaining fields are optional.

  3. Click on one of the buttons to save the data into the system. The system will Save the data and will display a proper message about the success of the saving operation.

Save buttons

  • Save and add another - Saves the entered Price Index information and provides an empty form to save another record.

  • Save and continue editing - Saves the entered data and stays on the current form for further updates

  • Save - Saves the entered data and opens the Price Index page displaying the available data in the system

Fig. 4: Adding Price Index data

Go to Top

Editing Price Index

An existing Price Index information in the system can be modified and saved as needed.

To Edit a given Price Index:

  1. From the list in Price Index page, click on the link within the column0 column of the record you would like to edit.

  2. The system displays the Change Price Index page as shown below.

Fig. 5: Editing Price Index data

  1. Modify the data in the page as needed and click on one of the buttons to save the modified records.

  2. The system will save the data accordingly and display success/error message.

Go to Top

Deleting Price Index

An existing Price Index information in the system can be deleted if necessary. The system allows for a deletion of one or more records at a time as given below:

Deleting a Single Price Index

  1. From the list in Price Index page, click on the link within the Country column of the record you would like to delete.

  2. The system displays the Change Price Index page as shown below.

Fig. 6: Deleting Price Index data

  1. Click on the button at the bottom-left side of the page to delete the record.

  2. The system will open another page with summary information on the data you are about to delete including a list of Price Index datapoints that belong under the Price Index dataseries you selected. It will also display a prompt with a confirmation message Are you sure? and provides you with buttons at the bottom of the page.

  3. If you are certain that the records can be deleted, you can click on Yes, I am sure button. If you are not certain, please click on the link No, take me back. Please note that deleted records cannot be recovered and this functionality should be used sparingly.

Deleting one or more Price Index

It is possible to delete multiple Price Index data from the system by following the steps below:

  1. From the list in Price Index page, select one or more Price Index you would like to delete.

  2. From the Action drop-down list at the top, select Delete selected price index

  3. Click on the

  4. The system will open another page with summary information on the data you are about to delete with a list of Price Index Value that belong under Price Index you selected. It will also display a prompt with a confirmation message Are you sure? and provides you with buttons at the bottom of the page.

  5. If you are certain that the records can be deleted, you can click on Yes, I am sure button. If you are not certain, please click on the link No, take me back. Please note that deleted records cannot be recovered and this functionality should be used sparingly.

Fig. 7: Selecting Multiple Price Index data for deletion

Go to Top

Importing Price Index

Users can upload a bulk file containing data_source_organization, data_source_document, country, index_name, base_period_start, base_period_end, base_value, datasourcedocument, schedule, data_usage_policy, geographic_group, fewsnet_region, start, end, id, created, modified, specialization_type, name, description, datasets, is_calculated, _country, datausagepolicy, dataseries_ptr and upload it into the system using the Import functionality.

To import Price Index data in a file into the system:

  1. From the Price Index pages, click on the Import Price Index button.

  2. The system opens the Import page where you can upload the file and specify the file format/type by selecting a value from the Format drop-down list.

  3. Click on the Submit button to start the import process.

  4. After the processing the data in the uploaded file, the system will display the summary of number of records that are:

    • New - the records in the file to be newly added to the system.

    • Updated - the records in the file that will be updated into an existing data in the system.

    • Delete - the records in the file that will be deleted from the system.

    • Skip - the records in the file that will be skipped.

    • Error - the records in the file that has error in the data and will not be added to the system.

    • Total - total number of records in the file.

  5. To continue with the import, please click on the button at the right side of the page.

  6. The Price Index dataseries data will be imported and appropriate message will be displayed.

Fig. 8: Importing Price Index data

Go to Top

Exporting Price Index

Please see Downloading Price Index below

Go to Top

Downloading Price Index

The system allows downloading of Price Index data in CSV format for the selected Price Index dataseries.

To download Price Index data:

  1. From the list in Price Index page, click on the link within the Country column of the record you would like to download.

  2. The system displays the Change Price Index page.

  3. Click on the button at the top-right side of the page.

  4. When the system displays the save file dialog box, save the file in the desired location on your local computer.

Go to Top

Browsing Price Index

The system also allows an on-line viewing of Price Index.

To Browse Price Index:

  1. From the list in Price Index page, click on the link within the Country column of the record you would like to browse.

  2. The system displays the Change Price Index page.

  3. Click on the button at the top-right side of the page.

  4. Then the system displays the Data Series Explorer page where you can see the details of the datapoints in the Price Index including the Value and Previous Value of each datapoints.

Go to Top

Viewing Charts of Price Index

The system displays the datapoints in an Price Index in a flexible time-series chart format allowing you to easily see the datapoint values over a period of time.

To view Price Index chart:

  1. From the list in Price Index page, click on the link within the Country column of the record you would like to chart.

  2. The system displays the Change Price Index page.

  3. Click on the button at the top-right side of the page.

  4. Then the system displays the Data Series Chart page where you can see the details of the datapoints in the Price Index as a trend-line chart.

The Charts page will let you select the date range for the datapoints that you would like included in the display by:

  • Setting the Zoom period to 6 months, YTD, 1 year, 2 year, 3 year, 4 year, 5 year, or All datapoints in the Price Index dataseries

  • Specifying a free start date (from date) and end date (to date)

Fig. 10: Charting Price Index data

Go to Top

Viewing History of Price Index

The system tracks various events that are performed against an Price Index data including the addition, updates or deletion of data in the system.

To View the history of an Price Index:

  1. From the list in Price Index page, click on the link within the Country column of the record you would like to view the history.

  2. The system displays the Change Price Index page.

  3. Click on the button at the top-right side of the page.

  4. Then the system displays the Change history page where you can see the details of the updates and other operations carried out against the selected Price Index record (see below).

Fig. 11: Price Index history.

Go to Top

Search or Filter Price Index Value

The Price Index Value page lists the currently available Price Index Values in a grid format (see below) with column headers: Data series, Period Date, Collection Status, Value

The Price Index Values page can be opened from KDW menu: Dataseries Management > Data Points > Price Index Value

Fig. A: Price Index Values page

You can search the list by entering a search criteria in the Search text-box at the top of the Price Index Values page and clicking on the button to search and display matching results in the grid (see below).

Fig. B: Search Price Index Value data

In addition to searching the Price Index Value records with a free-text criteria, the system also allows you to Filter the records by specifying a Country filter.

To set a filter criteria, you can use the button at the top-right side of the page (see below). When you specify a filter by selecting a value from the drop-down list, the system will automatically apply the filter and display the records that match the criteria you have specified.

Fig. C: Filtering Price Index Value data

Go to Top

Adding Price Index Value

We can add Price Index Value records into the system using the import functionality described below

Go to Top

Editing Price Index Value

An existing Price Index Value information in the system can be modified and saved as needed.

To Edit a given Price Index Value:

  1. From the list in Price Index Value page, click on the link within the Data series column of the record you would like to edit.

  2. The system displays the Change Price Index Value page as shown below.

Fig. E: Editing Price Index Value data

  1. Modify the data in the page as needed and click on one of the buttons to save the modified records.

  2. The system will save the data accordingly and display success/error message.

Go to Top

Deleting Price Index Value

An existing Price Index Value record which is not yet Published in the system can be deleted if necessary. The system allows for a deletion of one or more records at a time as given below:

Deleting a Single Price Index Value

  1. From the list in Price Index Values page, click on the link within the Data series column of the record you would like to delete.

  2. The system displays the Change Price Index Value page as shown below.

Fig. F: Deleting Price Index Value

  1. Click on the button at the bottom-left side of the page to delete the record.

  2. The system will open another page with summary information on the data you are about to delete and a prompt with a confirmation message Are you sure? and provides you with buttons at the bottom of the page.

  3. If you are certain that the record can be deleted, you can click on Yes, I am sure button. If you are not certain, please click on the link No, take me back. Please note that deleted records cannot be recovered and this functionality should be used sparingly.

Deleting one or more Price Index Value

It is possible to delete multiple Price Index Value data from the system by following the steps below:

  1. From the list in Price Index Value page, select one or more Price Index Value records you would like to delete.

  2. From the Action drop-down list at the top, select Delete selected unpublished Price Index Value

  3. Click on the

  4. The system will open another page with summary information on the data you are about to delete with a list of Price Index Value datapoints that belong under Price Index Value you selected. It will also display a prompt with a confirmation message Are you sure? and provides you with buttons at the bottom of the page.

  5. If you are certain that the records can be deleted, you can click on Yes, I am sure button. If you are not certain, please click on the link No, take me back. Please note that deleted records cannot be recovered and this functionality should be used sparingly.

Fig. G: Selecting Multiple Price Index Value data for deletion

Go to Top

Importing Price Index Value

Users can upload/import a bulk file containing index_name, country, period_date, datapoint_status, value, dataseries, datacollectionperiod, datacollection, data_source_organization, data_source_document, collection_date, collection_name, start_date, period_notes, id, created, modified, status, status_changed, specialization_type, description, high_value, ci95_low, ci95_high into the system using the Import functionality.

To import Price Index Value data in a file into the system:

  1. From the Price Index Value pages, click on the Import Price Index Value button or you can open the same page from Dataseries Management > Import > Import Price Index Values menu.

  2. The system opens the Import page where you can upload the file and specify the file format/type by selecting a value from the Format drop-down list.

  3. Click on the Submit button to start the import process.

  4. After the processing the data in the uploaded file, the system will display the summary of number of records that are:

    • New - the records in the file to be newly added to the system.

    • Updated - the records in the file that will be updated into an existing data in the system.

    • Delete - the records in the file that will be deleted from the system.

    • Skip - the records in the file that will be skipped.

    • Error - the records in the file that has error in the data and will not be added to the system.

    • Total - total number of records in the file.

  5. To continue with the import, please click on the button at the right side of the page.

  6. The Price Index Value records will be imported and appropriate message will be displayed.

Fig. H: Importing Price Index Value data

Go to Top

Viewing History of Price Index Value

The system tracks various events that are performed against an Price Index Value data including the addition, updates or deletion of data in the system.

To View the history of an Price Index Value:

  1. From the list in Price Index Value page, click on the link within the Data series column of the record you would like to view the history.

  2. The system displays the Change Price Index Value page.

  3. Click on the button at the top-right side of the page.

  4. Then the system displays the Change history page where you can see the details of the updates and other operations carried out against the selected Price Index Value record (see below)

Fig. I: Price Index Value History

Go to Top