Timestamp for Snapshot / Slice / Active Form

Post Reply
nimol
Posts: 20
Joined: Fri Jun 10, 2011 6:12 am
OLAP Product: TM1
Version: 1022
Excel Version: 2010

Timestamp for Snapshot / Slice / Active Form

Post by nimol »

I'm struggling with timestamp when you are doing snapshot, slice and active form from Perspectives to Excel workbook. Can anyone advise if available or if it can be done? Thanks
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Timestamp for Snapshot / Slice / Active Form

Post by lotsaram »

This would only be relevant for a snapshot since a slice or active form contains live data. There is no option to automatically timestamp a snapshot, but have you heard of the NOW function in excel?
nimol
Posts: 20
Joined: Fri Jun 10, 2011 6:12 am
OLAP Product: TM1
Version: 1022
Excel Version: 2010

Re: Timestamp for Snapshot / Slice / Active Form

Post by nimol »

Thanks, I guess I could use now function in Excel. It could be relevant also for active form and slice because if I save such an excel document and turn calculation off I could still open and read the figures without knowing when they were retreived.

If I recall right I think Cognos Café has the timestamp and source information displayed.
Post Reply