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 are level metrics? Why are they needed?

1089


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

1007


Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

994


what do you mean by passthrough functions?

1017


Describe implicit attribute?

1066


Explain the difference between holap and molap?

1106


Explain fact constellation schema?

1085


Explain md doctor?

1023


What is level metrics in microstrategy?

1114


What is the order of precedence of vldb properties?

1066


How will you monitor the errors received while running i-server and report?

987


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

5329


can metadata be manually edited? If yes, how?

1069


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

942


What is an i-server? What are the different modes to run it?

1022