Error: SQL Generation Completed. QueryEngine encountered error: ExecQuery
failed. MDX Execution failed.
Error type: JCO layer error. JCOStatement executeQuery failed.
java.lang.Exception: Error during MDX Query Execution: Invalid MDX command
with CURRENTMEMBER
When the transformation metric is removed from the report, the execution completes successfully.
CAUSE:The definition of the transformation metric is not correct. The steps to create this kind of metric are in the following technical note:
KB16096: How to write a custom metric formula in MDX to implement a transformation in MicroStrategy Engine 9.x. The formula must use the MDX function
CurrentMember on a hierarchy. The error occurs when this function is applied on an attribute.
ACTION:Apply MDX function
CurrentMember on a
hierarchy instead of an attribute.
