Answer Posted / rajuallinterview

prompt is an option in webi reporting side..
@prompt is a function in universe side. if we create prompts using by @prompt, when we drag object that prompt will appear in reporting environment

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1101

---

What is the difference between the public object&schema object?

1062

---

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...

2103

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1106

---

Explain what are the steps to do to use alerts in bo?

1074

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1026

---

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

981

---

can anybody tell me about complicated object you have created

3220

---

Explain is data mart?

1013

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3567

---

Can we create universe with no cache??

2504

---

What is aggregate table and aggregate fact table ... Any examples of both?

1057

---

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2096

---

Explain when to use local filter and when to use global filter?

1349

---

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2293

---