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
- 12260 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 do you mean by trimming sql in microstrategy?
Which of the end-user items leverage olap services?
Explain level extension?
Name different type of objects in microstrategy?
Explain the difference between rolap and molap?
What is purpose of having conditionality in metrics in microstrategy?
What are the programs that we can do with the microstrategy architect?
What is report as filter in microstrategy?
What are objects? Name different type of objects in microstrategy?
Explain true primary keys?
Is there a difference between view filter and report filter?
what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?
Your i-sever crashed. What will you do?
Explain fact constellation schema?
you are required to disable webusers to use only one i-server. How would you do that?
