-
CMS Backup
What are the steps to be followed to take backup of CMS?
-
LOV in BO Reporting
If a user wants to report a list of values that is not available in the Universe/DB, then how will you help him/her to use it in a report?
-
-
-
isolated joins in universe
what are isolated joins? whether there will be any problem if we have isolated joins in our universe?
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
How do you design a universe?
The design method consists of two major phases. During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.During...
-
Universe
A mapping of the data structure found in databases: tables, columns, joins, etc. A universe, which is made up of classes, objects, and conditions, can represent any specific application, system, or group of users.
-
Shortcut join
A join that links two tables by bypassing one or more other tables in the universe.
-
Enterprise mode
A work mode whereby a designer creates universes in an environment with a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.
-
Dimension object
An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies.
-
Detail object
An object qualified as a detail provides descriptive data about a dimension object. A detail object cannot be used in drill down analysis.
-
Connection
Set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and path to the database. Designer provides three types of connections: secured, shared, and personal.
-
Cartesian product
A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.
-
Is it correct/feasible develop a Data Mart using an ODS?
the ODS is technically designed to be used as the feeder for the DW and other DM's -- yes. It is to be the source of truth.Read the complete thread at http://asktom.oracle.com/pls/ask/f?p=4950:8:16165205144590546310::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:30801968442845,