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 is a security filter?
What are the various ways of incorporating security in microstrategy?
Explain fact constellation schema?
How does microstrategy object manager determine if two objects in different projects are the same?
Compare dataset and fileset?
Your i-sever crashed. What will you do?
What are configuration objects?
Your application mode has crashed. How would you run your i-server?
Write the different types of matrices in microstrategy?
At which levels you can set the vldb properties? Which level has the highest pecedence?
Your application mode has crashed. How would you get the instance back?
Difference between project merge and object manager?
What is a implicit attribute in microstrategy?
Explain standard filters?
Explain the Roles in mstr?