Skip to Content
Former Member
Apr 14, 2010 at 12:04 PM

SQL2005 is keeping temp table after succesfull dimension processing


When processing dimensions, I notice that on SQL there are tmp tables that do not get deleted. These tables have a different owner (not dbo but the installation user of BPC, with the domain prefix)

Any idea why these temp tables are there?

Example of such a temp table: tmpMBRAccount_20100315094306 (for the dimension Account)

Version : SAP BPC 7.0 SP7 on SQL 2005, multi server (SQL clustered - virtual app server - physical OLAP server)