SAP Knowledge Base Article - Public

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

Reproducing the Issue

  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


Crystal Reports 2008 V0