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
- 13480 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
How we can decided drilling options for an attribute?
Explain attribute?
You have got the requirement from a client. Explain the technical approach you will take now.
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
What does microstrategy intelligence server allow users to do?
How would you get two images on microstrategy login page?
Is there a difference between view filter and report filter?
How to use consolidations in microstrategy report?
What are logical views used for in microstrategy?
What are the different types of mstr objects?
How to optimize a report in microstrategy environment?
What is the difference in the way microstrategy handles custom group and consolidations?
Explain attribute role?
how can you direct the sql generated to use a specifc table?
What are the vldb properties? Which level of vldb configurations have the highest precedence?
