BusinessObjects Board

Complex Prompt

building semantic layer
#1

:?:

I would like to make a prompt which handles different kind of objects in a hierarchie. I would like to ask first: which level do you want to see? (country or city) and after that select the object choosen.

Something like this (but this code gives an error):

SELECT
  Name, Country, city, street
  FROM
  HRWH.dbo.personeel_adres,
  HRWH.dbo.org_dim
WHERE
  ( HRWH.dbo.personeel_adres.org_dim_id=HRWH.dbo.org_dim.org_dim_id  )
  AND  (
  ( CASE  WHEN  @prompt('What do you want to see? ','A',,,) = 'Country' THEN
( convert(char,HRWH.dbo.org_dim.country_id) )  LIKE @Prompt('Country','A','Organisatiestructuur\CountryCode',,) else ( convert(char,HRWH.dbo.org_dim.city_id) )  LIKE @Prompt('City','A','Organisatiestructuur\CityCode',,) end  )
  )

Or does anyone has solution to solve this problem. I want to make a ‘General’ (one) report (emplid, name, adres) but the level choosen can be different; all emplid of a choosen country or all emplid of a choosen city. So I don’t have to make 2 identical reports whith different prompt.

Thanks

[edited, added bbc CODE formatting to SQL code - Andreas]

Lia :netherlands: (BOB member since 2004-08-24)

#2

maybe “Cascade Prompt” is what you are looking for. Not sure if BO supports it, but a search on BOB returns quite a few posts.

shamit (BOB member since 2004-07-01)

#3

No, Cascade prompt works only for 1 object :cry:

Lia :netherlands: (BOB member since 2004-08-24)

#4

Your best bet is two create two separate Business Objects documents.

Otherwise you could look at this FAQ Designer entry (create 2 prompts: one for city, the other for country, but allow ALL as a selection).

Andreas :de: (BOB member since 2002-06-20)