Skip to Content
author's profile photo Former Member
Former Member

Number Range buffering ?

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 01:32 AM

    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

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/71efb490-0201-0010-949b-b2344b58b094

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 04:37 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.