Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is the order of precedence of vldb properties?

936


Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

901


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

883


What is an object prompt?

963


Can you explain surrogate key?

970


What is report as filter in microstrategy?

862


What are prompted filters?

867


What are prompted filters? Have you ever used them? Where?

926


What are the types of facts in microstrategy?

967


Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

820


How do users receive only information that they want?

917


How are microstrategy reports performance tuned?

912


Explain four-tier connection?

853


Name the various types of filters?

895


Difference between project merge and object manager in microstrategy?

937