Help to gather information for SAP HANA : quick sizer

[Former Member]

Hi,

We need to gather some information about our system, in order to make the correct sizing of SAP HANA Database.

We are on DB6 database and are considering moving to HANA.

We need to gather the following information about the definition of Infocubes:

• Number of dimensions
• Number of Key-figures
• Compression factor

We also need to gather the following information about the definition of DSO’s:

• Number of numeric fields
• Number of texts fields
• Average character length in bytes
• Datastore is write optimized or not

Does anybody know an easy way to gather all this information?

Thanks in advance

[umashankar_poojar]

Hi,

       Just to add to Suman's reply,

    To know whether DSO is write optimized or not

• Goto Table RSDODSO, give 'W' in ODOSTYPE (Type of DataStore) to get all write optimized DSOs in system.

Thanks,

Umashankar

[former_member182470]

Hi,

       http://scn.sap.com/docs/DOC-39682

• Number of dimensions - Run SAP_INFOCUBE_DESIGNS in SA38, You can export this report to excel and take a count

• Number of Key-figures - Go to RSD1 t-code and select Key Figures and take Active Key Figures in the system. You may try to export to excel. Alternatively, you can go to RSDIOBJ table and give KYF for Key figures and try with RSDKYFtable too

• Compression Factor - What do you mean by this? We do compression on the Infocubes with an in built feature in the Infocube. We do table level compression by various tools like MSCOMPRESS on MSSQL Databases

• Number of numeric fields - You can get this info from RSDIOBJ table
• Number of texts fields - RSDIOBJTtable
• Average character length in bytes - Ask your BASIS to get into DB02 t-code and get the details
• Datastore is write optimized or not - Can't say

For your reference http://scn.sap.com/thread/228303

Regards,

Suman