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 |
How do scheduling the report in BO XIR2? can you say what are they steps?
How to delete the duplicate colums in a sql table ?
is there any limit for rows and columns in cross tab
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to link one location universe to other location universe
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible
I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!