on 07-02-2012 7:25 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mr, Sameer,
Please go through this url.
Regrads,
Anand Mehrotra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.