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?
Answer Posted / 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
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How to restrict password to a user while sending a document in .pdf format
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
can anybody tell me about complicated object you have created
U r project in which stage in implementation?
What is aggregate table and aggregate fact table ... Any examples of both?
What is the difference between absolute and relative div positioning?
What is difference between webi and infoview?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What task is 98% of the required work of a business analyst?
What is the functional & architectural differences between business objects and web intelligence reports?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
How to create Index to the table in the universe designer and how it improves the Query performence
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain what are the steps to do to use alerts in bo?