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

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?

2256

---

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2503

---

Can you please send me the migration related issues .

2110

---

What Is Snow Flake Schema?

1261

---

Can we create universe with no cache??

2573

---

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1036

---

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?

11018

---

What is the difference between datawarehousing and businessintelligence?

1142

---

Can Bo generates the Report from the cubical data Explain?

2087

---

Difference between b.o 5.1 and 6.1b?

1334

---

what will be the contents for a functional requirements specifications

2416

---

How to restrict password to a user while sending a document in .pdf format

2392

---

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2389

---

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2197

---

Explain about a tricky situation for which you found a very simple solution?

1060

---