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
Explain how many universes can be created in a project?
Can Bo generates the Report from the cubical data Explain?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How to schedule the report in b.o?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain difference between zabo and webi?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
explain in detail about type 3?
Can we create universe with no cache??
What is the functional & architectural differences between business objects and web intelligence reports?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain in detail about type 2(scd),