1603460 - List of Values not displayed in Universe

Unable to get all the list of values of an object

BOE version: XIR3.1

Database: Sql Server 2005

Server OS: windows Server 2003

1. Create self join on a table
2. Go to the properties of  any object of that particular table
3. Click on edit
4. We observed that the self join condition is in the lov sql of the object.

The self join condition reflects in the LOV sql of  all objects of the table on which self join defined.

Solution 1:

1. Remove the self join from the table.

Solution 2:

1. Go to  properties of  each object
2. Click on Edit.
3. Click on Sql
4. Remove the self join condition from the Sql
5. check "do not generate Sql before running" option
6. Click on ok and save the universe
7. Now we will get all the lov's of the objects

Self join , List of values , KBA , BI-BIP-SL , Semantic Layer , Problem