Explain about derived tables?
Answers were Sorted based on User's Feedback
Answer / vinay
derived tables are logical tables in the universe. to
reduce the query complexity and better query performance or
complex querys we write in derived tables. derived tables
are nothing but sql queries. thease tables can be used in
prompts...
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / srini
Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;
| Is This Answer Correct ? | 1 Yes | 0 No |
How can you check the universe?
Approximatly how many enduser can use the each bo project?
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
What is the short cut join?
can anybody explain me in detail about software development life cycle of business objects in detail?
how to add duplicte rows to the existing report in webi ?
What is security level in BO ?
how did u give developed universe to ur client?
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
Explain about alerts in bos, under what situation we need to use alerts?