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 information is shared by the application across microstrategy web nodes?

1021


What is pass through metrics in microstrategy?

947


Explain fact relation?

969


What is an i-server?

1041


What do you mean by static prompt report?

966


What do you mean by mstr? What are the different types of mstr objects?

991


What do you mean by derived metrics?

968


Explain static reports?

981


How is security handled?

988


Explain four-tier connection?

903


Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

1013


Explain the difference between holap and molap?

1033


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

875


Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

988


how can we direct the sql generated to use a specifc table?

905