SAP BW - SIZING

[Former Member]

Hello,

I want to do the sizing of an existing cube ? I am not a technical person but I was given

to find out.

Please help.

Thank you

Regards

Praveen

[former_member228339 · Accepted solution]

Hi,

Use this SAP_INFOCUBE_DESIGNS use DB02 T-code ..> Segment..> detail analysis ( use DB_GET_TABLE_SIZE)

Regards,

[Former Member · Accepted solution]

Hi Krish,

Thank you so much for your reply.

Can you please elaborate on SAP_INFOCUBE_DESIGNS ?

Regards

Praveen

[former_member228339 · Accepted solution]

Hi,

The no of ROWs(fact table)/ no of rows in each dim gives u the density

Regards,

[MartinMaruskin · Accepted solution]

SAP_INFOCUBE_DESIGNS is ABAP report which can give you details on BW cube.

Run transaction SE38 (eventually SA38) and put SAP_INFOCUBE_DESIGNS into name of ABAP report and press F8 or choose Run icon from tool bar to run this report.

On the selection screen of this report enter your cube... and run this selection to see the output of report.

[Former Member · Accepted solution]

Hello,

Thank you for all the answers.

Also can you please elaborate

DB02 T-code ..> Segment..> detail analysis ( use DB_GET_TABLE_SIZE)

Thank you

Praveen

[former_member228339 · Accepted solution]

Hi,

It gives the row count and table size (limit_kb).......

Regards,

[Former Member · Accepted solution]

Hello,

I ran SE38 and entered SAP_INFOCUBE_DESIGNS into the report. It ran but it never gave

an option to enter the cube.

Please help.

Regards

Praveen

[former_member209032 · Accepted solution]

Hi

Before running the report, update the cube stats first. Ask ur BW team to do this. Then run the report and search for ur cube dimensions.

Regards,

Raghavendra.

[former_member209032 · Accepted solution]

And by the way what u mean by sizing? whether u want to find the existing size of the cube? if that is the case then go to DB02 and find the size of DIM table, F table and E table. If you want to predict the future groowth of the cube then use SAP quick sizer.

[MartinMaruskin · Accepted solution]

Sorry for confusion, I had no access into the BW system when I was writing my previous post.

Actually there are all the available cubes in system depicted on output screen right after you ran this report.

So while you got the output just search for particular cube you are interesting in and you get the figures of its size.

Also see SAP Note:

[1461926 - FAQ: BW report SAP_INFOCUBE_DESIGNS|https://service.sap.com/sap/support/notes/1461926]

for information on that report.

[Former Member · Accepted solution]

Hi,

Below is the output. Is there a way to interpret this information.

ZABSOURCE rows: 12,079 density: 0 %

ZBSOURCE /XBIC/FZBSOURCE rows: 12,079 ratio: 100 %

ZBSOURCE /XIC/EZBSOURCE rows: 0 ratio: 0 %

ZBSOURCE /XIC/DZBSOURCEP rows: 2 ratio: 0 %

ZBSOURCE /XIC/DZBSOURCET rows: 51 ratio: 0 %

ZBSOURCE /XIC/DZBSOURCEU rows: 2 ratio: 0 %

ZBSOURCE /XIC/DZBSOURCE1 rows: 2 ratio: 0 %

ZBSOURCE /XIC/DZBSOURCE2 rows: 144 ratio: 1 %

ZBSOURCE /XIC/DZBSOURCE3 rows: 158 ratio: 1 %

ZBSOURCE /XIC/DZBSOURCE4 rows: 42 ratio: 0 %

Thank you everybody for the help.

Regards

Praveen

[Former Member · Accepted solution]

Hi,

all records of you cube are contained in the fact table. Nothing compressed yet. You defined 4 dimensions which are not bigger than just 1 % of the fact table. That is a good ratio, so your cube is designed very well.

regards

Siggi