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)