on 11-25-2008 1:27 PM
i have made a user prompt in my report
so the user can input a value that does not exist in universe so i can use it as condition or a filter,
i have done this by using the followiing condition in the query
object = object
or
object = ToPrompt("Give number")
As you can see by the logic this condition will ALWAYS be true because object = object is always true. So this logic will not impact the rest of the query it will just allow to enter any value in the user prompt
in the report when i try to create a new variable
=ToNumber(UserResponse ("Query 1 with NEW_UNIV" , "Give number"))
it automatically turns it into a detail and i cant change it to measure or dimension.
is there a way to fix this
thanks in advance
Hi Stanko,
Please follow the Following Workflow to change qualification of variable to Dimension or Measure instead of Details which is by default in your case.
1. Create Variable Test
2. Go to Data > Variables.
3. Highlight the "Test" variable and remove it.
4. Click "Add" and go to the "Definition" tab.
5. Name the variable "Test" and go to the "Formula" tab.
6. Check either the "Measure" or "Detail" radio button and then check the "Dimension" radio button again to reset the variable qualification.
7. Go to the "Formula" tab and enter the following line into the "Formulas" text box:
=ToNumber(UserResponse("Query 1 with NEW_UNIV " ,"Give Number"))
7. Click "OK" and then close the "Variables" window.
The dimension variable will no longer change to a detail variable.
I Hope this is helpful.
Thanksu2026.
Pratik.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pratik,
Can you please attach the screenshot of the steps mentioned by you.
I am working on Webi 4.0 and am not getting where is Data->Variables(point no 2 mentioned by you).
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.