1603460 - List of Values not displayed in Universe

SAP Knowledge Base Article - Public

1603460 - List of Values not displayed in Universe

Symptom

Unable to get all the list of values of an object

Environment

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.

Cause

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

Resolution

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

Keywords

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

Product

Crystal Reports 2008 V0