Skip to Content

% KPI in OPI

Hi

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

  • 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.

    Add comment
    10|10000 characters needed characters exceeded