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

BW Number Range Buffering

Hi Experts,

To avoid the high number of accesses to the NRIV table, activating number range buffering for BW objects (Main Memory Number Range Buffering). I want to activate number range buffering. I refered SAP Notes 130253. How do I know what could be recommended Buffer size to maintain by SID and DIM id.

I read in notes that 100 - 500 is recommended buffer size we can maintain. But How should we know that what buffer size we need to keep for SID and DIM id's.

Eg :

Object name From number To number Number Range Status CUBE DIM BID0001234 1 2000000000 4464891 ZCI_MO2 ZCI_M0223 Recommended Buffer Size

?

Here how can I decide what should be buffer size to be maintained ?

Your help is highly appreciated.

Thanks alot.

Sameer.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2012 at 04:25 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 03, 2012 at 07:39 AM

    set it based on number range level for your dimension, 500-1000 is like a general value, but if you are loading lots of data then number can vary i have set even number 1500, ask your basis to closely monitor the DTP when its running so that you can get to know which reading the NRIV table the most

    -laksh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 03, 2012 at 08:03 AM

    HI

    It all depends on the data that we get from the source system . If there exits large number of entries in the source system then u have to pass large values .

    Regards,

    RaviChandra

    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.