BusinessObjects Board

lovs

Hi,

Please I want to add all in the lovs so a user can just chose “All” without having to chose ever single value.

Database is oracle 11G

thanks


Alex.bo (BOB member since 2012-04-27)

Hi,

This Designer’s FAQ will help:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

First of all I got into the properties of the dimension object Year. Then under the edit option as soon as I click the combined query option, another query is generated and the queries, query1 and query2 are unioned. Then I got into the SQL of the combined queries generated. I replaced the SQL of the query2 with UNION SELECT ‘ALL’. Do not forget to check the checkbox ‘Do not generate SQL before running’. Finally I got back to the properties section, went into the Display option and refreshed the values. Now you can see a value by name ‘ALL’ added to the list of values of the object Year.
Next, I created a filter object with a where clause as

@Select (Class\Object) In @Prompt (‘Message’,‘A’,‘Class\Object’, Multi, Free, Persistent) or ’ ALL’ IN @Prompt (‘Message’,‘A’,‘Class\Object’, Multi, Free, Persistent)

Here, the OR operator gives user the functionality of either selecting the LOVs individually or selecting the value ALL to display all the values together. You can define All as anything u want.

Thanks & Regards,
Afaf. :mrgreen:


AFAF :india: (BOB member since 2012-07-13)

There are two approaches - overriding the LOV SQL, and creating a universe
object.

Overriding the LOV SQL

  1. Press the SQL button in the query panel of the LOV
  2. Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for
    your particular database. For SQL Server (if you don’t care if the object
    parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a
    FROM table)
  3. Click the “Do not generate SQL before running” checkbox.

Universe Object

  1. Create a universe object defined as a constant ‘ALL’
  2. Associate it with the SYS.DUAL or equivalent table so it will parse
    (optional)
  3. Press the combined query button in the query panel of the LOV (defaults
    to UNION)
  4. Include the new universe object.

Thanks.
Abdullah Irfan


Abdullah Irfan (BOB member since 2012-08-24)

edit solved: i checked export with universe in object properties to get it work
Thanks

Hi i followed both of aforementioned approach

and i can see ‘all’ in when i display lov on universe leve using both approach.

but i cant get that lov in wei rich client or thin client.

confused seems real easy and working in universe but when i drop this condition in query filter LOV dosent have ‘All’ what could be reason

anybody


broccolimustdie (BOB member since 2010-06-17)

Perhaps you can use an optional prompt as well?


Jurr (BOB member since 2011-08-24)

Is this issue resolved ???


AFAF :india: (BOB member since 2012-07-13)