Answer / padmalatha0923

we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel

Answer / gowthami

In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)

Answer / raj

Use only when you need complex joins and calculations between tables in the BO universe then go with Derived table.To Update / Change the derived table structure in the universe is very easy

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,

---

Explain when we use aggregate awareness function in designer?

0 Answers  

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers   Wipro,

---

In Business Objects 4.1 version what is the alternative name for broadcast agent?

1 Answers   HP,

---

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

5 Answers   Cap Gemini,

---

Can Bo generates the reports from cubical data ? Explain?

2 Answers   IBM,

---

what r the types of joins universe supports

3 Answers  

---

Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,

---

Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?

1 Answers  

---

what is the diff between etl tool and olap tool

2 Answers  

---

Explain the difference between detect alias and detect context?

0 Answers  

---