data class and storage class

[Former Member]

Hi ,

I need some info or docs on data class and stroge class of DSO /cube.

Regards

tapashi

[Former Member]

Answered partially

[Former Member]

Hi Tapashi,

Something i found about dataclass in DSO/Cube, which might be useful to you.

Within SAP BW following data class of DDIC objects are important:

DDIM Dimension Tables in BW of InfoCubes

DFACT Facts Table in BW of InfoCubes

DODS ODS Tables in BW

These have been introduced in order to improve performance while reading/writing InfoProviders. Settings of data class are maintained in "Technical Settings -> Database storage parameters" screen of TA SE11. Data class is assigned to the database tables of the InfoCube (table RSDCUBE, RSDODSO). Notice that this assignment cannot be made by any circumstances by user, only system does this while you activate InfoProvider.

Subsequently see overview of table RSDCUBEu2019s fields with link to data class according BW versions:

SAP BW 3.x (parameters only affect aggregates, not the cube):

AGGRDATCLS Data class for aggregate fact tables (only aggregates)

AGGRSIZCAT Size category for aggregate fact tables

ADIMDATCLS Data class for aggregate dimension tables

ADIMSIZCAT Size category for aggregate dimension tables

Furthermore see overview of RSDODSOu2019s fields for DSO objects as InfoProvider with link to data class:

ODSADATCLS Data class for table with active data of the ODS

ODSMDATCLS Data class for table with ODS input data

To see all available data classes check table: DDART (DD: Data Class in Technical Settings)

To see all available size categories check table: DGKAT (DD: Size category in technical settings)

Hope this is helpful.

Regards

Snehith