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 information is shared by the application across microstrategy web nodes?
What is pass through metrics in microstrategy?
Explain fact relation?
What is an i-server?
What do you mean by static prompt report?
What do you mean by mstr? What are the different types of mstr objects?
What do you mean by derived metrics?
Explain static reports?
How is security handled?
Explain four-tier connection?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
Explain the difference between holap and molap?
what are the different types of tests done on a microstrategy report?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
how can we direct the sql generated to use a specifc table?