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

Explain scan md?

582


How do you optimize reports in microstartegy?

646


What olap capabilities do I have within a microstrategy report services document?

538


what are the different types of tests done on a microstrategy report?

526


If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

620






How can the user determine the object id of an object?

525


What are the different types of mstr objects?

525


What are the vldb properties? Which level of vldb configurations have the highest precedence?

561


Can intelligence server integrate with my existing data structure?

564


What subtotaling features does microstrategy desktop contain?

543


What do you mean by derived metrics?

601


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

552


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

532


What are level metrics? Why are they needed?

597


How does microstrategy object manager integrate with the microstrategy product suite security model?

560