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

KB45419: The Big Decimal data is rounded to 17 digits in Flash mode in MicroStrategy Web 9.x


Community Admin

• Strategy


The Big Decimal data is rounded to 17 digits in Flash mode in MicroStrategy Web 9.x

SYMPTOM:
When users run the report services document in Flash mode in Strategy Web 9.x, the Big Decimal data which is beyond 17 digits is roundedto 17 digits.
 
STEPS TO REPRODUCE:

  • Create a Teradata table and insert a column with 18 digits data.
  • Create a Freeform SQL report, insert a metric and set the data type to Big Decimal (18).

ka04W000000OdvUQAS_0EM4400000026SA.png
  • Create a report services document based on the report.
  • Run the report services document in DHTML mode (interactive, express), the data shows 18 digits.

ka04W000000OdvUQAS_0EM4400000026S9.png
  • Run the same document in Flash mode, the data is rounded to 17 digits.

ka04W000000OdvUQAS_0EM4400000026S7.png

CAUSE:
This is a known issue of Strategy Web 9.3.0.
 
ACTION:
Contact Strategy Technical Support for an update on this issue.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017