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.
I also have a similar requirement but with a little bit of change, I need to compare the Bill Date of the material to the date that is entered by the user using UserResponse(). For the user to enter the date, i am using the Calendar Day Dimension in filters pane. Now wen i am trying to calculate the Days between the two dates using the DatesBetween() it is saying that there is no dat to retrieve.
I guess i might be having the problem as i am trying to use the Calendar Day dimension to filter the data. Can you suggest another work around for this problem
Thanks & Regards,