Key date properties popup

[Former Member]

HI all

when I refresh the webI report, a pop up with name key date properties is showing up, and once i enter the date value init then it is taking me to prompt window.

I just wonder why this popup is showing up, in Bex query properties I don't see any variable in the key date assigned.

My second question is I need to show the prompt values in the header of the report. I can show the one which is in prompt window by using UserResponse() function, but if I use the same UserResponse() function for the key date variable it is not showing up in the report.

Thanks

[arijit_das · Accepted solution]

To capture the key date value, the required function is DataProviderKeyDate and not UserResponse.

And if you don't want the key date to appear as a separate prompt, drag the calendar day(0CALDAY) infoobject in the free characteristics section in the BEx query and rebuild the universe. In that case UserResponse will work too.

Regards

[Former Member · Accepted solution]

@Pumpactionshotgun:

very thank you for the reply, I tried the function can you please help me with syntax too because I tried this

=DataProviderKeyDate("Calender Date(Parameter,Mandatory)")

It's not taking it and saying dataproviderkeydate() using invalid data type, but I feel it is correct.

Thanks

[Former Member · Accepted solution]

@Pumpactiongun:

Nevermind I got the syntax, very much thank you for the helpful input.

Thanks