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

KB426484: How to Set Input Data Validation in Transaction Service Document in MicroStrategy Web 10.5


Community Admin

• Strategy


This article outlines how to set the input data validation in transaction service document.

This article outlines how to set the input data validation in transaction service document.
CONTENT:
Users may need to set input data validation in transaction service document. For example, End Date should be later than the Start Date, otherwise the input is invalid. The input data validation can be achieved with threshold in Strategy web.
 
  
ACTION:
1) Right mouse click on the transaction grid, choose Thresholds->Advanced
2) Choose the End Date and set a qualification as End Date less than Start Date as seen below:

ka04W000000OalqQAC_0EM440000002Sr6.png

 
3) Double click on the threshold and check Replace Data, type a replace text like “Invalid Date”

ka04W000000OalqQAC_0EM440000002SrB.png

 
 
4) Run the document in presentation mode. If the End Date is earlier than Start Date, the End Date will be replaced with the words " Invalid Date". And users can change this data directly.
 

ka04W000000OalqQAC_0EM440000002SrG.png

 
 
  KB426484


Comment

0 comments

Details

Knowledge Article

Published:

June 27, 2017

Last Updated:

December 30, 2018