cancel
Showing results for 
Search instead for 
Did you mean: 

When I define a variable in BO it automatically turns it into a detail

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

thank you very very very very very very very very very very very much

Answers (1)

Answers (1)

Former Member
0 Kudos

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.