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
  3. Topics

KB33345: "Invalid element value 'NO SQL EXECUTED' for attribute 'SQL EXECUTION Indicator' (form"). Expected value type is numeric." Error received when running a report with the SQL EXECUTION INDICATOR attribute in MicroStrategy Enterprise Manager

Community Admin

• Strategy

In MicroStrategy Enterprise Manager project, when running reports using the attribute 'SQL EXECUTION INDICATOR' as a Page-By users receive the below error.

Symptom

In Strategy Enterprise Manager project, when running reports using the attribute 'SQL EXECUTION INDICATOR' as a Page-By users receive the below error
 
Sample Code/Error
Invalid element value 'NO SQL EXECUTED' for attribute 'SQL EXECUTION Indicator' (form"). Expected value type is numeric 
 

ka04W000000OfFVQA0_0EM440000002Aqd.jpeg

 

Cause

This is a known issue in Strategy Enterprise Manager 9.0.x. This issue occurs because the attribute SQL EXECUTION INDICATOR has the wrong data type and column alias for the DESC form . The DESC form is Text but in the data type and Column Alias shows Integer. 
 

ka04W000000OfFVQA0_0EM440000002Aqh.jpeg

 

Action

In order to resolve this issue users will need to modify the Column Alias for the DESC form to Text and also modify the DESC form Datatype type to text to match it.

ka04W000000OfFVQA0_0EM440000002Aqb.jpeg

 

Comment

0 comments

Details

Knowledge Article

Published:

June 2, 2017

Last Updated:

June 2, 2017