Timestamp issue in WEBI query filter

[Former Member]

Hi ,

How to pass timestamp values from one report to another report through hyperlink?

Scenario :

First report query Timestamp format is 'yyyy-MM-dd hh:mm:ss' . while passing this value to second report ,

query timestamp is changing to 'yyyy-MM-dd 12:00:00' .

Not getting the exact timestamp from the first report .

example : first report query timestamp '2006-07-13 11:33:12'

                 second report query timestamp '2006-07-13 12:00:00'

Let me know if any further details required .

Any input would be helpful .

Regards,

Prabin

[former_member198519]

Adding to the above suggestion. Try using opendoc, see if you can make use of IsMparamDateTimeDR parameter in opendoc.

Have a look at the below code:

http://:/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Aa6GrrM79cRAmaOSMGoadKI&sID Type=CUID&sRefresh=Y&lsMparamStringDR=[c],[d]&lsMparamNumberDR=[3],[4]&lsMparamDate DR=[Date(2003,6,3)],[Date(2003,6,4)]&lsMparamDateTimeDR=[DateTime(2003,6,1,3,1,1)],[DateTime(2003,6,1,4,1,1)]

For reference here is link to Open Doc guide

[Former Member]

Hello Prabin,

Try converting that report to a String using FormatDate([TimeStampObject];"MM/dd/yyyy hh:m:ss") and then collect it on your report 2 through hyperlink later on you can always convert that string to DateTime in Report 2.

Regards

Niraj

[Former Member]

Hello Niraj ,

Thanks for the response.

We are using Time stamp field as a prompt in the first report .

User wants to display the date timestamp as a calendar in prompt. If we convert this field into string we'll miss the calendar .

Also we have applied the below sap note for the same.

https://launchpad.support.sap.com/#/notes/2081225/E

Regards,

Prabin

[Former Member]

I am sorry If I was not clear on my previous post Once that TimeStamp is prompted to end user collect that in your Report1 and create a dimension as I suggested above and instead of passing that Prompt pass this variable to the other Report2 through Hyperlink.

Please correct me if my understanding is wrong.

Will the end user get a prompt again in Report2?

Regards

Niraj

[Former Member]

As you mentioned we have created  the variable in first query and passed this variable value to second report query .

We are able to see the AM values but for PM we are getting "no data to retrieve" .

Regards,

Prabin

[Former Member]

Hi Reason for that is when converting it to a String we didn't considered AM and PM Please modify that part as FormatDate([TimeStampObject];"MM/dd/yyyy hh:m:ss A")

[Former Member]

As per your suggestion, We have modified the variable FormatDate([TimeStampObject];"MM/dd/yyyy hh:m:ss A")

But still we are unable to get the PM values.

Regards,

Prabin