how to create a derived table in designer? i need steps
regarding derived table

Answer Posted / radha

IN UNIVERSE DESIGNER RIGHT CLICK -CREATE DERIVED TABLE -
GIVE NAME FOR DERIVED TABLE.

IT'S DISPLAYED IN THE UNIVERSE DESIGNER PANNEL.

MAINLY DERIVED TABLE USED FOR WE CAN CREATE OUR OWN QUERY.

LIKE WE CAN SELECT ONLY THE PARTICULAR TABLES IN THE DESKI
WHILE TRACKING THE DERIVED TABLE(IT'S BASED ON THE OUR
QUERY)

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

700


U r project in which stage in implementation?

2037


can anybody tell me about complicated object you have created

2843


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

643


how to prepare the documentation in business objects and where to get the requirement?

1866






Explain what are the steps to be taken to schedule the report?

728


What is aggregate table and aggregate fact table ... Any examples of both?

692


What is the difference between the public object&schema object?

671


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

3423


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

627


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

691


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

679


What is object stores?

662


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

622


Is there any other repository domains rather than universe, security, document?

699