BusinessObjects Board

Values not retrieving for "ALL"

building semantic layer
#1

i Override the SQL of List of values of “State” Dimension like this

SELECT DISTINCT
Outlet_Lookup.State
FROM
Outlet_Lookup
Union
SELECT ‘ALL’ from Outlet_Lookup

and checked "Do not Generate SQL Before Running:.

I the report prompt values “ALL” option is showing but when i select the “ALL” the no data is retrieving, for other values data is retrieving.

How to solve this.

av_deepu :india: (BOB member since 2010-08-11)

#2

Please provide the syntax of the prompt you are using…

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Hi MAK,

Thanks for ur quick reply.

I Simply dragged the “State” Dimension in the Filter panel and the SQL Query generated is

SELECT
Outlet_Lookup.State,
Outlet_Lookup.City
FROM
Outlet_Lookup
WHERE
Outlet_Lookup.State In @prompt(‘Enter value(s) for State:’,‘A’,‘Outlet Lookup\State’,Multi,Free,Persistent,User:0)

av_deepu :india: (BOB member since 2010-08-11)

#4

You haven’t catered for ALL in your prompt:-

https://bobj-board.org/t/15227/2

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Thank you MAK.

Previously i read this article but i felt that universal change is enough.

thanks again.

av_deepu :india: (BOB member since 2010-08-11)

#6

You need to do the Union to get all in the LOV and then create a universe prompt, as described in that post.
Otherwise, quite simply, this will not work :).

Mak 1 :uk: (BOB member since 2005-01-06)

#7

[Moderator Note: Moved from WebIntelligence XI to Semantic Layer / Universe Designer]

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