How to know if a powerpivot cube has been deleted and not unloaded?

Question

Hi,

I have currently published some powerpivot workbooks to Sharepoint and looking at the cubes that it created from SQL Server Management Studio.

How do we know if a PowerPivot cube has been deleted and not unloaded? Can we find it out from the DMV?

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 1

Hello Jason,

Could you please be more specific about your question? and give more explanation to your scenaro. Do you want to check whether the PowerPivot has been deleted from the SharePoint PowerPivot Gallery?

Thanks for your information.

---

Challen Fu

TechNet Community Support

Answer 2

Sorry for not giving details :).

Ok, so I was testing the metadata for PowerPivot and seeing what all we can get from the DMVs or existing tables. Now, I saw that there are tables called Usage.Loads and Usage.Unloads in the database for PowerPivot Management Data. These tables will give information on all those PowerPivot cubes that got loaded as well as unloaded in the cache. Now, the question is whether I can differentiate between a Powerpivot workbook that got unloaded and one that got deleted by just looking at thee database?

For eg, if I haven't used a PowerPivot book for say one month, it  will get unloaded from teh cache and an entry would be there in Usage.Unloads table. But what if I delete that workbook from the Sharepoint gallery after it gets unlaoded? Does it get logged in any table? If yes, where?

Also, I saw that some of my workbooks are not present in the Usage.Documents (which I thought would have a list of all my documents) table but were in the Redirect tables. Any idea why?

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 3

Any updates? :)

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 4

Got an answer from Jeffrey Wang (Principal Software Dev Lead at Microsoft) - 

"We prefer users leave the PP workbooks alone so workbooks are deleted automatically based on specified timeout or when a new version replaces an older version, the Usage cube should be updated immediately when a workbook is deleted that way. If an admin deletes a workbook directly from Sharepoint, we have a thread periodically, daily?, check Sharepoint database against our database and if we discover a workbook getting deleted that way, we should also update the Usage cube accordingly with a delay obviously. I have not seen this in action so don't know if it works correctly or not."

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)