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
- 13100 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
Does microstrategy intelligence server support scheduling?
Imagine this, you are required to reset the password for all users at a time. How would you do that?
What is microstrategy desktop?
What are the supported languages for microstrategy intelligence server?
Do you know how to prioritize the excecution of a report?
Is it possible to apply themes to microstrategy web? How?
Name the types of transformation?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
What are vldb properties?
What is a security filter in microstrategy?
What is the command manager?
At which levels you can set the vldb properties? Which level has the highest pecedence?
How would you increase the logical size of a table in microstrategy?
What are the various ways of incorporating security in microstrategy?
Can you create an event based schedule in microstrategy? How?
