Answer / latha

yes,we can add ALL in lovs of any obj.In unv level double click on any obj,in properties tab,edit the view sql tab&add below select statement
select distinct
Agg-yr-qt-rn-st-ln-ca-sr.state
from
Agg-yr-qt-rn-st-ln-ca-sr
UNION
select distinct
'ALL'
from
Agg-yr-qt-rn-st-ln-ca-sr
and enable the option"do not generate sql before running"

and develop a prompt for this obj

select where clause of this obj add
state=@prompt()
or
'ALL'=@prompt

Answer / prathmesh

@Prompt('PROMPT TEXT','A',<PATH FOR
LOV>,Multi,Free,Persistent,{'ALL'})

THIS WILL ADD AN EXTRA VALUE CALLED AS "ALL" IN YOUR LOV

Answer / bhaskar

Hi Thotadwh,

Thanks for the kind information


It's not a prompt message, it should be get as a prompt
value along with the List of values while refreshing the report.

Scenario:

Mono - We can provide Single value

Multi - We can select all possible LOV's one by one

ALL - Here, it will take all possible LOV's & need
not provide one by one

Note: Hope it's not a parameter of the prompt,

How will we get the "ALL" word along with the LOV's.


Is there any workaround at DB level or Universe or Reporting
level to get the word "ALL" into the picture at report level.
------------------------

Any answer will be helpful.

Thanks in advance.

Answer / bhaskar

HI LATHA,
UR STATEMENT IS FINE.
BUT
WITHOUT PROMPT IN WHERE CLAUSE:

WHEN I RUN THE REPORT USING PROMPT VALUE 'ALL' IT'S SHOWS A MESSAGE CALLED 'NO DATA TO FETCH'

WITH PROMPT IN WHERE CLAUSE:
IT'S ASKING FOR TWO PROMPTS,I.E
ONE PROMPT WITH LOV EXCLUDING 'ALL'
AND
SECOND PROMPT WITH LOV'S INCLUDING 'ALL'

I HOPE THAT HERE I AM GETTING THE RESULT BASED ON FIRST PROMPT//

LET ME THE KNOW REASON THAT, WHERE I AM GOING WRONG

Answer / satya

As per my knowledge, "All" option is not in Prompt. But by
using "list of values" option ,We can select All values.

Answer / thotadwh

I dont think you can do so as far as i know. We can do so by checking optional prompt in prompt parameters.

Answer / thotadwh

could you elaborate your question. what exactly you need. do
you want to get the prompt message as ALL or what is it
exactly..

I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

3 Answers   IBM,

IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

3 Answers   IBM, TCS,

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

What are the traps ? What are the disadvantages of traps?

5 Answers   Wipro,

Explain about a time when you discovered a more efficient way to do a work task?

0 Answers  

how u restrict the values?to display 5 values insted of 10 values?

4 Answers  

The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 Answers  

Which versions are used in the bo dashboard work?

0 Answers  

what is fantrap ?

5 Answers   Tech Mahindra,

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except

2 Answers   Nucleus Software,

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers   Accenture, Wipro,