May 2, 2006 at 8:18 am
Hi Guru,
Where can I find OLAP tables Metadata?
I want to query metadata to find out when was last time the cube ran? I schedule the cube to process every night. If the cube did not get processed then I'll get e-mail.
Please provide some tables where I can track down the last time the cubes get processed.
Thanks so much,
Silaphet,
May 4, 2006 at 4:08 am
Hi,
How is it possible that u scheduled the cube and it did not process at the scheduled time.
Weather it will process successfully or get failed.
BTW u can get the information from sysjobhistory in msdb database.
If u want to know from analysis services then it is not possible.
But there is a way to get the information.
When the cube is processed analysis services creates folder of the cube and there information inside the folder(same name as cube).
If the cube is not processed then analysis server will not create the cube.
C:\Program Files\Microsoft Analysis Services\Data\EPINAV_OLAP(Location to see the processed cube folder )
u can also check
open the analysis manager and browse down till the cube abd select the cube and see the metadata properties.
from
Killer
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply