cancel
Showing results for 
Search instead for 
Did you mean: 

BW Extractors/DXC/BODS + HANA Native Star Schema: Is this mixed scenario possible?

Former Member
0 Kudos

Dear Experts,

(Excuse me for providing an extra detailed background before the actual question)

Our Transaction systems portfolio (Industry Pharma/Manufacturing, operating in 170+ countries)

-------------------------------------------------------

SAP ECC on SQL Server (implementation in-progress) + 10 Other Custom Applications

Our BI Portfolio

-------------------------------------------------------

Nothing. Already purchased HANA (7.4 planned version) + Business Objects and will be implemented along with SAP ECC ERP

So point is our BI is a greenfield project and we don't have legacy of any BW Cubes / BEx Queries. As a BI/DW Architect I am evaluating different models to implement HANA, where design objective is to have maximum simplicity, extremely fast speed to respond to change requests, SQL based modeling and fully exploiting the raw power of HANA.

Question -

  1. What is the best way to utilize the "tremendous" power of ready made DataSources / Extractors and delegating this work to BW part and still allowing myself the freedom to do my custom modeling - relational / star (on top of imported data into HANA using these DataSources) and not restricting myself to Artifacts of Cubes & Similar providers. Whether to use DXC, BW Extractors => DSO... ? (final exposure will be through HANA Analytical / Attribute / Calculation Views)
  2. Also would appreciate if you can express your views on this way of HANA implementation.

Along with this custom modeling, for operational reporting we are anyways going to use HANA Live and SLT.

A detailed explanation / rationale behind this approach is mentioned in the attached file.

Thank you for reading this.

regards, Abhishek.

meet.abhyshek@gmail.com

Accepted Solutions (1)

Accepted Solutions (1)

former_member184458
Active Participant
0 Kudos

Abhishek,

yes, the mixed scenarios are explained in https://www.experiencesaphana.com/community/solutions/net-weaver-bw/bwonhanafaq/content, and especially in the section EDW https://scn.sap.com/docs/DOC-59781 and Mixed Scenario: https://scn.sap.com/docs/DOC-59762.

thank you

erich

Answers (0)