cancel
Showing results for 
Search instead for 
Did you mean: 

Subject: How to show only those process chains which took more than 1 hr t

Former Member
0 Kudos

I am developing a query on 0TCT_VC21. I want to restrict results to a user specified execution time threshold

1. I want to specify a parameter where user can specify show me all process chains taking more than 60 minutes. I do not see a characteristic where I can enter this information. Duration is a key figure and I cannot drag it in Filters area. So, this is some new characteristic/variable. How do I create this new characteristic/variable?

2. Assuming this user input can be specified, and then what do I need to do to only show process chains which meet this criterion.

THANKS A LOT.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I was able to implement the two by:

1. Creating a formula variable, &formulavar&

2. Setting a condition: duration > &formulavar&

I still have a question, how to see all the formula variables in the query, only way seem to create a condition or some other thing where one can use formula variables, then one can see all the formula variables or create a new one.

Thanks.