cancel
Showing results for 
Search instead for 
Did you mean: 

Key Figure Variable Entry

Former Member
0 Kudos

Hello,

How would I create a variable entry selection, to enter dollar amount value for selection. Say, to view the report output whose amount is greater that 1000. The user would enter select the value 1000.

should I create a customer exit? If so how should I do it.

Thanks,

Rad

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You need to create a condition on the amount KF.

The condition would be

Amount KF -


greater than---

in the last cells instead of specifying a value select variable entry.

This should suffice your requirement...

Ashish..

Former Member
0 Kudos

Hello Ashish, thank you for the quick reply. Condition works well if we restrict the operator to greater than or less than or between.

But, I would like the user to have the flexibility to choose the operator <, > or =

What should we do for this situation?

Thanks,

Rad

Former Member
0 Kudos

Which version are you working on??

We have the option to select the operator for every variable we have in the query on ver 3.5

Ashish...

Former Member
0 Kudos

Ver 3.5

I can select the operator for the created new condition.

But, I want the operator to be in the variable selection screen.

The user should have the capability to select the operator and the value range for the key figure.

Thanks!

Former Member
0 Kudos

Thats exactly what i meant..our users have the ability to select the operator in the variable slection screen by default for all variables used in a query.

Former Member
0 Kudos

Thanks again.

But, I am still not clear.

I created the following condition

Key Figure--Operator--value

Amount -


greater than---variable entry

For variable entry, I created a formula variable process by user entry/default value with dimension ID amount

there are no existing variable I can use for my query.

Am I going wrong anywhere?

Former Member
0 Kudos

All seems rgt to me.

When you try running your query do you see the operator selection option in the variable slction screen??

Former Member
0 Kudos

No I do not

since I already preselected my operator while creating the condition!!

Edited by: Raadooo on Oct 16, 2008 2:25 AM

Former Member
0 Kudos

I had selcted '=' and i still see the operator selection in the variable screen...

Let me check if i can find out from which version this feature was available...

Ashish..

Former Member
0 Kudos

can you please check and let me know.

I am using Ver 3.5

Former Member
0 Kudos

I beleive the diff is that our backend is 7.0 but we are still on the 3.5 frontend..

May be thats what making the difference...Hope someone more knowledgeable about this issue pitches in..

Good luck..

Ashish...

Answers (0)