Getting Table Description

[khobar]

Hi

We are using Business Objects 5.0. We have a table dept with three columns with dept_id as primary key. The emp_code and loc_code are foreigh keys to the table code_master whose description are stored in the other table code_master which has two columns code and description

dept(Table)

dept_id
emp_code
loc_code

code_master(Table)

code
desc

We need to generate a report with dept_id, emp_desc, loc_desc


To generate the same we created a view repeating the same table code_master twice with aliasing as shown below

select dept_id, a.desc as emp_desc, b.desc as loc_desc
from dept, code_master a, code_master b
where dept.emp_code = a.code
and dept.loc_code = b.code

We created this view in oracle and we used this view in the Designer to create the class and in Business Object we just dragged the columns from this class to generate the report.

Is there any way to acheive the same using designer.

Can i create two seperate objects obj_desc and loc_desc to in the designer acheive the same ?. Please let me know how to acheieve the same as i am new to this field

khobar

 

[pabloj]

You can generate the alias for the table directly into Designer, no need for a view.
Then join the alias properly and BO will write the "aliased" query for you. Stick to your guns

 

[khobar]

Hi

I did tried generating an alias for code_master to something else but when i inserted another code_master table it gave an error saying 'duplicate table not allowed'. So in order to overcome this I inserted another code_master table by renaming the earlier one as code_master1. I was able to specify the join crediteria for all these tables namely dept, code_master, code_master1 sucessfully. However when i went to Business objects and selected the columns dept_id, loc_code and emp_code and ran the report it give an error 'table code_master1 does not exist'. Actually it was searching for the table code_master1 from the oracle database. ( Hence i was forced to create a view in oracle by giving an alias name )

Any thoughs

khobar

 

[skrandel]

You need to read the designer manual. Insert-> Alias.

Don't rename things. It won't work. BO will handle the Aliasing for you. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com