(Web API) Clear analytics table operation

Registered by Uwe Wahser on 2016-02-19

Add support for clearing analytics tables under the maintenance resource (MaintenanceController). This should be added at api/maintenance/analyticsTablesRemoval.

The api for updating analytics tables doesn't remove tables or data of obsolete years. In order to avoid reporting of invalid data, this has to be done manually via the maintenace function for clearing analytics tables. However, this is not applicable for automated loads that run on a scheduled basis.

1) Create an api clearAnalytis that can be called before calling the analytics update. In order to synchronise deletion and update, the api has to return a result, that can be read by the ETL process. A nice feature woud be if years can be passed as parameter to allow selective deletions.

2) Display a note on the maintenance screen for updating analytics tables that the cleaner has to be run first to remove obsolete years and also include this into the documentation for the users and the developers (api for analytics update) as the normal expectation would be to receive clean aggregates after using this function by itself.

Blueprint information

Status:
Complete
Approver:
Lars Helge Øverland
Priority:
Low
Drafter:
Uwe Wahser
Direction:
Approved
Assignee:
Lars Helge Øverland
Definition:
Approved
Series goal:
Accepted for trunk
Implementation:
Implemented
Milestone target:
milestone icon 2.23
Started by
Viet Nguyen on 2016-03-28
Completed by
Lars Helge Øverland on 2016-03-31

Related branches

Sprints

Whiteboard

Added on /api/maintenance/analyticsTablesClear

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.