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 is the order of precedence of vldb properties?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
If your client wanted to customize the null value, how would you do that?
What is an object prompt?
Can you explain surrogate key?
What is report as filter in microstrategy?
What are prompted filters?
What are prompted filters? Have you ever used them? Where?
What are the types of facts in microstrategy?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
How do users receive only information that they want?
How are microstrategy reports performance tuned?
Explain four-tier connection?
Name the various types of filters?
Difference between project merge and object manager in microstrategy?