Skip to Content

% KPI in OPI

Apr 05, 2017 at 09:05 AM


avatar image


Have anybody been able to run a query to show how many percent of process had a given attribute.

There is the default KPI that gives this % completed on time. But i'm unable to modify/create a new version of this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Andrew Frigaard Apr 09, 2017 at 01:17 PM

Hi Daniel,

I don''t think this is a straightforward. You can create a counter attribute (1 for has the attribute, 0 if not), and then display a sum of these as a Measure - this can be viewed OK, and will change as the scenario is filtered etc. This is a count, and not a %, but I have used this widely for counts, and for costs, values and any attributes that can be summed.

However for ratios or percentages I have not found a standard way to do this, as there is no concept of a calculated field or measure in OPI (like A / B x 100%).

One approach that may work is to look at the views that are generated in the "gen" folder in the project. Each new measure has its own view and you may be able to modify the view using the HANA SQL tools to get the result you need, using a calculation on the aggregrated attributes. This would be a "hack" to bypass the OPI tools, and so that would need to be re-applied every time the scenario is Generated. I was planning to try this approach sometime soon.

Let me know if you have any success, Andy.

10 |10000 characters needed characters left characters exceeded
Daniel Graversen May 11, 2017 at 01:03 PM

So fair my hack has been to make a join in the SPVR_<PROCESS>_CONTEXT calucalation view. Here I have been able to add a join to the same table and get number of processes in a given month. Then For each instance that has the value I'm trying to caluclate how many percent it is. But this only work on the full process so if you start to make filters or anything like that it will not work. So not really an ideal approach.

10 |10000 characters needed characters left characters exceeded