BW4HANA - Advanced DSO ( Aplication Layer or DB Layer)

[aluri_hemanth]

Experts - It always intriguing question to me for one of the Scenario. As we all know Advanced DSO is the new Data target replaced for CUBEs. However if I create a BEX query on top of advanced DSO will it reads the data from HANA DB layer or Application Layer ?.. If Ye, why is the new option where ' External SAP HANA view ' which generate a calculation view. I understand that all Calculation views are read from HANA DB Layer

So my question is does it make any difference creating a BEX query on top of ADSO or on the Generated calculation view on the same ADSO ?. May I know if both options read the data from HANA DB layer ?

Awaiting for interesting answer

Thanks! Aluri

[erdempekcan]

Hi,

As long as the functions & formulas you use in query designer support HANA pushdown, it doesn't make any significant difference.

Please check the note 2063449 for the supported functionallities.

[FCI]

The data are stored in Hana. So, in both cases you read the Hana tables. But, there are differences:

In the BEX case, your user is a BW user with BW authorizations. In the CV (calculation view) case, your user is a Hana user with Hana authorizations.

In the CV case, your calculation view can be accesses with SQL tools, not in the BEX case. This is probably the main difference that push to this kind of scenarios.

In the BEX case, the additional OLAP layer allows you some additional features, not in the CV case.

Regards,

Frederic

[aluri_hemanth]

Thanks Frederic for your respnse. so performance perspective it is the same either we create on ADSO or Generated calculation view.

Because my finaly virtualization layer will be Composite provider to merge both Generated calculation views with Cutom created calculation views for Mixed scenarios concept and the reporting tool will be BO Analysis of office

Do you see any limitations with this approach ?

[FCI]

Well, the OLAP layer should bring its own cost. Performances should be slightly lower compared to a Hana Calculation view. But I don't think it will be significant (if there is no complex OLAP function in the query of course).

This is just an intuition, I never actually benchmarked both scenarios.