BIA/BWA - sizing with one period data?

[Former Member]

Hi All,

We have already a system that is about to go-live in 2 weeks.

We realized that some of the reports are running slow and need to boost the performance.

Now, we need to add BWA on that.

We have 21 cubes. But, we want to choose 5 cubes to be part of BWA.

We have only one period of data in the each of the 5 cubes.

The question is:

To size the BWA system, if we size the memory & Disk Space by using the program RSDDTREX_MEMORY_ESTIMATE, by multiplying the program result based on the one period of data, by 2 and 3, respectively, would that be enough?

Or do we need to multiply the result by the number of periods that we are going to store in the cube, e.g., by 12, for one year, by 24 for 2 years, by 36 for 3 years, etc...?

Also, let's say for cube 1: it's 300 GB memory required, and 500 GB Disk space required, and for cube # 2, it's 400 GB memory required, and 700 GB disk space required, then can I say the total requirement of BWA server is just add the two numbers, which is 700GB RAM and 1.2 TB Disk space?

Thanks in advance,

Best Regards,

- Shashi

[former_member93896 · Accepted solution]

Shashi,

1) Run the program for all 5 InfoCubes that you want to put on BWA

2) Calculate T1 = total memory for InfoCubes * number of periods (assuming the Cube contains one month of data)

3) Callculate T2 = total memory for master data * growth (10-15%)

4) Total memory required for BWA = (T1 + T2) * 2

5) Total disk space required for BWA = (T1 + T2) * 3

Regards,

Marc

SAP Customer Solution Adoption (CSA)

[Former Member · Accepted solution]

Hi Marc,

Thanks a lot.

Best Regards,

- Shashi

[anindya_bose]

Hi Shashi

Please note Cube Size and Index size Ratio will be 5:1 .

That is for 500 GB Cube , 100 GB memory will be required.

Please check the below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e05a68a8-83d6-2c10-0b8e-85823f352...

and OSS note 917803.

Best Regards

Anindya