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
- 13721 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
Difference between project merge and object manager?
Explain two-tier connection?
How would you configure wh authentication? Explain.
Why does microstrategy object manager search for object dependencies?
What are level metrics? Why are they needed?
Explain clustering?
To save time, can many reports be run at the same time?
What olap capabilities do I have within a microstrategy report services document?
What are the various ways of incorporating security in microstrategy?
Can the administrator easily maintain and manage microstrategy intelligence server?
What according to you are the roles and responsibilities of a microstrategy developer?.
Explain batch?
what do you mean by security filter?
What do you mean by derived metrics?
What are intelligent cubes?
