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
Explain three-tier connection?
What are attribute roles?
What do you mean by static prompt report?
hi,can you please share with me about,what is reportlimit,report order and how can create and use
What are public objects?
What is percent-to-total shortcut metric in microstrategy?
Describe implicit attribute?
Explain the difference between holap and molap?
How does microstrategy object manager determine if two projects are related?
what specific features and functionality do you get with olap services?
What is an i-server?
What is dynamic aggregation in microstrategy?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
What are the tracing options available in microstrategy object manager?
Explain snowflake schema?