resolve self-reference table by alias tables in detail

[Former Member]

Hello Gurus,

can you tell me how to resolve self-reference table by alias tables in detail?

Many thanks.

[amrsalem1983 · Accepted solution]

its just you create a copy of that table and reference the copy to the master

right click the table, click copy, then right click in an empty space and select paste

a new table will come with a name looks like the main table

you can rename it, and join it to the main table.

good luck

Amr

[Former Member · Accepted solution]

Hello, for the following step 3, I don't understand, will you please give me some explanation for step 3?

Save your Staff universe, and test the results in Web Intelligence Rich Client as follows:

1. Run a query using Manager and Employee. Add a count on both columns.

2. Add a query with only the Manager object. Add a count. Is this the correct value?

3. Open your Staff universe in Universe Designer and edit the Manager object. To ensure

that the data is restricted to only manager data, use the Tables button. Select the

EMPLOYEE table, to force the object to use the join between the table and restrict the

data.

4. Test the result, creating a new query with only the Manager object. It returns the correct

number of managers.

5. Edit the query and add Employee. Run and display the count. There are 26 rows. Why?

The join restricts the data to look only for employees that have managers. However, there

is a manager that does not have a manager, and is now excluded.

6. Open your Staff universe in Universe Designer and add an outer join on the MANAGER

table side.

7. Save the changes and test the results in Web Intelligence Rich Client.