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

KB19812: In MicroStrategy Developer 10.x, users can see and select dates in a value prompt that lie outside the specified date range for the prompt


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This Technical Note describes a behavior in MicroStrategy Developer 10.x where users can see and select dates in a value prompt that lie outside the specified date range for the prompt.

SYMPTOM:
Users can browse and select dates in the calendar beyond the restricted limits while answering a date value prompt in Strategy Developer 10.x. It is not until the user hits 'finish' that Strategy forces the user to select another value.
 
In the screenshot below, the maximum date set for the prompt is April 30, 2017, but the user can still view and select a date beyond this limit.

ka044000000kUNuAAM_0EM440000002Hn6.png

Prompt allows the user to proceed to the summary of selections even though the selection is out of bounds.

ka044000000kUNuAAM_0EM440000002HnB.png

 
When the user attempts to execute the report, an error is returned and the user is forced to re-answer the prompt with a valid date selection.

ka044000000kUNuAAM_0EM440000002HnG.png

You have entered a date later than the maximum allowed for this prompt. Please enter an earlier date.
 
CAUSE
This is working as designed. Especially for dynamic dates, the dates could become valid in a few hours/days/weeks.
 
ACTION:
This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming Strategy release.
 
WORKAROUND:
An attribute element prompt can be used as a workaround. To create a restricted attribute element prompt, follow the steps below:

  1. Create a filter on the date attribute that specifies a date range.
  2. Create a prompt and select 'choose from an attribute element list.'
  3. Select the date/day attribute to define the prompt.
  4. Use the filter created in step 1 as a filter in the prompt.

This will create a prompt that allows a user to select dates, and only present those dates that are allowable selections as options.
19812


Comment

0 comments

Details

Knowledge Article

Published:

April 3, 2017

Last Updated:

March 31, 2019