on 11-17-2005 11:09 PM
Hello BW Experts,
Could any one please explain Number Range Buffereing. And how to configure it for one dimension table.
Do BW people have have authorization to deal with this.
Thanks,
BWer
hi BWer,
basically number range buffering is used to increase performance. usualy SID number range buffered,
transaction rsrv can be used to check -> all elementary tests >> master data >> compare number range and max sid. and >> transcation data >> comparison of rumber range and max dimid.
transaction SNRO is used to maintain number range.
http://help.sap.com/saphelp_nw04/helpdata/en/7b/6eb2aa7aed44ea92ebb969e03081fb/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/95/3d5540b8cdcd01e10000000a155106/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/aa/dbc9b4b56143bb8f2ae909d7d040fa/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Number Range Buffering can help cube loads if you your loads result in a good number of new Dim IDs being created with the load.
Without buffering, each row of data to be loaded that would require a new Dim ID to be assigned (because it is new combination of characteristics for that dimension) must go out and read the Number Range table for that specific Dimension and get the next available number. So if you add 50,000 rows to a cube that results in 5,000 new Dim IDs to be assigned, that means 5,000 queries that must go read the table. Now if you buffered 500 numbers at a time, that would mean only 10 queries to the number range table.
In a perfect BW world, someone in your shop would have the ability to go to your P system and make the change. Chances are, this ability is locked down and you will have to get the P opened to make the change.
This can also make a big improvement in the load time if you are doing a large initial load of millions of rows to a cube.
Also - just a reminder, line item dimensions don't benefit because there really is not a dmension table for them.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.