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 / vivek jain
You can do it without using value prompt with below steps.
Create a filter on day attribute qualified on ID operator >
and set value to resolve dynamically today – last 10 days.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the command manager?
Explain the difference between holap and rolap?
what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?
What is static prompt in microstrategy?
How do we resolve attribute roles in microstrategy?
How can you make the sql query to be based on a specific table of your choice?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
Describe implicit attribute?
Can I access intelligent cubes without olap services?
Explain factless facts?
What is an i-server?
Your i-sever crashed. What will you do?
What are the tracing options available in microstrategy object manager?
How is the number of passes in a sql query significant in performance evaluation?
At which levels you can set the vldb properties? Which level has the highest pecedence?