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
- 12376 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 as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain how many universes can be created in a project?
What is Indexing? how did u implement indexing?
Explain what are the steps to be taken to schedule the report?
What Is Snow Flake Schema?
Explain about a tricky situation for which you found a very simple solution?
Difference between zabo and webi?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
what will be the contents for a functional requirements specifications
What is the difference between the public object&schema object?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Can we create universe with no cache??
What is top business?
How to execute the plsql procedure from the report by clicking with mouse?
