If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

CubeDataUpdatedOn compare to current date

Started by FatCat, 12 Feb 2009 11:44:43 AM

Previous topic - Next topic

FatCat

I have a dashboard where I included all my cubes as data sources.

I run the command in a layout calculation to get the parameter of the update date of the cube. 


CubeDataUpdatedOn[cube item]

What I want to do is to conditionally format the update date to show delays.

I have tried

cast
add_days
cast(substring(caption[cube item] #, #, integer


Anyone have any luck comparing the CubeDataUpdatedOn[cube item] to current date?


Thanks

hpmkruit

Much easier:

_days_between (date2timestamp (Today()), CubeDataUpdatedOn ('[Cube]'))

Returns an integer with the number of days between Today and CubeUpdated date