ods vs infocube

[Former Member]

Hi,

ive one ods and one infocube when we load the data why should we prefer loading in infocube than ods since both contains the data?

can we convert RKF into CKF IF POSSIBLE xplain by step -step procedure?

ram.

[Former Member]

Hi Ram,

Loading data to ODS or Cube, the main purpose is reporting. Loading data to cube or ods or ods to cube, its all depends on the data modeling and business requirements. If you are loading data directly to the infocube, that means the data is pure. Data maintaince is costly in CUBE where are ods is cheaper.

Cube is always the better option for reporting point of view as it has the greater flexibility to see the data. Data are stored in multidimension mode. Where are ODS is like a simple Table which contain Rows & Columns only. You can not drill down the data in the hierarchical way.

Hope this helps you.

Sanjiv

[Former Member]

Hi,

ODS stores data in the detailed form & cube stores the aggregate level of data.

Suppose your datasource doesn't give before and after images for delta records , to avoid duplication of records we first load to ods and then to cube because ods have overwrite functionality.

Based on the requirement we decide weather to load to ods or cube.

If you want to restrict a particular key figure based on some charecteristic we go for restricted keyfigure.

If you want to calculate a new keyfigure based on the existing key figure we go for cal keyfigure.

Both are different concepts.

regards,

haritha

[Former Member]

Hi Ram,

ODS is having overwrite functionality whereas InfoCube has additive functionality,

depending on the requirement we can load the data to any one.

can you explain a bit more about your second question

Regards

Sajeed

[sap_cohort]

InfoCubes are designed to allow better analysis of the data. The DSO (ODS) is more like a database table which is not so good for reporting data many different ways.

You may need to give more context to your 2nd question...

Good Luck.

[former_member188975]

Hi Ram,

Your question is not very clear...it is entirely your data modeling choice whether you need to load to the cube or ODS. What excatly is you scenario?

Also why do you need to convert an RKF into a CKF? RKF is the key figure that has some char values defined with it to act as the restrictions, whereas CKF is a calculation or formula defined with the help of different mathematical or other functions. Since both serve different purposes, what is the case to convert...