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 / vivek jain

You can do it without using value prompt with below steps.
Create a filter on day attribute qualified on ID operator >
and set value to resolve dynamically today – last 10 days.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

739


What do you mean by static prompt report?

758


How do you ensure simultaneous releases across multiple operating systems?

750


What are prompted filters?

698


What is the difference between absolute filtering and standard filtering?

720


Explain rw document?

855


What are report filters and view filters?

745


Can we access multiple operational databases from within a single microstrategy project?

819


What is a logical size of a table and what does it depend on?

738


Explain access control?

779


Does microstrategy intelligence server support scheduling?

812


Explain the Roles in mstr?

734


What are report caches and how many types are there?

714


If your client wanted to customize the null value, how would you do that?

713


What is fact degradation?

747