ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
How to create Derived Tables in BO 6.5.4 with columns from 
different tables in the universe and how it has to be 
joined in the universe? If any one gives us a PPT format I 
will be more thankful.
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
Answer
# 1		 
I have no idea about BO6.5 however I feel that creating 
Derived table must be similar in both XIR2 and BO6.5.

-right click any where in Designer.
-select Derived table from Popup menu.
-A window will open up. Give the name of the derived table, 
You can specify the SQL stmt here as you do for example in 
oracle(if you are using oracle DB).

Example:
select BONUS.ENAME Ename,DEPT.DEPTNO,EMP.EMPNO  from 
Bonus,dept,emp where EMP.DEPTNO=DEPT.DEPTNO

You can specify the join in SQL stmt if necessary.

However joining the Derived table indeed is similar as 
joining a normal table.

Thanks,
Amritha
 
Is This Answer Correct ?    0 Yes 0 No
Amritha
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise? TCS1
how do you give security to universe ? Tech-Mahindra1
how do we apply sql query on selected variables?  3
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps. iFlex1
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two? TCS3
how do u resolve contexts ? Wipro4
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi iFlex1
how to test reports in businessobjects? TCS5
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it? Keane-India-Ltd3
Difference between Decode and Case? TCS4
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE? PCS1
What is casual dimension?  2
5.what is slowly changing dimension ? IBM2
What are universe parameters?  4
Instead of cms which server you have to use? CTS1
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?  1
how can we overcome by loops?and also is it possible ,one user can different universe  4
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance TCS2
who r the users in B.O.XIR2? PCS2
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level Accenture1
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com