SAP BW/4HANA: the Big Data Warehouse for the Digital Enterprise Part 1 Recap #askSAP

Version 1

    1bw4.jpg

    Source: SAP

    Commercial:

    Register for these two upcoming related webcasts:

    Resource slide

     

    Last askSAP call for 2017

    Eric Leicht kicked it off

    He is the chair for the ASUG EDW Influence Council

    2bw4.jpg

    Source: SAP

    Q&A available in a few days

     

    3bw4.jpg

    Source: SAP

     

    Legal disclaimer applies

    4bw4.jpg

    Source: SAP

    Speakers today

     

    Changing Landscape of Data Warehousing

     

    "Data warehouse has been pronounced dead for a long time" - continues to be at core

    5bw4.jpg

    Source: SAP

    Bill McDermott - what do I need to do today to stay ahead tomorrow - answer can be stored in data warehouse

    6bw4.jpg

    Source: SAP

    Technology disrupting

    Data lakes - if not careful, build a swamp

    7bw4.jpg

    Source: SAP

     

    8bw4.jpg

    Source: SAP

    Not your father's BW

    9bw4.jpg

     

     

    Source: SAP

     

    Glen Leslie, BW/4HANA vision & strategy

    10bw4.jpg

    Source: SAP

    Completely rearchitected, packaged

    4 buckets "aren't marketing messages"

    Simplify BW overall

    Reduced ETL spend

    11bw4.jpg

    Source: SAP

    Modeling and data source types from 10 to 4

    Extension nodes - more tightly coupled data interaction on back end with less system configuration - hot and warm data

    12bw4.jpg

    Source: SAP

    Export to HANA Calculation Views; more openness for SQL interface

    Improve back end integration

    HANA EIM is part of the infrastructure that BW/4HANA leverages with smart data integration

    Revamped native integration with ODP interface

    Integration directly to Data Hub

    Open to the Cloud

    BW/4HANA can be deployed on premise or cloud (HEC) or through partners AWS, Azure, Google

     

     

    13bw4.jpg

    Source: SAP

     

    Simplified modeling interface

    Cloud and on premise solution

    Cloud is for easier lightweight deployment, with live connections to BW/4HANA

    Data flow workbench in Eclipse

     

    14bw4.jpg

    Source: SAP

    Rearchitect BW content

    BW/4HANA content optimized for LSA++

    15bw4.jpg

    Source: SAP

    16bw4.jpg

    Source: SAP

    Big data warehouse with Vora, connectivity to Hadoop

    17bw4.jpg

    Source: SAP

     

    18bw4.jpg

    Source: SAP

    19bw4.jpg

    Source: SAP

    In-place conversion; BW/4HANA starter is where clean-up

    Remote conversion allows for not having to do an all or nothing; take slices of BW system and convert those to BW/4HANA system (early adopter status) - expect GA early next year

     

    20bw4.jpg

    Source: SAP

    "Time to revamp"

    Record adoption

    1 year live - GA SAP TechEd 2016

     

     

    Question & Answer

     

    Hello - If someone intent to use On-premise BW/4 and S/4 HANA in Scale-up deployment, what are the options for using Warm data in BW/4 using Extension nodes?

     

    A scale-out hardware configuration is required for extension nodes. However, you still have the option of Nearline Storage (NLS)

     

     

     

    how IOT data will be loaded in BW/4 HANA system

     

    Assuming it sits in Haddop - BW/4 includes a Hadoop connector this is also something that the SAP Data Hub solution could help orchestrate and bring data to BW4 as necessary.

     

     

     

    You said that the BI content remains the same, if that s correct hen how at these old extractors be realtiime in BW/HANA

     

    for realtime extraction where required, the ODP interface supports ABAP CDS Views. The extractors themselves also don't have the same collection process required due to the simplified data model of S4 (the extractors are just compatibility views ). There are a very few deprecated extractors but customes in early testing have found what is delivered to be more than sufficient and there is an appeal process for extractors which may have been flagged for deprecation but specific customers need them for their implementation (case by case basis after discussion via Support)

     

     

     

    We are on SAP BW on HANA 7.4 - Including the time to upgrade to 7.5 %2B In Place Conversion, does that equal to a 3 months project ?

     

    No. that was a specific case. "Your mileage may vary" depending on housecleaning tasks. Please take a look at Marc Bernard's blog series on The Road to BW/4HANA to see specific housecleaning rquirements

     

     

     

    Could you elaborate on the Remote conversion of BW on any DB to BW4HANA?

     

    Please see this 3 part series on that topic https://blogs.saphana.com/2016/09/07/the-road-to-sap-bw4hana-part-1/

     

     

     

    Why has the 'Planning' option for aDSO disappeared in the BW modeling tools? Is it covered by BPC/4HANA now?

     

    Yes. BWIP/PAK roll into BPC 11.0

     

     

     

    Question is that extension node capability available for Native HANA as well like BW/HANA? to store some warm/cold data

     

    yes. please see this Teched content on the topic: http://events.sap.com/teched/en/session/33596

     

     

     

    We have an existing investment in a HANA sidecar scenario building out our models with a native SQL based approach. How would I justify an additional investment in BW4HANA. We know we can leverage the same HANA views through BW4HANA but that does not justify an investment in BW4HANA. Other arguments are typically around modelling and master data. But are there any other selling factors?

     

    typically matters of scale: cross functional reporting, scheduling, error handling begin to play a role. BW4 has an entire infrastructure to manage 100s or 1000s of data flows. doing it in HANA native requires custom dev or 3rd party solutions. BW4 provides a packaged offering. there's also Business Content as mentioned. Finally there are dozens of "small things" like integrated Currency and UOM handling, data handling for xTD reporting etc ... the OLAP Processor in BW remains a powerful solution on top of SAP HAnA.

     

     

     

    #asksap We are planning to migrate to SAP BW/4 HANA, Could you please help, with the approximate installation and maintenance cost .. and also we will not migrate everything into HANA and will plan future projects to be developed in HANA, in that case how to plan every Infocube out of BWA?

     

    please see this blog series for the things to consider in your question and how to estimate effort to convert your own environment: https://blogs.saphana.com/2016/09/07/the-road-to-sap-bw4hana-part-1/

     

     

     

    Some experience integrating SAP BW/4 HANA with Hortonworks HDP platform?

     

    Please check out our Data Hub solution which Marc Hartz will give a brief presentation at the end here. Much more information from SAP Teched if you have access. Please check with your SAP sales rep if you need more in-depth, 1:1 information/discussion.

     

     

     

    We are planning to migrate to SAP BW/4 HANA, Could you please help, with the approximate installation and maintenance cost .. and also we will not migrate everything into HANA and will plan future projects to be developed in HANA, in that case how to plan every Infocube out of BWA?

     

    please see this blog series for details: https://blogs.saphana.com/2016/09/07/the-road-to-sap-bw4hana-part-1/

     

     

     

    Archiving to NLS Sybase IQ vs. Using Hadoop for Archiving - Cost; History Reporting if needed; Reduce data HANA DB etc..Which is more advantage based on SAP future strategies?

     

    We let customers leverage the environment appropriate to their design objectives. Sybase IQ is a very powerful, disk-based columnar solution which still holds the World DW scale record at 12.1PB.

     

     

     

    That means when we have IoT directly coming into BW/4Hana, so we can perform predictive analysis in BW/4Hana and create work orders in ERP for maintenance ... Is it possible?

     

    SAP has solutions to help with the middleware required to get to this state. our Predictive Maintenance solution addresses this end to end. BW/4HANA would certainly be part of the solution for reporting and analytics off of the IoT scenario.

     

     

     

    SAP-BODS can be directly connected with BW4HANA to get data in aDSO ?

     

    yes.

     

     

     

    Twitter: is DataWarehouse still needed for 80 % of Analytics need that are operationnal, Real Time, Direct access to data?

     

    absolutely . please see major industry analyst take on EDW reqirements in the world of Big Data

     

     

     

    How will BW/4HANA help customers migrate their current BW system with complex ABAP business logic ?

     

    to the extent that those are reports, BW4 could be used to address those requirements functioning as a data warehouse.

     

     

     

    ok. but we don't want to introduce another tool like data hub/vora and want to use standard connectors. Will SDI be able to pull data from SAP IQ/HADOOP at run time for reporting? Performance will not be a big concern and will not be part of SLA.

     

    the SAP Data Hub section will be important to hear.

     

     

     

    Is there an Major update expected to BO to keep up with all the new features on BW4/Hana and the other competitors?

     

    BO 4.2 SP04 supports BW4.

     

     

     

    Do we need to Code(ABAP) to get Custom Tables data from ECC or CRM or the UI has been developed as simple drag and drop

     

    SAP SLT would be an ideal solution.

     

     

     

    What's the role for the new Web IDE in a BW/4HANA scenario?

     

    Currently it's an area where we'll focus for Administrative / monitoring solutions for BW4. BW4 modeling is done in Eclipse similar to HANA Studio

     

     

     

    What is the recommended extraction process from S/4 HANA to B/4HANA?

     

    Standard extractors work. Customers are free to use CDS Views via ODP to send data to BW4. the delivered business content continues to reflect the ECC6 data model and thus the extractors provide the best integration currently.

     

     

     

    Will SAP Data Hub be available as a Trial or Developer edition in the SAP Cloud Appliance Library so customers can try it without an on-premise setup?

     

    TBD.

     

     

     

    BW/4 HANA is presented as better at integrating external source data. Why would Data Hub and Vora be necessary then?

     

    Vora provides highly optimized Spark integration (extensions written by SAP on open source). Data Hub provides a solution for end to end data movement and monitoring at scale... that's the trick when you approach 100s or 1000s of data movements across big data, things get extremely difficult to manage. A lot of confirmation from largescale customers who face this now that Hadoop/big data is in production.

     

     

     

    Can we say that BW4/Hana is on-Premise SAP leonardo?

     

    BW4 and Leonardo would work in concert with one another.

     

     

     

    Why is a 'Data Swamp' part of the Data Hub architecture diagram?

     

    a poorly managed data lake becomes a swamp.

     

     

     

    BW/4 HANA Support Direct access mode of BW Data source which do not required to persist data into BW? (ex: 0FIGL_M30 0FIGL_M20 0FIAA_M20 for each module there are direct access supported using datasource like 0fi_gl_12 0FI_ACDOCA_20 etc..) ?

     

    please see the BW4 BCT documentation at help.sap.com

     

     

     

    Will HANA 2 NDSO be integrated with BW/4HANA?

     

    TBD

     

     

     

    How will BW/4HANA benefit customers in migrating current business logic written in ABAP ? Are there any conversion or migration tools available ?

     

    this is under evaluation as part of the tools which provide insight into housekeeping activities on BW4.

     

     

     

    After migrating to SAPBW/4HANA, what is the best practice to take the Infocubes out of BWA and runs in HANA platform?

     

    Conversion tools convert Infocubes to ADSOs. at that point the entire database for HANA is in-memory. (migration ot HANA is part of BW4 conversion). Remote migration is your option to look at it.

     

     

     

    Which are the main advantages of ODP data sources?

     

    performance - see notes for ODP 2.0 specification consistent interface for all SAP solutions Data Integrator integration for sending data to non-SAP solutions. Provides Delta via "ODQ" for data sources which don't necessarily have delta natively

     

     

     

    Can we convert Infocube to ADSO with Data?

     

    yes. the conversion tools support this. see this blog https://blogs.saphana.com/2016/09/07/the-road-to-sap-bw4hana-part-1/

     

     

     

    What's going to replace the Enterprise Portal? SCP Portal, Lumira Designer, or a custom Fiori app?

     

    EP continues. SCP is a tool of choice for some customers. There's also the Analytics Hub solution.

     

     

     

    Using S4HANA Embedded Analytics Dashboards can be created using CDS views. How is BW on HANA

     

    BW4 can extract from CDS Views via ODP

     

     

     

    is there a benefit to move to BW4/HANA before going to S/4HANA? would there be a lot of changes to be done?

     

    absolutely. this would give you a chance to check out managing an enterprise application on HANA as well as having benefit of the BW4 features we mentioned.

     

     

     

    What role does BW play in terms of a logical data warehouse environment? Is the BW the logical data warehouse?

     

    it has potential to play that role, yes.

     

     

     

    Twitter: In a brief , what's the major business benefits of BW4HANA , if customer has already been using BW on HANA?#askSAP

     

    please see the DW whitepaper linked at the end of this presentation and see BW4 on our web site.

     

     

     

    Why is Katerra using BW instead of HANA Native EDW?

     

    As majority of our data sources is from S/4HANA, it is advisable to use BW/4HANA..Also now with BW/4HANA it is more simplified now to get Non SAP data to BW with SDA/SDI and Open DSO's.

     

     

     

    There is sap note talks about white listed datasources which talks about allowed datasources indicate few of datasources are not supported by BW4HANA ? Any lights on that ?

     

    yes. this list has to be considered when moving to ODP. Feedback from customers is that most of the newer extractors delivered in the last 3 - 5 years cover those older extractors which have been deprecated.

     

     

     

    B/4 to On Premise SAP Portal NW 7.5 AND B/4 to Cloud SAP Portal both supported? as like BW to On premise SAP Portal ?

     

    The integration point is now SAP BusinessObjects so please check roadmaps for Portal-BO options going forward.

     

     

     

    As part of UI Harmonization, B/4 Reporting and Various tools can be integrate / sso / accessed from Single Source of UI ex: Embedded Fiori Lauchpad of Portal (i.e. FLP @ EP in On premise portal) where we are merging all FIori APP, Classical Transactional tile, etc..?

     

    depends on the frontend solution selected. BusinessObjects 4.2 SP04 introduced direct Fiori presentation for specific components. see the roadmap for BO solutions.

     

     

     

    after year 2025 SAP will support only installation on Hana or continue to support other databases ( eg sql , oracle , etc ) ?

     

    No. please see SAP Notes relevant to your SAP solution for direct steps.

     

     

     

    Recently we went live with 7.5 BW on HANA in June 2017 and now SAP suggesting to move to SAP B/4 HANA. How good with these very frequent SAP product suite changes for customers to adapt after investing a lot on earlier versions.

     

    BW 7.5 is supported until end of 2022. Customers wanting to innovate sooner can move immediately to BW4. All new development is now in BW4. BW 7.5 is in maintenance mode as far as features but bug fixes will be given untl 2022.

     

     

     

    Is SLT obsolete due to well working streaming based on ODP on BW/4?

     

    no. ODP is an application level data exchange. SLT provides database level replication for specific platforms.

     

     

     

    What are the scenarios that you chose to persist the data?

     

    typically: virtualize for agility (prototyping, testing, concept development) persist for performance (since you're working on an in-memory platform.

     

     

     

    Since the enhancement of Openness to different source systems , so what will be the role of data services in future

     

    still available as needed/desired!

     

     

     

    for realtime extraction where required, you said that the ODP interface supports ABAP CDS Views. so what about standard BW extractor like 0FI_ACDOCA_20/10 0FI_GL_12 - are they required any ODP ?

     

    yes. BW4 only has an ODP interface for SAP integrations at application level

     

     

     

    I understand that one can consume native SAP hana views in bw/4hana - but do they also support delta capabilities ?

     

    yes. ODP has a built in delta queuing capability

     

     

    Reference:

    More upcoming webcasts are Upcoming ASUG Business Intelligence Community Webcasts

    Take our annual survey here