COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sathish_cognos on 10 May 2010 11:34:05 AM

Title: layout calculation
Post by: sathish_cognos on 10 May 2010 11:34:05 AM
Hi,
We usually display cube updated time on the report title, to display when the data is refreshed. but now i need to less three hours from the cube updated time to convert the time to enduser standard timing.
the layout calculation is :
CubeDataUpdatedOn([dimension])

how to subtract the three hours from the cubedata updated time...it throws errors like incorrect syntax, parsing error  :(, guide me on this