EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB37126: "Error during Bapi Execution: Invalid MDX command with [Measures]" error message appears when using a custom metric formula in MicroStrategy 10.x against SAP BW 7.0


Community Admin

• Strategy


This technote explains how to use custom metric formula in SAP BW 7.0

SYMPTOM:
The following error is encountered when using a custom metric formula in SAP BW 7.0 to filter on an attribute in Strategy 9.x: and 10.x


Error: SQL Generation Complete
QueryEngine encountered error: ExecQuery failed. MDX Execution failed.
Error type: JCO layer error. JCOStatement.executeQuery failed. java.lang.Exception: Error during MDX Query Execution
Error during Bapi Execution: Invalid MDX command with
 at com.Strategy.Database.JCO.JCOStatement3.executeQuery(Unknown Source)
. Connection String: N/A;. Connection String: N/A;. SQL Statement: with member . as 'IIf(.CurrentMember.Name = ..Name; .; NULL)'
set as '{..members}'
select {.} on columns,
non empty on rows
from
cell properties CELL_ORDINAL, FORMATTED_VALUE, VALUE, FORMAT_STRING
..
Error in Process method of Component: QueryEngineServer, Project_SAP_BW, Job 90215, Error Code= -2147212544.


CAUSE:
The syntax of the custom metric formula is incorrect. From the error above, the metric formula is:

IIf(.CurrentMember.Name = ..Name; .; NULL)

The correct syntax is to use commas instead of semi-colons in the metric formula.
 
ACTION:
Replace all the semi-colons in the metric formula with commas as shown below:

IIf(.CurrentMember.Name = ..Name, ., NULL)

  
 


Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 9, 2017