-
编辑 删除
大数据量LOADING导致的DTP死锁
[@more@]ST22:出现问题的原因是在开始数据LOADING之前没有删除INDEX。 INDEX不但降低了数据LOAD的速度，而且会导致数据库死锁。 解决的办法就是LOAD之前删除索引，在数据load完成之后修复数据立方体的索引。
-
编辑 删除
Buffering Number Range while loading Data
[@more@]Number range object for dimensions of a certain cube:Step 1: Run transaction SE37. Enter a function module called RSD_CUBE_GET, and then run it;Step 2: Enter the InfoCube name IC_NEWBC2 and other information and execute it.Step 3: The entry E_T_DIME under the column Export parameters is a table that contains the InfoCube dimension information. It has six entries. Double-click the E_T_DIME entry to display the table contents;Step 4: The NOBJECT column lists the number range objects, on
-
编辑 删除
Rules for Dimension Design
Rules for Dimension Design[@more@]Do not include any characteristic into your cube if it is not used by any query. For possible future usage, it can be included into DSO.Between a navigational attribute VS. a characteristic, the first option is better for load performance and the second option is better for query performanceMinimize the size of dimension tableMinimize the number of dimensions, but it is more important to minimize the size of dimension tablesFor high cardinality characteristi
