Tuesday, June 12, 2012

How to remove data of invalid qualifiers in metric studio

Metric type Daily Call Avg. – All  is used to demonstrate the quickest way to get rid of invalid qualifiers. The qualifier was implemented based on activity type. It is requested to change it based on contract type.

First of all, change qualifiers from activity to contract type in metric designer,
Then execute, publish, clean up historical data, and transfer data from stage to metric store, we can see the old structure still there
It looks like there is no easy solution, the option 1 is to somehow clean up Metric store, the option 2 is to drop metric type and then redo it. Both options are pretty expensive.  There is a way to handle it using metric studio tool to remove these qualifiers, then all metrics will removed accordingly. Once republish data, and then old qualifiers will be GONE.

No comments:

Post a Comment