SQL View is not working properly for computed measures. Why?

• Related Articles

• In the KPI Grid Utility - SQL View, does the computed measures show as "SQL Generated from KPI"?

  They are computed measures and will not be displayed in the query as it is calculated by the application itself.

• Can we use computed measures in an expression measure?

  Computed measures cannot be used in an Expression measure.

• Why is Weekday analysis by branch KPI not working properly?

  For the Measure C170 the DB_COLUMN_NAME (date_key) was mentioned in lower case. whereas in DB the column name (DATE_KEY) is upper case. Change the Measure "C170" DB_COLUMN_NAME to upper case, the KPI should work fine.

• Parameter is not working properly in BCM . Why?

  The parameter names should be defined with the following conventions daydiff, weekdiff monthdiff: datediff, wdiff, monthdiff.

• Why is the newly added Module not working properly?

  If there is no KPI in the newly created module, the module does not reflect in the Analyst.