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
Can we access multiple operational databases from within a single microstrategy project?
Difference between project merge and object manager?
Explain fact relation?
What is derived metric?
How to use consolidations in microstrategy report?
How is security handled?
What are the different formatting types?
What are vldb properties?
What do you mean by consolidations?
What subtotaling features does microstrategy desktop contain?
what do you mean by kimball?
How does microstrategy object manager determine if two objects in different projects are the same?
Explain fact degradation?
What is an i-server? What are the different modes to run it?
Name the types of transformation?