KB370006: "Formula Incorrect" error occurs when creating metrics in duplicated projects in MicroStrategy 10.4 HF5 and 10.9

• Strategy

This Knowledge Base article describes a known issue that affects duplicated projects in MicroStrategy 10.4 HF5 and 10.9. There's a workaround to it and a fix is scheduled for an upcoming MicroStrategy release.

SYMPTOM:
Users may notice that after duplicating a project, in the new project it is impossible to create new metrics because of an error that occurs when validating the formula.
The error in Developer is:


Formula Incorrect

The error in Strategy Web is:


Validation failed with syntax error!
Cannot find a function corresponding to + .Searching for + resulted in no matches

Additional variations of the error may exist depending upon the metric's formula. For example, "Cannot find a function corresponding to Sum. Searching for 'Sum' resulted in no matches."
STEPS TO REPRODUCE:

Duplicate Tutorial project
Open the new duplicated project either in Developer or Strategy Web
Create a metric, e.g. Revenue (metric) + Profit (metric) and notice the error

CAUSE:
This is an identified defect in Strategy 10.4 HF5 and 10.9.
ACTION:
This issue is fixed in Strategy 10.4 Hotfix 6 and 10.10. Please upgrade to take advantage of the fix.
WORKAROUND:
Restart the Intelligence Server or unload/reload the project.

Comment

0 comments

Details

Knowledge Article

Published:

November 21, 2017

Last Updated:

December 7, 2017