date/time stamp in OLAP Cube

[Doug]

Is there a field in the OLAP cube that captures the time and date of
when it was last updated? And if not, is there a way to create such a
field? I know this information is available on the Admin page in PWA,
but I need it within the OLAP cube. I have created several queries in
Excel that pull data from OLAP and manipulate it based on the date of
the last OLAP update.

Thanks.

 

[Marc Soester [MVP]]

Hi Doug,

PWA tells you when the OLAP Cube was created, so I assume that it does keep
the date stamp somehwere. Unfortunatly I dont know where. At least you know
that it is somewhere
Hope that will help you

 

[Doug]

Thanks, I guess that's encouraging. Does anyone know if there is a
table field map of the OLAP cube available anywhere?

-Doug