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 / amit
make a applysimple filter that calculates the start date as
the sysdate - the n days (here 10) and end date as sysdate.
this will give you the data related to sales of last n
dates.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Can intelligence server integrate with my existing data structure?
Explain compound key?
Explain snowflake schema?
can metadata be manually edited? If yes, how?
What olap capabilities do I have within a microstrategy report services document?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
What do you mean by inmon?
what are the different types of fact structures?
What are vldb properties in microstrategy?
how do you create schema objects in 2 tier connection?
How would you get two images on microstrategy login page?
If your client wanted to customize the null value, how would you do that?
Explain fact constellation schema?
Your application mode has crashed. How would you run your i-server?
What is the command manager?