Hi,
How to create derived tables within a Business Objects Universe for version 6.5.1? I’m new to building Business Objects universes in Designer. My supervisor requested that I learn how to create derived tables in case we need to create them in the future. I’m not knowledgeable about derived table and I certainly don’t know how to create one.
Thanks,
Lucious.
luciousw (BOB member since 2005-11-09)
Hi, Just go to the designer. In the universe pane Right Click. Select the option of derived tables. Enter the name of the derived table and in the SQL expression section write the SQL or u can also make the SQL by selecting tables and columns and using operators and functions. After creating derived table be sure to drag to left window to create classes and objects or can create objects by using this derived table. In the SQL syntax of derived talbe remember the syntax should be
select table1 as A, table2 as B etc.
Let me know if it helps.
Regards
Architect2009 (BOB member since 2005-10-26)
Pandeyji,
Your reply was very helpful.
Thanks,
Lucious.
luciousw (BOB member since 2005-11-09)
lucious, not to pick on you, but – did you consider checking out the manual before posting? The installation cd comes with PDF versions of the manuals, and I just have to think that the 6.5 documentation includes information on derived tables.
When you post a new topic, the first line of the new-topic comes up with:
Search first? Did you try to search first? [Search] [Search Tips] [How To Ask Smart Questions]Check out those hyperlinks – they’ll help you out as a new member:
Search
Search Tips
How To Ask Smart Questions
The How To Ask Smart Questions has a particular section, “Before You Ask”, which says:
Before You Ask
Is there anything I should do before I ask my question?
The four things you should have already done before posting a question are…
Read the manual (RTM) or Search the web (STW)
Read the FAQ
Ask a knowledgeable co-worker or friend
Search BOB!
Anita Craig 
(BOB member since 2002-06-17)