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

KB484283: Missing leading zeros in attribute forms when creating or editing a HyperIntelligence card


Wanqi Peng

Quality Engineer, Principal • MicroStrategy


This article explains why leading zeros are excluded from attribute forms when editing a pattern for a card with alternate keyword matching enabled. This article also provides a solution to avoid this behavior.

Description


When editing a pattern for a HyperIntelligence card using pattern matching, the object or attribute form with a Double data type will lose its leading zeros, if there are any. 
 

Steps to reproduce

  1. Import a dataset with a numeric column via Data Import and save it as a cube. 
  2. In Workstation, build a card with the newly saved cube. 
  3. In the Card Editor, enable pattern matching. 
    If your object or attribute form begins with zeros, they will not appear. For example, if your attribute form is 0012345, it will be displayed as 12345. Notice the leading zeros are not shown. 

 

Why is this happening?


Numeric objects or attribute forms have a default data type of "Double," which will cause the leading zeros to be excluded.

Solution


Change your data type from Double to Text via Data Import or when preparing data.


Comment

0 comments

Details

Knowledge Article

Published:

May 22, 2020

Last Updated:

July 10, 2020