how to create a derived table in designer? i need steps
regarding derived table
Answer / 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 |
what is confirm dimension ?
How can you check the universe?
what is drill down?
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Explain how we drill up week to month?
Explain what would you consider as your biggest achievement and why?
what is fantrap?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?
what are they different types of report in BO?
What is aggregate table and aggregate fact table ... Any examples of both?