BusinessObjects Board

about optional dropdown options in WEBI

building reports webintelligence
#1

Hello expert,

 In WEBI, I want to define a parameter which is not connection to any universe objects, it is used  to select different values for some object. for example:

optional: additional dropdown options:

  • “All Hospitals” (includes E1, F1, G1, H1)
  • “HIROC Database” (includes all subscribers)
  • “Non-Acute Care” (includes J1, J2, K1, L1, M1, M2, M3, N1)

above are three different combination for values of field “peer group”, can you tell me how to implement this prompt parameter in WEBI?

Many Thanks,

cetzhbo (BOB member since 2011-03-30)

#2

This is best done in the universe and not on the WebI side. Please see this post:
https://bobj-board.org/t/175820

You can also check out the Designer FAQs for more information.

Hope this helps.

Mitra Moini (BOB member since 2002-09-01)

#3

cetzhbo,

At a simple level, you could create a dimension object like ‘Peer Summary Group’ with a case statement, that would drive a list of values based on those (although I personally think it best to push this logic back to the source of the data, so it’s driven from there…).

Something like:

CASE WHEN PEER_GROUP IN (‘E1,’,‘F1’,‘G1’,‘H1’) THEN ‘All Hospitals’
WHEN PEER_GROUP IN (‘J1,’,‘K1’,…etc) THEN ‘Non Acute Care’
ELSE ‘The Rest’ END

This assumes you’ve got a nice Hierarchy where all your Peer Group’s roll up to a single Peer Group Summary.

Remember, if you want an ‘All’ Category, and you’re in XIR3.1, you can just make the prompt optional, meaning you don’t need an ‘All’ Value, as the user can just not answer the prompt to get All Peer Groups…

Cheers,

Matt

mjyoungman :australia: (BOB member since 2006-10-06)

#4

thanks very much.

cetzhbo (BOB member since 2011-03-30)