Locking a universe for editing

After making changes to a universe, export the universe to the repository so that other users will receive the changes

When making changes to a universe, first lock the universe:
- Import the universe
- Double Click on the universe to lock it

Outer Joins

Outer Join - When inserting a join between two tables use the (+) operand to signify that the condition will look for all possible values
e.g. LEASDMND.LEDM_CI_REF=CODEADMIN_LEASDMND.CI_REF(+)

The outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and those rows from one table for which no rows from the other satisfy the join condition. Such rows are not returned by a simple join. To write a query that performs an outer join of tables A and B and returns all rows from A, apply the outer join operator (+) to all columns of B in the join condition. For all rows in A that have no matching rows in B, Oracle returns NULL for any select list expressions containing columns of B. "
Oracle constraints re joins:
The (+) operator can appear only in the WHERE clause, not in the select list, and can be applied only to a column of a table or view.
If A and B are joined by multiple join conditions, the (+) operator must be used in all of these conditions.

A condition cannot use the IN comparison operator to compare with another expression a column marked with the (+) operator.
The (+) operator can be applied only to a column, not to an arbitrary expression. However, an arbitrary expression can contain a column marked with the (+) operator.
A condition containing the (+) operator cannot be combined with another condition using the OR logical operator.

A condition cannot compare with a sub query any column marked with the (+) operator.
If the WHERE clause contains a condition that compares a column from table B with a constant, the (+) operator must be applied to the column so that Oracle returns the rows from table A for which it has generated NULLs for this column.
In a query that performs outer joins of more than two pairs of tables, a single table can be the NULL-generated table for only one other table. For this reason, you cannot apply the (+) operator to columns of B in the join condition for A and B and the join condition for B and C. “
Examples:

SELECT C.Client_Ref, S.sales_client_ref
FROM client C, sales S
WHERE S.Client_Ref = R.Client_Ref (+);

What is an Oracle view?

A view is a select clause which filters a table, but can be accessed just as a table is accessed. The actual table structure does not exist, rather SQL is generated when the view is called.

Does cardinality have to explicitly stated in Oracle?

Oracle does not use cardinality at all. (Cardinality is where 1 to many or many to 1 relationships. This is used for performance as when a search is performed, the db engine will stop at the first match in the case of 1 to 1)

Displaying text where a column does not return a value

In a BO report, if a value does not exist use the no value function:
nvl(codesgen.desc,'No value')

"#Multivalue" error message

If you get a "#MultiValue" error when concatenating fields, use the max function:
e.g. max(operation_ref) & ' - ' & company_ref

Error logging into Business Objects

If you get the following error (USR0057),

followed by (USR0045):

It means that you client does not have the correct< repo>.key to access the Business Objects repository.