2160598 - A Primary Key set on a unx universe object does not appear in the SQL generated within Web Intelligence reports | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2160598 - A Primary Key set on a unx universe object does not appear in the SQL generated within Web Intelligence reports

Symptom

  • A Primary Key set on a unx universe object does not appear in the SQL generated within Web Intelligence reports
  • This is observed when a Business Layer level Filter that includes a Prompt is used in the Query
  • The Prompt is based on a Parameter that uses a List of Values based on custom SQL
  • If a Query Filter prompt is used instead of the Business Layer level Filter, the SQL is generated correctly with the Primary Key

Read more...

Environment

  • SAP Business Intelligence Platform 4.1
  • Web Intelligence
  • Information Design Tool

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

KBA , BI-RA-WBI-BE-DP , Data Provider , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.