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
- 13367 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 is level metrics in microstrategy?
What are vldb properties?
What is adaptive metric?
What is an i-server?
Explain snowflake schema?
Your account is locked and your administrator has forgotten the password. What would you do?
What is a compound attribute in microstrategy?
What is a joint child?
Can microstrategy desktop access sap data?
what is the difference between the report filter and report limit?
What do you mean by consolidations?
How do users receive only information that they want?
Explain the difference between holap and rolap?
What is embedded metric?
What do you mean by trimming sql in microstrategy?
