All Measure Values are not displaying between two given dates

[Former Member]

Hi,

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.

Regards,

ArunKG

[Former Member]

Hi Arun ,

Dont create prompt on Dates in webi based on cube or Bex query,

because it consider it as char,

eg date between 1.1.2011 to 30.4.2011

it will consider as Char and bring the dates what ever comes between 1 to 30 irrespective to month.

But this error has been corrected in SP4 etc......

[former_member200330]

Hi Arun,

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

Please Help,

Thanks & Regards,

NRR

[Former Member]

Please check all date fields (including start date ) used in Between condition are of data type "DATE"

Cast to DATE type if any of the fields is of charater data type.

Regards,

Bilahari

Edited by: Billuu on Oct 24, 2011 9:23 AM

[Former Member]

Hi,

Data Type Date only..........

Regards,

ArunKG