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

KB263374: How to create a prompt to order the date from 'StartDate' to 'EndDate' (Between Day1 and Day2) on the same prompt/index in MicroStrategy Web 9.3.x and above and 10.x


Community Admin

• Strategy


In some business scenarios, users may wish to create a prompt to order the date from ‘StartDate’ to ‘EndDate’ (Between Day1 and Day2) as one prompt/index in MicroStrategy Web. This article explains how to achieve that result.

In some business scenarios, users may wish to create a prompt to order the date from ‘StartDate’ to ‘EndDate’ (Between Day1 and Day2) as one prompt/index in Strategy Web.
This technical note describes how to create a sample prompt in Strategy Tutorial Project.
The sample prompt is as show below.

ka04W000000OgueQAC_0EM440000002HEi.jpeg

For the reference, when a user defines prompted filters, the report prompt page will be displayed as below, note that there are two prompts to qualify on Day attribute:

ka04W000000OgueQAC_0EM440000002HEe.jpeg

STEPS:
1. Create a Prompt using Prompt Generation Wizard in Strategy Desktop/Developer. Check ‘Filter definition prompt’ -> select ‘Qualify on an attribute’ , and click ‘Next’.

ka04W000000OgueQAC_0EM440000002HEb.jpeg

2. Choose a ‘Day’ attribute, and click ‘Next’

ka04W000000OgueQAC_0EM440000002HEc.jpeg

3. Input prompt ‘Title’ and ‘Instructions’ if needed, and select ‘Prompt answer required’ and click ‘Modify’ of Web options.

ka04W000000OgueQAC_0EM440000002HEj.jpeg

4. Select Display Style ->‘Text box’, Default operator -> ‘Between’, and click ‘OK’.

ka04W000000OgueQAC_0EM440000002HEX.jpeg

5. Back to step3 window, and click ‘Next’.
6. Click ‘Add’ to configure default prompt answers in Qualification Editor.

ka04W000000OgueQAC_0EM440000002HEg.jpeg

7.Double click the following ‘Definition’ area and open the ‘Attribute Qualification’ pane as shown below. Select ‘Between’ of Operator and configure the default values and click ‘OK’. 

ka04W000000OgueQAC_0EM440000002HEh.jpeg

   
8. After ‘OK’ in step7, click ‘Save and Close’ as shown below.

ka04W000000OgueQAC_0EM440000002HEV.jpeg

9. Back to step 6 window, and click ‘Finish’ and input prompt name and save it.
10. Create a new report and apply the prompt to the Report Filter.
263374


Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017