Grouped list of value

[Former Member]

Hello everyone,

I'm trying to make a list of grouped values from a Oracle table, ex

Table: "product_mobiles"

Values are:

• iphone 4
• iphone 5
• sensation
• iphone 6
• galaxy 4
• galaxy 5
• iwatch
• ipod
• desire
• one
• Galaxy Tab

Prompt list in webi must look like this (Multi: user can choose one o more in the list)

• Apple phones
• Samsung phones
• HTC

In apple phone must include iphone 4,iphone 5, iphone6

in samsung must include galaxy 4,galaxy 5

HTC list must include sensation, desire, one

it is possible to making this kind of object?

Thanks a lot

[mhmohammed · Accepted solution]

Hi James,

Just updated this post, I read the requirement wrong earlier. (12/16/2015  1:26 pm EST)

In the Universe, create an object called Product Group with the below formula and in the Report, create a Prompt on that object using the Inlist operator.

Case

     When product_mobiles in ('iPhone 4','iPhone 5','iPhone 6') Then 'Apple Phones'

     When product_mobiles in ('Galaxy 4','Galaxy 5') Then 'Samsung Phones'

     When product_mobiles in ('Sensation','Desire','One') Then 'HTC'

     When product_mobiles in ('iPod','iWatch') Then 'Other Apple Products'

     When product_mobiles in ('Galaxy Tab') Then 'Other Samsung Products'

     Else 'Others'

End

Hope that helps.

Thanks,

Mahboob Mohammed

[Former Member · Accepted solution]

it works! thank you so much

[mhmohammed · Accepted solution]

Great!

Mahboob Mohammed