When you build analytic view, why Data package, time and units dimensions

[Former Member]

When you build analytic view, why Data package, time and units dimensions which are standard mandatory dimensions, gets added to teh infocube design. In BW.

Why doesn't it happen here in SAP HANA.

Just trying to understand, most of teh functionality, methodology here in hana is derived from SAP bw.

Thanks a lot for the helpful info.

[Former Member]

Hi,

The main diference between infocube in BW and analytical view in HANA is the data storage. HANA analytical view does not store any data since its a view. So data package dimension is not at all required.

The dimensions tables in BW are generated at the run time. Though you specify them in design, when you activate in the background they are created automatically. Whereas in HANA, you utilize the existing dimensions from the attribute views that you create. Hence, you have to explicitely add time dimension if required.

For unit, HANA treats the unit to be part of the fact table hence its an private attribute. No need to have unit dimension seperately. Of course if you are going with currency conversion then you need to have other units/currencies in other dimensions, But there is no requirement to place them in different dimension called Units.

The major difference is BW uses extended star schema where as HANA uses classical star schema.

Regards,

Pravin Karkhanis.