One of my clients came up with a request - We need to create a report that prompts the user for a date and a second prompt that prompts whether the user would like to see MTD or YTD metric based on the answer to the date prompt.
Really simple solution! If you haven't gotten in to this mode of thinking then do so now - Divide and Conquer.
There are two separate requests here:
Create a report (MicroStrategy Tutorial) with Year, Month and Day in the template. Define a report filter - Day. Easy Peasy!
This step assumes you have already created n metrics that you would like to offer in the prompt selection - in this example Revenue, Revenue - MTD and Revenue - YTD. Next, create a new prompt using Prompt Wizard. Make it an Object Prompt and offer the above mentioned three metrics as objects available for selection. Save and close the prompt wizard.
Simply drag and drop the prompt to report template area (not report filter), save and execute.
An easy solution to complex sounding request.
Really simple solution! If you haven't gotten in to this mode of thinking then do so now - Divide and Conquer.
There are two separate requests here:
- Date Prompt
- Object Prompt
Create a report (MicroStrategy Tutorial) with Year, Month and Day in the template. Define a report filter - Day. Easy Peasy!
This step assumes you have already created n metrics that you would like to offer in the prompt selection - in this example Revenue, Revenue - MTD and Revenue - YTD. Next, create a new prompt using Prompt Wizard. Make it an Object Prompt and offer the above mentioned three metrics as objects available for selection. Save and close the prompt wizard.
Simply drag and drop the prompt to report template area (not report filter), save and execute.
An easy solution to complex sounding request.
Comments