Answer Posted / interested

In general the same index theory applies to DW as it is for
any RDBMS. So we can have one clustered index and several
non-clustered indexes on a table. defininng the index
depends on the need for the particular SQL. We usually
define them on the columns used in the join clause and in
the where clause to fecilitate the faster fetch.

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

3383

---

What we need to discuss with designer before starting the universe designing.

2256

---

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

1062

---

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4414

---

What would you consider as your biggest achievement and why?

1020

---

Can anybody tell me what are the tuning problems?

2054

---

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

1885

---

What is difference between custom hierarchy and report based hierarchy?

1030

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2046

---

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

1843

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2437

---

What is the dense rank?

1239

---

what is xcelsius architecture?

4601

---

How can you first report in Business Objects by using broadcast agent?

3069

---

Explain is data mart?

1032

---