BPC 7.5 - Data Manager filling tablespace
We are installing a brand new BPC for NW 7.5 SP4 system. When trying to import data from .txt files via the data manager, the system is generating /1CPMB/DM0000xxx (example /1CPMB/DM0000001) tables. The problem is these tables are being generated with a size category of 9. This defaults to a next extent of 320MB. This is on an Oracle-based backend BI 701 system with Dictionary-based tablespace.
If you only upload 1-2 records, then it falls under the initial extent of 16KB. But if you upload enough records to get past that initial extent, then it will blow up and take up 320MB of space, most of it being wasted.
We've engaged SAP Support and thus far they have not been able to provide a means to have these tables generated with a lower size category, such as 1, or any other work-around to this issue.
Initially, we were trying to load 60-100 smaller datafiles. But seeing how BPC is dealing with them by wasting so much space, we are looking at combining the number of files to a smaller number. If not, you could theoretically try to take up 32TB of space.
We can reorg the tables after the fact, but that doesn't help the newly generated tables every time we upload a file using data manager.
1) Login to BPC for Netweaver website
2) Go into the excel portion
3) log into the applicationset
4) click on edata at the top of the screen
5) select upload data file
6) enter source and target locations. the file is a .txt file (40KB in
7) click OK to start the