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

KB9496: Users get an error Your Answer must be a Number when attempting to import an Excel file as a filter for ID Forms in an attribute qualification prompt in MicroStrategy Web


Community Admin

• Strategy


SYMPTOM:
When users import an Excel file as a filter for ID Forms in an attribute qualification prompt in Strategy Web 9.4.1, the following error message appears:

ka04W00000148YwQAI_0EM44000000294I.jpeg

 
Your answer must be a number.
 
CAUSE:
This is a known issue in Strategy 9.4.1
 
Unlike Strategy Developer, Strategy Web 9.4.1 does not support binary files as an import filter. Although users can manually add additional file extensions, such as .xls, in the prompt preference the format of those files needs to be text as described in KB5583: Valid file formats for the Import Filter from File feature in MicroStrategy Web 9.4.x-10.x
ACTION:
This issue has been fixed in 9.5.1 and later. Please upgrade to take advantage of the fix.


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017