Displaying all LOVs using 'ALL' Prompt

building semantic layer
1

Hi!

In my designer i created prompt object to see all LOVs just by typing ‘ALL’.But user wants that instead of typing ALL he type ‘*ALL’ for all LOVs.

I know the syntax to write prompt just by using ALL but not with “*ALL”.
I need help from you.

Thanks

kumar_m01 (BOB member since 2006-07-27)

2

Welcome to B :mrgreen: B Kumar

KhoushikTTT :us: (BOB member since 2005-02-24)

3

Here is something which might be of some help

KhoushikTTT :us: (BOB member since 2005-02-24)

4

Are you saying that instead of the literal string “ALL”, you want to use the literal string “*ALL”? That’s how I read what you’re saying.

If you know how to type one string into the syntax, you know how to type another. Just substitute the literal string that you want.

Also, since this is a LOV-building/Designer question, moved from “Building Reports” – BusinessObjects Classic sub-forum to “Semantic Layer” forum.

Anita Craig :us: (BOB member since 2002-06-17)

5

Use a command in your data foundation- get your LOV values then union it with an ‘ALL’ to get it to appear in the list

charlottecraig (BOB member since 2006-06-20)

6

Best is (my opinion) to create an object in designer which will return the message to display for ALL (we have a dummy table with one row, and just columns with these messages). Then always union this object in the LOV. That way there’s only one place to chance these messages.

Regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)

7

I’ve done this so many times before…in Oracle!

I don’t seem to be able to find an equivalent to sys.dual in SQL Server.

Any suggestions on how to get this working in SQL Server??? :hb:

Eileen King :us: (BOB member since 2002-07-10)

8

If you don’t care if the object parses or not then just use
select
xx
From xx
union
select ‘ALL’

You don’t need a FROM table.

Michele Pinti (BOB member since 2002-06-17)

9

TOO EASY!!! :rotf: :oops: :rotf:

Thanks!

:mrgreen:

Eileen King :us: (BOB member since 2002-07-10)

10

I Appreciate all your efforts,
Thank You Very Much …That worked perfect for me.

chander165 :us: (BOB member since 2005-12-20)

11

I’ve updated the FAQ to reflect the SQL Servier option…

Eileen King :us: (BOB member since 2002-07-10)

12

I’ve always created a derived table (yeah, version 6.5) or a table of view in the database just for this purpose. That did the trick and it made it possible to even parse these objects…
Perhaps you could use master.dbo.sysdatabases,and in the where for the objects put soemthing like [name]=‘yourdatabasename’.
Everyone normally has access to this table.

Regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)