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

KB40373: "Analytical Engine Error. Variant conversion failed" error occurs when running a dashboard in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


SYMPTOM:
 
In Strategy Developer 9.x, the following error is obtained while attempting to run a dashboard:
 

ka02R000000kcKyQAI_0EM440000002DDO.png

 


Analytical Engine Error. Variant conversion failed.

 
In Strategy Web 9.x, running the dashboard in DHTML mode results in the following error:
 

ka02R000000kcKyQAI_0EM440000002DDP.png

 
 


An error has occurred on this page.
Your request could not be processed. Please try again. If the problem persists, contact the Administrator.
Error when answering the prompt. Please review your answer(s).

 
NOTE: The dashboard can be executed successfully in Flash mode both in Strategy Web and Desktop.
 
 
CAUSE:
 
The ID form data type for one attribute in warehouse is timestamp but it is formatted as text in the attribute editor. The inconsistency makes the dashboard fail.
 
Flash does not work in the same way as DHTML mode, and it has tolerance for the data type mismatch. The default mode for dashboard execution in Strategy Web is Flash so when running the dashboard in Web returns no error.
 
 
ACTION:
 
Use ScanMD to fix the data type mismatch between the warehouse and attribute definition.
 
Refer to technical note below for detailed usage of ScanMD:
KB35809  Using ScanMD to fix known logical metadata inconsistencies in the Strategy 9.x Product Suite  
 
 
 
 
 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

May 9, 2017

Last Updated:

May 9, 2017