The KPI isn't producing results 'ordering by'. It also does not append the 'order by clause' to the KPI query

• Related Articles

• Why is the KPI not displaying results and throws an exception - 'java.lang.Exception: Query Execution Failed! : A column has been specified more than once in the order by list. Columns in the order by list must be unique'?

  In case of a crosstab KPI, the KPI fails to execute when the crosstab ORDER BY clause contains two columns. Therefore the columns in the ORDER BY must be unique. Also, please note that the measure ORDER BY should be specified as None as it will not ...

• Why is the graph linked to the KPI not producing results when drilled-down? However the KPI produces results when drilled-down.

  By efault, the graph linked to the KPI is pinned. In such cases, we have to set the Default Pin Graph' Option available in Visual Personalization to Do not pin graph . Pin Graph is a graph utility which allows you to freeze a graph at its current ...

• Visible measures do not appear on export to excel when the KPI is a cross tab KPI producing no results. Why?

  If the records are not available for the selected filters in the cross tab KPI, then the KPI will appear as a standard grid excluding cross tab. This is the behavior of the Product

• KPI shows the error- 'java.lang.Exception: Query Execution Failed ! :A column has been specified more than once in the order by list. Columns in the order by list must be unique'. Why?

  Possible reasons for this exception is: 1. KPI fails to execute a Crosstab KPI, if the 'ORDER BY' clause contains two columns. The columns specified must be unique 2. Ensure that the measure 'ORDER BY' defined is 'None'

• Unexpected results from "weekly film dataviewer" KPI

  The Issue here is the column_name with which the measure 'C4182' was created is not mapped to any of the levels in the db2_dbmodel.xml file. This is a pre-requisite for any measure to function properly.