SYMPTOM:
When a user tries to edit a derived metric and change certain aspects of the formula, that user may be prompted with the message:
The editing of a metric that does not require SQL execution, such that the new formula will require SQL execution, is not allowed
3. Click OK, and then re-edit the derived metric. This time click the function f(x) button and select SUM() and the Profit Fact. Or you can type in Sum(profit) and then select the Profit Fact after validation.
4. Click OK and the Strategy will prompt this error message:
The editing of a metric that does not require SQL execution, such that the new formula will require SQL execution, is not allowed
CAUSE:
There are certain objects that are not allowed in derived metrics. More information can be found on derived metrics in Product Manuals.
In the above situation, new SQL had to be generated in order for the fact table to be used because that fact table was not being used in this report, and since derived metrics does not generate new SQL, users will see that error message.
ACTION:
This is by design. Either create a new derived metric if enounters this message or use objects that are already in the report objects window.
