User Response Should be seperated

building reports webintelligence
1

Hi Experts,

Need ur help for some urgent issue.

I have a prompt say country,it has LOV’s as India,England,US,Australia.
If i select One value i have to show that particular value in one table.
and exclusive values in one table(i.e England,US,Australia) and inclusive in one table(England,US,Australia,India).I have report variable which uses user response and caluculates properly for some cases.

Now the issue is if the user enters two values say India,England.
user respoonse will be calculated as India;England

Is there any way i can convert this as two values and display in a table.

India
England

Please help me ASAP

rak_2010 (BOB member since 2010-05-01)

2

You can only extract each value separated by semicolon in a free standing cell but not in a column of data block
.

haider :es: (BOB member since 2005-07-18)

3

Hi Haider,

Thanks for the reply.

Yes we can seperate them in a cell.

But i desparately have to put them as two values in a table so that my report variable like =“UserResponse” will be satisfied.

Could u suggest any other approach.

Waiting for u reply

rak_2010 (BOB member since 2010-05-01)

4

What is your requirement, some workaround might work
.

haider :es: (BOB member since 2005-07-18)

5

Thanks for ur time.

Say i have a country prompt where if i select India

Table1:

I will show only india data.

Table 2:

England,US,Australia data.

table 3:
England,US,Australia,India

If i select ALL then only table 1 should be displayed.

I have created some variables using Userresponse which will display as above.

But the problem is if the user selects two values in Country prompt ,then v will get India;England as user response.

so my variable [Country]=UserResponse("")=India;England,this will no work here.

If i can sepertate them then hope this will work.

rak_2010 (BOB member since 2010-05-01)

6

Instead of using prompt values, filter each block/table using the country dimension and select values. For table 3,

[Country] INLIST ("England","US","Australia","India")

Or to make it dynamic create flag variables to be used in filters as

 IF([Country] INLIST ("England","US","Australia","India");"TAB3";"")

.

haider :es: (BOB member since 2005-07-18)

7

Hi,

These 4 lov’s are not fixed.I have many values in the Column.

rak_2010 (BOB member since 2010-05-01)

8

If I understand you correctly, what I did was.

Create a few variables (I did about 10 because my list won’t get longer that 6 or 7). I used substring functions to break the UserResponse into variables

Var1 = substring (UserRespone,1,";")
Var2 = sustring (UserResponse, end of var 1, “;”)
Var3 = sustring (UserResponse, end of var 2, “;”)
etc (as I say I made about 10).

Then you need a logic test.

MyTest = IF (Var1=column OR Var2 = Column OR Var3 = Column) THEN 1 ELSE 0

You can then filter your table.

MyTest = 1

weaver (BOB member since 2008-10-17)