I want to get sales data for the last (suppose 10) dates
dynamically
using value prompt how can i do it and drag it onto report
editor.
Answer Posted / amit
make a applysimple filter that calculates the start date as
the sysdate - the n days (here 10) and end date as sysdate.
this will give you the data related to sales of last n
dates.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are level metrics? Why are they needed?
Your application mode has crashed. How would you get the instance back?
Explain true primary keys?
Explain three-tier connection?
Compare microstrategy and tableau.
What are report caches and how many types are there?
Name the various types of filters?
What are the programs that we can do with the microstrategy architect?
Is olap services sold as a separate product?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
What does microstrategy desktop allow users to do?
What is percent-to-total shortcut metric in microstrategy?
Explain fact table?
How do you achieve schema object version control?
What is level prompt?