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.
- 6 Answers
- 13217 Views
- Target, TCS, I also Faced
- E-Mail Answers
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 specific features and functionality do I get with olap services?
Write different kinds of objects in microstrategy?
what are passthrough functions?
Your i-sever crashed. What will you do?
What is the difference between absolute filtering and standard filtering in microstrategy?
What are public objects?
What do you mean by bulk export report?
How would you increase the logical size of a table in microstrategy?
What is transformation metric in microstrategy?
What do you mean by staging area?
What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
What are the different modes to run i-server?
Explain fact?
How can the user determine the object id of an object?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
