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


Please Help Members By Posting Answers For Below Questions

Can I access intelligent cubes without olap services?

565


What is level metrics in microstrategy?

581


Explain clustering?

536


What are logical views used for in microstrategy?

536


Explain the Roles in mstr?

546






What is an object prompt in microstrategy?

572


What security is provided with microstrategy desktop?

554


Explain fact structure?

599


Does microstrategy intelligence server run on windows®, unix®, or linux®?

548


what is the difference between the report filter and report limit?

529


How would you configure wh authentication? Explain.

532


hi,can you please share with me about,what is reportlimit,report order and how can create and use

4509


What are different types of metrics in microstrategy?

557


Difference between project merge and object manager?

575


Can reports be executed in off-peak periods?

590