1421491 - Universe Parameter Distinct_Values with GroupBY returns error

• 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

BusinessObjects Enterprise XIR2, XIR3.1

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

• 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

• 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.

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