1421491 - Universe Parameter Distinct_Values with GroupBY returns error

SAP Knowledge Base Article - Public

1421491 - Universe Parameter Distinct_Values with GroupBY returns error

Symptom

  • When using Universe parameter DISTINCT_VALUES = GROUPBY creates custom sort error.
  • Sort is incorrect when the universe parameter DISTINCT_VALUES is set to GROUPBY.
  • Exception:  DBD,NCR, ODBC Teradata driver..Selected non-aggregate values must be part of the associated group. State HY000

Environment

BusinessObjects Enterprise XIR2, XIR3.1

Reproducing the Issue

  1. Import Universe
  2. Go to File > Parameters > Parameter Tab
  3. According to Optimization for Teradata Universe Guide
  4. Set Ansi92=Yes
  5. Set Distinct_values=Groupby
  6. Select Dimension object for example Fiscal Name Qtr
  7. Go to properties and edit LOV
  8. Click Manage Sort Icon
  9. Select sort by Fiscal Qtr Age
  10. View SQL:  Select TableName.Fiscal_Quarter..From
  11. LOV returns error message.Exception:  DBD,NCR, ODBC Teradata driver..Selected non-aggregate values must be part of the associated group. State HY000

Cause

  • Fiscal Qtr Age column is not included in the Group By Clause
  • The error only occurs when applying a custom sort on universe that has parameters ansi92=yes and Distinct_values=GroupBy
  • The issue has been identified and logged under Problem Report ID ADAPT01280700

Resolution

  • BusinessObjects XIR2 This issue has been addressed by  Service Pack 6 ADAPT01280701.
  • BusinessObjects XIR3.1 This issue has been addressed by Service Pack 3 ADAPT01285746.

Keywords

KBA , BI-BIP-SL , Semantic Layer , Problem

Product

SAP BusinessObjects Dashboards 4.5