Value prompt is used for User Selected Values which can be
qualified on datatype based on date.

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.

create a required value prompt on date attribute ,and
accordingly drag it in your report and save it.

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.

By adding the value prompt in defining metric value.

1  creating attributes and facts 
  2  creating the reports$dashboard and scordboards
  3  creating customer group $ consolidation
  4  creating metric,filter,prompts ,drill maps & free form  
     SQL
  

	Created filters, attributes, compound attributes using the
attribute creation wizard.
	Created facts using fact creation wizard.
	Created prompts and custom groups and consolidation.
	Created test cases as a part of unit testing of the
generated reports.

1.creating Schema Objects(facts.attributes)
2.creating Pubilc Objects(metrics,filters 
prompts,reports..etc)
3.creating dashbords for reports.

I'm looking for something similar in feature as 
well...anyone know the answer to this?

you can do so by ODBC test tool one of the component of
microstrategy through wich u can update delete or even alter
the table specification as per your need

you can update or insert by putting the update/insert 
statement in post or pre sql of the report

CAn be done in Query Builder

Hi ,

we can do this with microstrategy office. import the report 
in excel , write a macro to update or delete or insert.this 
will work fine. i have try it...

Yes IT can be acheived by using VLDB Properties of a report.
Using Pre/POST SQL statements you can insert or update the 
data in a database.

By changing the Logical Size of the "specific" table. After 
changing table size, you need to update schema.

if it is required for metric to calculate from a particular 
table in report, you can try changing the "level"  in the 
merics.
 or by using relationship filter also can direct to a 
particular table ,based on the requirement.

modifying the logical table size is a good idea, but it can 
affect all reports which depends on the attributes defined 
on the same table.

In addition to above answers, you can force a fact to take 
data from the required table only

a logical view is a view that u obtain by querying the db 
thru sql. these result can be stored as a table then.

Logical view is just a table(logical table) but it is 
create in deskop by writing our own SQL as per Our 
requirement based on the physical tabes what we import from 
our database.Once if it is create itacts as a physicaltable 
as other phisical tables.

Using the Level parameter in the Metric level options

Assuming you have OLAP licence,the easiest way to direct to
a particular table is to create a dummy fact on the
table,include the fact in metric and put the metric in
report objects.

This can be acheived by decreasing the logical size of the 
desire table in a such a way that it should be less than 
other tables. AS Microstrategy will look the tale having 
the least logical size and will make a join with that table.