Field based modelling in SAP BW4

[svenhertrich]

Hi All,

i am asking myself a very general question as i am developing since a couple of days with BW4.

Why would i develop any layer (unless the composite provider for the virtual layer) with infoObjects?
Following the LSA principles - and by reviewing the SAP BW4 business content we have following situation

• Corperate Mem. Leyer (aDSO): Field based
• Integrated DWH Layler (InfoSource +aDSO) : InfoObjects
• Virtual Data Mart Layer : InfoObjects

For me this pointless. I am not giving any end-user access on aDSO level, so why would i develop them by using InfoObjects?

The only advise i found was this

https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/66/a0e6908ddf406783807af1cb3e02f8/frameset.htm

But i don't feel satisfied with this.

Thanks a lot for discussing this with me.

[carlos_weffer]

Hi Sven

Performance also a very good reason. The presence of field-based components in the query impacts performance (lack of parallelisation, lack of OLAP cache usage, joins at runtime etc.) and query functionality (e.g. lack of HANA pushdown for exception aggregation).

Regards, Carlos