BW: Hints for number range buffering
来源:互联网 发布:无锡淘宝装修 编辑:程序博客网 时间:2024/05/21 08:38
The number range object of a dimension table should be buffered if
a) the DIM table increases by a large number of data records for each request
b) the size of the DIM table levels out but at the beginning you expected or observed a significant increase
c) there are many accesses to the NRIV table with reference to the number range object of the dimension table
d) the InfoCube or the dimension table is deleted regularly and, therefore, the DIM table increases significantly in each period.
The number range object for the SIDs of an InfoObject should be buffered if
e) you regularly add many new data records to the SID table
f) you know before the initial load that there is a lot of master data to be loaded for this InfoObject
g) you delete the master data periodically and you always load many new records (this should be an exception).
How do you find number range objects of the dimensions and SIDs whose number range should be buffered?
h) You know in advance that the dimension table or the SID table will increase significantly per request.
i) You observe accesses to the NRIV table and you can determine the number range object directly in the current SQL statement.
j) A high number range level may indicate that there is a significant increase for these two BW objects (valid only for BID* and BIM* objects)
SE16 'NRIV'
-> OBJECT = 'BID*' or OBJECT = 'BIM*'
displays all number range objects with number level (NRLEVEL).
Export this output to an Excel document and sort NRLEVEL in descending order. Most candidates usually have a high number range level.
You can determine the corresponding dimension tables by using the table RSDDIMELOC. You can find the InfoObject for SIDs using the table RSDCHABASLOC (the field NUMBRANR contains the last seven digits of the number range object). The procedure is even more effective if you read the table NRIV periodically and you determine the changes using NRLEVEL.
k) Another indicator is if a dimension table or an SID table significantly increases on a regular basis.
How many instances should be buffered?
In the past, a value between 100 and 500 has proved to be efficient. If there is still a high load for these number range objects on the table NRIV, you can increase the value.
Caution:
- Never buffer the number range object of the package dimension table of a data target.
- In addition, never buffer the number range object of the request ID (RSDCHABASLOC-CHABASNM = 0REQUID), generally BIM9999998.
- Ensure that not all dialog processes are occupied permanently
(See Note 708297).
源文档 <https://websmp230.sap-ag.de/sap(bD16aCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=857998>
- BW: Hints for number range buffering
- BW:BW Statistics 安装和Hints
- BW:Maximum number of selections exceeded for InfoPackage ZPAK_4JXT7KVKHH6NMZRR64D4GHUDO
- BW:批量删除PSA的tips and hints
- Important Transaction Codes For BW
- abap number range
- SAP number range
- 【ABAP】number range
- Number range for trans./event type WA in year 2011 does not exist
- In company code XX, the number range 01 is missing for the year XXXX
- STVD弹出"Line number 50 is out of range for "main.c"."的原因及解决办法
- [LeetCode] Search for a Range (sorted integers array,find start & end position of a target number)
- BW:maximum number of sessions exceeded
- BW:maximum number of sessions exceeded
- BW---HOW to basis Lo Extraction for SAP-BW
- BW---HOW to basis Lo Extraction for SAP-BW
- OpenGL lighting hints for new programmers
- Hints for Women to Revive Romance
- Ubuntu上,tftpd-hpa 启动失败的解决方法.
- webservice上传文件
- 在线客服 生成 代码
- java原创格式
- SQL Server 2005 不能通过ip地址访问,服务实例名可以访问
- BW: Hints for number range buffering
- 内存访问越界
- SQL Server 2005 彻底卸载、重装问题
- 复制表
- 试用Windows Embedded 6.0 R3开发手记
- 如何在C++ Builder中显示透明位图
- hbitmap Cbitmap的转换
- C++ Virtual详解
- asp.net使用COM组件需要的权限设置