This issue occurs when you are creating a report from the
busy hour data models.
Symptoms
When you are generating a report from a data model that
has too many KPIs, you might see the following error message:ORA-01467: sort key too long
Causes
A DISTINCT, GROUP BY, ORDER BY, or SET operations require
a sort key longer than that supported by Oracle. Either too many columns
or too many group functions are specified in the SELECT statement
that is used to pull the KPIs from a Stored Busy Hour definition of
a data model.
Resolving the problem
To avoid this issue, plan and create a report with only
the required KPIs alone and not use all the KPIs for creating the
report.