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 / 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 |
Post New Answer View All Answers
What are attribute roles?
what do you mean by passthrough functions?
Explain the various types of filters available.
what are logical views used for?
What are the different formatting types?
Explain fact?
what is smart metrics in microstrategy?
What is embedded metric?
How conflicts occur and what are the ways to resolve them?
What are prompted filters? Have you ever used them? Where?
What is derived metric?
Explain transformations?
What subtotaling features does microstrategy desktop contain?
Explain rw document?
What do you mean by trimming sql in microstrategy?