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
- 13706 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 passthrough functions?
Explain fact table?
How is the number of passes in a sql query significant in performance evaluation?
Describe implicit attribute?
How does microstrategy object manager determine if two objects in different projects are the same?
Explain the Roles in mstr?
What are different types of metrics in microstrategy?
What do you mean by static prompt report?
Is microstrategy desktop available in other languages?
Explain the difference between rolap and molap?
explain html document?
Your application mode has crashed. How would you run your i-server?
What do you mean by xml cache?
Can microstrategy desktop access operational data systems?
What is microstrategy?
