GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Objects
Go To First  |  Previous Question  |  Next Question 
 Business Objects  |  Question 40 of 238    Print  
what is a derived table in data warehousing?

  
Total Answers and Comments: 7 Last Update: June 03, 2007     Asked by: Monali 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 30, 2006 05:52:45   #1  
senthil        

RE: what is a derived table in data warehousing?

hi

    it is similar to views,it is mainly used to restrict the datas


 
Is this answer useful? Yes | No
July 21, 2006 08:35:41   #2  
MuthuKumar        

RE: what is a derived table in data warehousing?

Can u pls give me the exact defination and examples ?


 
Is this answer useful? Yes | No
August 03, 2006 02:44:24   #3  
Senthil Raj        

RE: what is a derived table in data warehousing?

we cont use correlated subquery in BO 6.5( Im not sure with other version).

In such cases we use Derived tables. 


 
Is this answer useful? Yes | No
January 10, 2007 01:56:24   #4  
pratip        

RE: what is a derived table in data warehousing?

respected all

Actually am a BO XI beginner ,so have stuck in  the basic concept of derived table..if any one explain it for me,i ll be grateful to them,and plz explain in which context i should use the derived table.

thankyou

pratip


 
Is this answer useful? Yes | No
April 26, 2007 08:51:06   #5  
Vineela        

RE: what is a derived table in data warehousing?
Derived tables are not real tables at the Database level , but are the selection of few columns in the Table with some aggregations, specific to the report.

This feature is available in BO 6.5 and later versions.

Sel a1,a2,a3,max(a4)

from a ,

(Sel b1, b2, max(b3) as B3, Min(B4) as B4 from B group by b1,b2) as BX

where BX.B1= a.a1
group by a1,a2,a3
order by a1,a2,a3

The (Sel b1, b2, max(b3) as B3, Min(B4) as B4 from B group by b1,b2)  in the above query is a derived table.

The same definition has to be added in the Universe - by going into Insert >> Derived Tables.

Type the Query - parse it and the new table inserted can be used to any type of join / Contexts etc in the Universe.


 
Is this answer useful? Yes | No
May 15, 2007 02:54:25   #6  
kiran        

RE: what is a derived table in data warehousing?
Derived tables is an option in Business Objects Tool(Business Intelligence) from version 6.5.
 
Is this answer useful? Yes | No
June 03, 2007 02:59:55   #7  
sunil        

RE: what is a derived table in data warehousing?
For Derived table, i am having one scenario.
My Database table is having following Column
-Empno
-Empname
-Managerno

my Report Requirement is like:
report should display Emp name and its corressponding manager name.

Based on this reqquirement, i need to design Universe.

My steps would be like this:
1.Looking at the requiement, i would go for Derived table, having name Manger.

Derived Table(Manager) would be having following syntax.

select distinct a.EmpNo,b.EmpName from Emp a,Emp b
where a.ManagerNo=b.EmpNo

2. Joining

2. Create class Manager and Object Manager Name, Source for this object would be
Derived_table.EmpName that is manager. EmpNo. Here EmpNo is coming from Derived table syntax.

Now my universe is ready.

As per the repoer requirement i can create report.

So Bottom line is Derived table plays a major role in this scenario.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape