I have no idea about BO6.5 however I feel that creating Derived table mus

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 Posted / amritha

1 Answers
8856 Views
Cognizant, WinAlliance, I also Faced
E-Mail Answers

Answer Posted / amritha

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 ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to create metric universe ?

2399

What are all difference between business objects 6.5 and xi r2?

1089

Which command using Query Analyzer will give you the version of SQL server and operating system ?

5167

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1155

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2042

Explain how to execute the plsql procedure from the report by clicking with mouse?

1089

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2384

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1361

What are the steps to be taken to schedule the report?

1001

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2499

Explain what are the steps to do to use alerts in bo?

1126

Explain what are the measure objects?

1046

What is the difference between slice and dice and cross tab report?

1108

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3883

Explain about a task that really tested your analytical abilities?

1298