Answer / subramanyam

Derived table is nothing but logical table like view.it
doesn't carry out any data in the database.It is the
function in the designer. You can use the view as the table
in the universe design and you can create the class objects
and conditions based on that derived table.

Answer / kumarreddy

A derived table is one that is created on-the-fly using the
SELECT statement, and referenced just like a regular table
or view. Derived tables exist in memory and can only be
referenced by the outer SELECT in which they are created.

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

---

what are the documentations u r created?

2 Answers   Wipro,

---

How to restrict the user to refresh or Run the report only 1 time in BO?

6 Answers   Perot Systems,

---

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

---

how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

2 Answers   TCS,

---

---

What is BOMain.Key?

5 Answers   Cognizant,

---

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,

---

How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  

---

what is the core universe and what is the active universe?

1 Answers  

---

what is a filter?

4 Answers  

---

what is maximum scope of analysis --> can we define more than 3 levels?

2 Answers   CTS,

---

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

2 Answers   Patni,

---