Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12883 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain difference between zabo and webi?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference between the public object&schema object?
When we use aggregate awareness function in designer?
How to execute the plsql procedure from the report by clicking with mouse?
what is the difference b/w the refresh and buffered data?
Can we create universe with no cache??
How would you format some text using css to be verdana and bold?
How were the reports scheduled and how to resolve unexecuted documents?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
how to create metric universe ?
Explain in detail about type 1?
How can you first report in Business Objects by using broadcast agent?
