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
Explain in detail about type 2(scd),
what is xcelsius architecture?
What is the difference between user and versatile user?
What is the difference between business requirement document and use case document.
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What are all difference between business objects 6.5 and xi r2?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
any difficulitis have you phase while creating bo reports and how did u solve it
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain what is the difference between slice and dice and cross tab report?
What is the difference between condition & filter?
In banking domain how many Fact tables,Dimension table are present?
explain in detail about type 3?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.