EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB11297: How to delete information in the Enterprise Manager warehouse tables for a specific project in MicroStrategy Enterprise Manager


Community Admin

• Strategy


How to delete information in the Enterprise Manager warehouse tables for a specific project in MicroStrategy Enterprise Manager.

In Strategy Enterprise Manager 9.x, users can delete information from their Enterprise Manager warehouse tables for a specified time range. Refer to the following Strategy Knowledge Base document for details on this:
 
KB10191- What are the 'Custom Time Window' and 'WH Data Deletion' buttons in the Strategy Enterprise Manager Console?
 
In Strategy Enterprise Manager 9.x, users can delete this information for a specific project as well. Upon clicking the 'WH data deletion' button in the Enterprise Manager 9.x console, the following window appears, listing the projects monitored by Enterprise Manager and those which are still existing in the metadata being monitored by Strategy Enterprise Manager console. In other words, it is not possible to run a warehouse data deletion on Strategy Enterprise Manager console for those projects which have already been deleted in the metadata.
 
Also note that this option ONLY deletes data from the Enterprise Manager Warehouse tables listed below and does not delete data from any lookup tables.

  • IS_SESSION
  • IS_PROJECT_FACT_1
  • IS_REP_FACT
  • IS_DOC_FACT

 

ka04W00000148FLQAY_0EM440000002Bla.gif

 
This allows users to selectively specify the project for data deletion from the Enterprise Manager warehouse.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 4, 2017

Last Updated:

June 4, 2017