Answer Posted / guest

use personel data provider and use this excel to get the
data. Automatically it will create the SQL from excel.

Explain in detail about type 2(scd),

587

---

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

541

---

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

990

---

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

618

---

What is report template in b.o?

573

---

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

592

---

Explain is there any default username & pwd for bo designer & supervisor?

589

---

What is the difference between business requirement document and use case document.

575

---

Explain is data mart?

581

---

What is thumbnail?

572

---

How many universes can be created in a project?

590

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

4174

---

What is the difference between datawarehousing and businessintelligence?

607

---

Did you face any problems while creating reports? Name? Solutions?

3254

---

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

1747

---