on 02-24-2009 7:15 AM
Dear experts,
Is there any way to set an input variable become input-help only?
That is, users can only use F4 to choose the values from the infoprovider, and can't directly key data into that variable.
For example, if users have to input calendar month before query execution,
they have to use F4 to choose months exist in that cube.
They can't directly type any month they want to that variable.
Is there any way to do that?
Hi Wen,
For example, if users have to input calendar month before query execution,
they have to use F4 to choose months exist in that cube.
yes, this is possible,
in RSA1-> go to chnage mode of infoprovider (Multiprovider/ cube) on which Query is build) then Expand time Charedteristc Diemension -> on infoobject calender month -> right click and select " provider-specific properties" -> last oprtion 'Query Exec. Filter value' -> select " D only values in Infoprovider"
save and activate infoprovider and check in selection screen of Query.
Regards
Daya Sagar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Daya,
Thanks for your reply.
I tried the steps you suggested.
Users can only choose values in that cube by choose from input help(F4) under that setting.
However, users can still directly type whatever calendar month they want into that variable.
What I want is to force users use input help, instead of typing values directly to that variable.
Is there any way to do that?
Again, thanks for your help.
Hi Wen,
make the calendar month vaariable as mandatory, go to change mode of variable in Query designer -> select your query -> Time diemnsion -> calendar month -> expand select you rcalendar month variable -> right click edit -> under basic settings -> select variable is mandatory.
by making input as mandatory, user will not able to execute query without giving input values or use F4 help (with user training, they will be taught to use F4 help, instead of namulaly enter values into variable, so that system will give correct format of data into variable.)
Regards
Daya Sagar
Hi Fulham,
Yes, your requirement is exactly the opposite to mine.
Looks like if you use hierarchy node variable, you can't directly type but have to choose from value help.
Unfortunately my variable is not a hierarchy node...
Does anyone know that how to set whether to type or to choose from value help?
I tried InfoObject's configuration and changed the "Filter Value Repr. At Query Exec", and it didn't work.
Is there anyway to do this?
Hello Daya,
The variable is already mandatory.
The problem is that user don't want input any values that don't exist in that cube.
However, if they can directly key in any values they want, it's not avoidable that they will key some values that cube doesn't have.
By using value help(F4), they can only choose the values exist in that cube.
So...they want the function that they can directly key in could be unabled.
That's why I am wondering if there is any settings that can force users only choose values from value input, not directly put data in that variable.
Is that possible?
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.