Answer Posted / satishe

Decode and Case functionwill work in the same way.the only
difference is we can write conditions in side the case
function.
for Ex;
case(if c>d,d...)
decode(job,'clerk'...)

What Is Snow Flake Schema?

1204

---

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?

3570

---

Explain how many universes can be created in a project?

1061

---

What is the dense rank?

1229

---

what is document design in boxi,have u participate in that

2180

---

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

1031

---

what are the tables used in health care domain project and columns used in report?

4512

---

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

1113

---

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1047

---

in sap bi we have wad, then why we go for sap bo

3381

---

Explain is data mart?

1020

---

Explain when we use aggregate awareness function in designer?

1023

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1829

---

Explain is there any other repository domains rather than universe, security, document?

1092

---

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2906

---