I have an issue with one of my Webi Reports.
For the report I have used Prompt date using UserResponse() and created a start date for the Prompt date using RelativeDate().
Actually my requirement is MTD report where I want to display the Measure value between the above mentioned dates. But whenever I use the these between dates along with the measure I am not getting all measure values for the material numbers in the report, its showing some measure values only even though its having values.
But whenever I use the Report Filter in the Webi I am getting correct values, ie, I used the Calendar Day dimension directly in the Report Filter with between operator.
what could be the reason for this...........
Plz help me in this.