cancel
Showing results for 
Search instead for 
Did you mean: 

Bex query webi report date prompt not working

Former Member
0 Kudos

I have a webi report with Bex query prompt calendar year..I need to run the report for 5 years.. so I created a date prompt greater than or equal to and less than or equal to.. when I select 2016 in Bex query prompt results are accurate..when I select date 1/1/2016 and till date in newly created prompts (without selecting Bex calendar year prompt).. all objects in the table values are shown zeroes..

Accepted Solutions (0)

Answers (2)

Answers (2)

amitrathi239
Active Contributor
0 Kudos

do you have data in BW for the  date object  for 2016?

Year prompt is mandatory in BEx or optional?

Former Member
0 Kudos

Yes.. date object has the data from 2012 to 2016.. Its an optional

amitrathi239
Active Contributor
0 Kudos

have you tried to run the Bex query in BW? are you getting data there for date prompt?

Former Member
0 Kudos

We dnt have access to BW. But when I tried to display the date object in the report.. it is showing the values like (1/1/16..8/16/16)

amitrathi239
Active Contributor
0 Kudos

are you getting data when you enter Year value 2016 and date prompt (1/1/16..8/16/16).

if you are getting  values like (1/1/16..8/16/16) in the report then what is coming blank?

if you just enter the Year 2016 then are  you getting data in the date object?

try with between operator instead of  Greater then or less then operator in date prompt

Former Member
0 Kudos

The measure values are shown zeros and incorrect. Sorry I missed to mention in the post.

I tried with 2016 and date prompt values,.. still incorrect measure values

amitrathi239
Active Contributor
0 Kudos

check in the BEx query if prompt variable is passed in the Key figures? Might be this is related with your KF's calculations at BEx level.

Former Member
0 Kudos

What is the Bex Restricted variable format and data type that you are using as prompt?

Regards

Niraj

Former Member
0 Kudos

The date object is of date data type and format is mm/dd/yy (8/16/16)

I need to select the start and end date from the prompt calendar.