In my honest opinion, a MEASURE object is added in GROUP BY clause only when you apply an Oracle predefined function to that MEASURE in the SELECT field, or when you apply a stored Oracle function to the same MEASURE in the SELECT field in Designer environment.
For example, a MEASURE called “Counter” that has the following SELECT definition:
count(MEASURE_TRX_HOUR.ROWID)
and SUM as predefined aggregation-function, automatically GENERATES a GROUP BY clause in the “SHOW SQL” command in BusinessObjects Reporter.
The GROUP BY clause is referred only to the DIMENSIONS objects of the Query Panel.
BO is generating SQL with percentile measure object in Group by.
User does not wants this way.
How we can restrict BObj to generate SQL without Measure object in Group By.
you can click “sql” button at data provider query panel to open sql. and delete the clause you needn’t , then check the “do not generate SQL before running”. Running the query. You can get the result you want
8)
Note:
If Percentile is measure used along with dimensision object then BOBJ is generating correct SQl (percentile measure not included in Group BY).
But percentile is used along with other aggregate measure, then percentile measure object is included in Group By