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.
- 6 Answers
- 12327 Views
- Target, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pritika
create a required value prompt on date attribute ,and
accordingly drag it in your report and save it.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / divya
Value prompt is used for User Selected Values which can be
qualified on datatype based on date.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vivek jain
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sunil.hit
actually its not that easy as it seems.
Transformation is required for accurate data. which is at high prioritization.
1)create a transformation table ...year to day type.
2)add this table to warehouse catalog
3)create a new attribute with many to many transformation mapping
4)update your schema obj
5)now create new matric...use (sum(sales)-last_10_days)
exp
6) place this particular metric and apply a dynamic prompt
it should work perfectly fine for every kinda data...for months also you can do in same way. but creating transformation is must.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pritika
in this we can just create a report filter and call simple
prompt in this filter, in this filter use the between
operator which can fetched the data of two dynamically give
date by user .
| Is This Answer Correct ? | 0 Yes | 1 No |
What is an object prompt in microstrategy?
How does microstrategy object manager determine if two projects are related?
Your application mode has crashed. How would you get the instance back?
What is a security filter in microstrategy?
can metadata be manually edited? If yes, how?
Can you create an event based schedule in microstrategy? How?
what do you mean by custom groups?
What do you mean by mstr?
Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?
What does microstrategy desktop allow users to do?
In Microstrategy, what are Logical Views used for?
6 Answers InfoCepts, Marlabs, Tech Mahindra,
I want to learn Microstrategy Tool...Can you help me to find best coaching center for Microstategy..please send details to maheswari.umaece@gmail.com Thanks and Regards, Uma
Teradata 
