CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
Answers were Sorted based on User's Feedback
Answer / ramesh
No.We cannot create view in BO universe.view is similar to derived table in BO where we can create our customised columns involved complex calclutions from already existing tables and columns and make the joins to normal tables and we can create objects and classes for any other table in universe structure pane.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / pbs
yes.We can't create views in Universe.views are stored as SQL.Derived tables are stored as tables.Exection is faster in case of derived tables as it operates on the new table directly ,but views are SQL and executes and operates on the source table and then fetches te records.Advantage of view is any changes in source table will also get reflected in view,but in derived table it is not possible.
| Is This Answer Correct ? | 0 Yes | 5 No |
wha is the difference b/w merge dimension and combining two different data providers?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
Explain what are the steps to be taken to schedule the report?
what is merged imension in 6.5 and webi
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
What would you consider as your biggest achievement and why?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....
Analysis in business objects?
What is domain? How many are there in a basic setup? What are they?