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
- 12672 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
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain is there any default username & pwd for bo designer & supervisor?
Can we Save (save as) WEBI Doc as DESKI?
What is the difference in creating filters in designer and business objects?
What is difference between custom hierarchy and report based hierarchy?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain what is the difference between business requirement document and use case document.
Is there any other repository domains rather than universe, security, document?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
what will be the contents for a functional requirements specifications
Explain how to execute the plsql procedure from the report by clicking with mouse?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What Is Snow Flake Schema?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
