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?

1000


Your application mode has crashed. How would you get the instance back?

893


Explain true primary keys?

956


Explain three-tier connection?

902


Compare microstrategy and tableau.

930


What are report caches and how many types are there?

933


Name the various types of filters?

911


What are the programs that we can do with the microstrategy architect?

992


Is olap services sold as a separate product?

876


You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

886


What does microstrategy desktop allow users to do?

873


What is percent-to-total shortcut metric in microstrategy?

936


Explain fact table?

994


How do you achieve schema object version control?

960


What is level prompt?

918