Answer Posted / sivakumar.v

The Various data source are:
Universe
Free-Hand SQL/
Stored procedures
OLAP servers
Personal data files
VB procedures

Any number of data Source can be linked by common dimensions

Features of Dimensiion:
The dimension objects do not have to have the same name
(e.g. Person, Person Name)
Only dimension objects can be linked (e.g. Person
Name,Encounter Type,etc..)
The dimension objects must have a common data format (e.g.
character, numeric, etc.)
Common values must be in the same case etc..

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1092

---

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1069

---

Explain what would you consider as your biggest achievement and why?

1030

---

What is report template in b.o?

1073

---

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2074

---

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

2198

---

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

1126

---

Explain how many universes can be created in a project?

1112

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1361

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4363

---

how to create reports on screech?

2631

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2043

---

What is the difference between user and versatile user?

1142

---

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

2234

---

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

5167

---