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 I access intelligent cubes without olap services?
What is level metrics in microstrategy?
Explain clustering?
What are logical views used for in microstrategy?
Explain the Roles in mstr?
What is an object prompt in microstrategy?
What security is provided with microstrategy desktop?
Explain fact structure?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
what is the difference between the report filter and report limit?
How would you configure wh authentication? Explain.
hi,can you please share with me about,what is reportlimit,report order and how can create and use
What are different types of metrics in microstrategy?
Difference between project merge and object manager?
Can reports be executed in off-peak periods?