Conflict between Date values at Infocube & Query Level

[Former Member]

Hi Folks,

I am stuckup with a strange situation and it is:

The value of date fields are coming correctly at infoprovider level and when i call the same infoprovider at query level the values are totally different.

Any suggestions in this regard.

Thanks

[Former Member]

answered

[former_member209728]

Hi,

We have noticed a similar difference in our implementation as well. The date-time shown in the RSSTATMANPART table were different from the dates in the query level.

We found out that the date and time for the requests in the RSSTATMANPART table were recorded in GMT while in the cube were in EST (the local time of the server).

[Former Member]

Hi,

Are you using the same user for running the query and for checking data in InfoProvider, otherwise there might be personal settings difference.

Execute your query in RSRT and check the output.

Regards,

Durgesh.

[former_member182470]

Hi,

Run the Query in RSRT and see how the date fields are?

Refresh the cache, because your Old cache might be still there......

Regards,

Suman

[Former Member]

Can you give us an example of the difference in the date values at Infoprovider & Query level ?

Regards

Raj