The measure name appearing in the measure browser displays as 'Net Sales 1' instead of 'Net Sales'.

• Related Articles

• Why is the measure name displayed as 'Net Sales 1', instead of 'Net Sales' in the Measure Browser?

  Login to the Admin module and navigate to Metadata Management > Manage Measures. Check if the Measure Name is displayed properly. If not, modify the measure name as required and click 'Re-Cache Changes' to activate the changes.

• Does Expression measure for Net Sales contribution% work?

  Other than the base measures, any measure will not work in Expression measure. This is the current product functionality. Since Net sales Contribution% is a contribution measure, it should not be used in the filter expression.

• Why is the expression measure for Net Sales Contribution% not working?

  Net Sales Contribution% is a contribution measure and it should not be used in the filter expression. You can use only the base measures to create expression measures.

• Line graph displays the error, 'Query Execution Failed ! :Ambiguous column name 'DATE_KEY'. Why?

  This error occurs if the column name is not defined properly. Illustration: --------------- The 'orderByDes' attribute - "DATE_KEY" might not be enclosed within '#' i.e. It should be defined as '#DATE_KEY#' For all the Dimension levels (For e.g. ...

• Expression measure considers measure IDs instead of measure names and hence values appear as 0 in KPI grid. How can this be corrected?

  This problem has occurred because the measure IDs are not defined properly in the below expression measure. CASE WHEN (SUM(C3508)+SUM(C3505)+SUM(C3507)) 0 THEN ROUND((SUM(FLOAT(C3506))/(SUM(FLOAT(C3508))+SUM(FLOAT(3505))+SUM(FLOAT(3507))))*100,2) ...