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 for Me (Login required).

Search for additional results

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