1 2 3 15 Previous Next

BusinessObjects BI for SAP

216 Posts

This was an SAP webcast last week.




Full disclaimer - I am not using this functionality


Figure 1: Source: SAP


Figure 1 shows the type of connectivity between BW and Web Intelligence.


Figure 2: Source: SAP


Size the system correctly; this cannot be emphasized enough the SAP speaker said.


SAP speaker said to size yourself or hire SAP Consulting services


Go to https://service.sap.com/sizing then go to Sizing > Sizing Guidelines > Analytics


It is updated; latest update was in February of this year and is relevant to SAP BusinessObjects Web Intelligence


Figure 3: Source: SAP


The number processing servers and  how many concurrent connections are important considerations per Figure 3


Single processing server per machine; ensure disk cache is available – no limit in memory


Figure 4: Source: SAP


Out of box, you need to better size APS, the SAP speaker said


Figure 5: Source: SAP


Request time out – mimics the amount of time it waits to hear back from a service/server when it gets the data back


Regarding the safety belt see SAP BusinessObjects Increasing Stability by Setting Limits on Max. Retrievable Cells From SAP BW into Web Intelligence Using BICS


Figure 6: Source: SAP


Upgrade, the speaker said to see more performance improvements


Figure 7: Source: SAP


SAP speaker said “Don’t use ConnectionServer32” listed in Figure 7


Figure 8: Source: SAP


Implementation of lean was not fully achieved until BI4.1 SP02 patch 1


Figure 9: Source: SAP


For me, bullet number 3 was new (“determine the actual error being thrown by WebI rather than the error reported to the end user”)


Figure 10: Source: SAP


Run query using RSRT back in BW

Run query through Analysis OLAP/BEx Analyzer – issue is with BW/BICS and not WebI


Figure 11: Source: SAP


Not all features of a BEx Query are supported by Web Intelligence


Look up SAP Note 1869560 - see http://service.sap.com/sap/support/notes/1869560


Figure 12: Source: SAP


Error is thrown when WebI processing server encounters an error when communicating another service, as shown in Figure 12


Figure 13: Source: SAP


See note below:



Reproduce error while have End to End trace


Figure 14: Source: SAP


Do a more refined search; capture root cause error and search for that


Speed up processing of incident – include trace files


Provide raw file to SAP Support – “Do not filter it”, the SAP speaker said


Figure 15: Source: SAP


Figure 15 is a summary.


Full disclosure - I am not using BW with Web Intelligence but these are things you can do with most of the tools when working against BW.


Consider attending SAP TechEd && d-code .  Join ASUG for the ASUG SAP TechEd Pre-conference HANDS-ON: SAP BusinessObjects BI 4.1, SAP BW and SAP BW on SAP HANA – All in One Day, October 20th.  This includes exercises for BW and Web Intelligence. Register today


Also see:

Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions


The roadmap Integration of SAP BusinessObjects BI Suite with SAP BW and SAP ERP was just updated as well (SMP logon required)



In case you may have missed, SAP TechEd d-code is now SAP TechEd && d-code.


Continuing our ASUG meet the speaker series, I am pleased to introduce Kumar Chidambaram of Sigma Aldrich.  His session is EA 215, titled A Holisitc Approach to BI Using SAP HANA, SAP BW, and SAP BusinessObjects.  Get to know Kumar below (photo of Kumar provided by Kumar):




Kumar is working as an IT Director at SIGMA ALDIRCH CORP and is responsible for business intelligence & analytics and SAP technology and a member of the IT leadership team.. He has worked with SAP products & Implementations since 1998 in different roles and responsibilities.  At Sigma Aldrich he is currently running a ‘green field ‘SAP implementation program called SAP NEXT, with SAP HANA as the core technology platform. Their current implementation scope includes following ECC, CRM , SRM , TM , EWM, HR, GTS , APO , BI , Business objects and allied products .  His go live date is Jan 2016.  They have been an SAP customer since 1997 using several of SAP products including ECC 4.7 and BW on HANA currently .


His personal career spans over two decades engaged in different roles in management and IT, spanning manufacturing & service industries and across different parts of the world including Europe & USA. He holds a degree in science and an MBA among other professional certifications.


He lives in Saint Louis, Missouri, with his wife  Sukanya and says he is blessed with two daughters Swathi ( a third year medical student) and Smrithi who is entering college this year.   He personally enjoys Indian classical music, reading fiction  & travel. He enjoys walking long distances across nature trails or quiet surroundings.


I met Kumar in March at an SAP event and found him to be articulate, knowledgeable and forthright.  This is the type of customer-speaker you want to hear from when you attend a SAP event.


Here is his abstract below of his session:


As part of Sigma-Aldrich's strategy to implement a robust and scalable enterprise data warehouse (EDW), they recently migrated their SAP Business Warehouse powered by SAP HANA platform and implemented an SAP BusinessObjects platform and allied toolsets to support their wide user base ranging from desktop to mobile. Hear their practical experience.


So add Kumar's session to your agenda today.



Join ASUG at SAP TechEd && d-code

Venetian/Palazzo Congress Center

ASUG SAP d-code Las Vegas sessions are now published - for a complete listing please see here

Save the date Monday, October 20th for ASUG SAP TechEd d-code Pre-conference Day


Meet ASUG SAP d-code Speaker Charles Reeves - Implementing Enterprise Master Data Management

ASUG SAP d-code SAP BW 7.4 powered by SAP HANA Speaker - Introducing Pawel Mierski

ASUG SAP d-code Sessions Are Published - Featuring SAP Mentors

Journey to Mobile BI - Meet ASUG SAP d-code Speaker Peter Chen

Did you know?

Simon To

Developer Wars 2014

Posted by Simon To Jun 30, 2014


Are you good at building dashboards and visualization? Do you want to let the world know how good you are? This is your chance. Show off your visualization skill at the Developer Wars (DevWars) at ASUG SAP Analytics and BusinessObjects Conference!


This year, the Conference is on September 22-24, 2014 at Omni Fort Worth Hotel (1300 Houston Street, Fort Worth, TX 76102). These are some important links:

Conference Registration: http://www.asugonline.com/asug-sap-businessobjects-user-conference/

Developer Wars Rules: http://www.asugonline.com/wp-content/uploads/2012/10/2014_Dev_Wars_Rules.pdf

Developer Wars Team Submission: http://www.surveymonkey.com/s/TQ89T5W


This is the third year that we host the Developer Wars. It is getting better every year. Last year we had chosen City Year as our beneficiary organization to receive all the visualization solution provided by our contestants. It includes, but not limited to, the winning solution from The Bollywood Spartans team. If you have not been to the Developer Wars, it is a fun-filled event that you don't want to miss. There is an excellent blog written by Marie Alami and Avery Horzewski on last year's Developer Wars.


You can also watch our wonderful MC, Jamie Oswald (@oswaldxxl), and the last year's event on YouTube.


The contestants are not only graded on how to resolve the business problem. They are also graded on how to present the solution. Showmanship is a big part of the competition. And that makes the Developer Wars so unique and so much fun.


So what are you waiting for? Get your team together and sign up! See you at Fort Worth in September!


Simon To



I attended ASUG Annual Conference, co-located with SAPPHIRENOW.  Due to illness, I never made it to the SAPPHIRENOW show floor.  I only attended ASUG education sessions.  As an ASUG Volunteer, I place the ASUG education sessions at a higher priority; no marketing, and getting to hear customer stories.


First, if you missed this year, consider attending next year when ASUG Annual Conference will be May 5-7th




All ASUG presentations are here (no logon required)


Understand your Requirements to Pick the Right BI Tool

Slides are here if you are interested.




Source: SAP


When selecting the right BI tool, your role is to listen to the requirements, not suggest a tool.


Source: SAP


Understand your audience - are they analysts, decision makers, or consumers?  Why attend conferences?  Why join a user group like ASUG?  It helps you understand the SAP BI portfolio and strategic direction.


The other part of this is monitoring your users.  During this session SAP asked, "who has statistics turned on in BW"?  Almost every hand was raised.  Next question - who has auditing turned on in their BI Platform?  Fewer hands were raised.  It is important to monitor what your users are doing.


Source: SAP


Above shows some common obstacles to finding the right BI tool.  You can't simply work with just one tool and misunderstandings of capabilities of the solution are some of the common obstacles.  As an example, comparing how BW hierarchies work in the different tools.



Source: SAP


The comment on this slide was you can "go some where but not come back" when it comes to the Report-to-Report Interface (a common question here on SCN).


Source: SAP


I liked the comparison of the above chart (pre Lumira 1.17).  Coming with SAP Lumira bar charts are now supported.


Source: SAP


The above compares the Mobile BI requirements with the products.  A common question is offline support, scheduling and broadcasting.



Source: SAP


What tools are used are used by those who create the reports?  You can see that IT/Designer uses more complex tools to create the reports.




Source: SAP


Who consumes which tool?  Notice that IT / Designer does not consume reports.


More to come.





Join ASUG for a BI4.1 BW on HANA ASUG pre-conference session on Monday, October 20th at SAP TechEd && d-code .  Registration to open in a few weeks.

Roadmap and Best Practices for SAP BusinessObjects BI 4.x with SAP NetWeaver BW and SAP ERP

Convergence of BI

Future of BI

ASUG Annual Conference, ASUG at d-code, SAP Mentor Monday Recap

Latest News on Design Studio - ASUG Annual Conference Part 1

Selling SAP HANA to the C-Level - Animal Health Shares at ASUG Annual Conference

In case you missed it (or you didn't want to stand), I presented Sizing of SAP BusinessObjects BI4 at TechEd in Las Vegas last fall (October 2013). The goal of the talk was to present what's new when sizing BI4. There was content for all audience members: those migrating from XI 3.1, those migrating from BI4.0 to BI4.1 and those proactively re-sizing their deployments.


As the support for new platforms and data sources has evolved and matured in BI4 from 4.0 to 4.1, so has the sizing guidance. Introduced in May 2013, a new BI4 Sizing Guide was introduced that provided a more general methodology. Along with that came guidance for sizing related to more data sources including SAP BW and HANA. As always you should get the latest BI4 Sizing Guide from the BI Sizing microsite: www.sap.com/bisizing





I like to do live demos and I like to show off things you might not have seen. I saved some performance tips for the end of the session, where I showed two BI4.1 deployments running side-by-side: one with the Apache Split applied. That splits Web content delivery up, having Apache's Web server deliver the static BI4 Web content, leaving Tomcat to only have to deal with the dynamic BI content. It's a win-win-win for customers: less load on Tomcat, less wire traffic due to greater compression by Apache and a faster experience for end-users due to better caching and content aging.


New since TechEd there has been another round of updates to the BI4 Sizing Guide. Nothing major and no methodology changes - just updated details such as recommended maximum connections for WebI, CMS tuning and performance guidance for JDBC connectivity in Universes (which includes reporting on HANA).


Also new is a simplified description of the Apache Split procedure covering BI4.1 and the latest version of Apache.


As always, get all the latest stuff at www.sap.com/bisizing



Working with ASUG Headquarters, fellow ASUG volunteers, and some great SAP points of contact like Peter McNulty, I am excited to announce the ASUG Annual Pre-Conference sessions are back, and to quote ESPN's Mike & Mike - "we're back and better than ever".





Here are the details:

Where: Orlando, Florida

When: Monday, June 2nd


For a complete list visit ASUG Preconference Seminars


I hope you join us for this hands-on session:


SAP BusinessObjects BI 4.1, SAP BW, and SAP BW on HANA - All in One Day

SAP BusinessObjects Business Intelligence (BI) 4.1 is the latest suite release from SAP and offers a broad set of BI tools to choose from. Each tool has its own special focus in the area of reporting and analytics. This full-day, hands-on seminar is a series of activities focused on SAP BusinessObjects BI 4.1 products in combination with SAP BW, BW on HANA, and SAP ERP. Attendees will learn to use the different products from the SAP BusinessObjects BI suite 4.1 in combination with SAP data.



The session will provide you with hands-on experience for the following products:

Web Intelligence

SAP BusinessObjects Analysis, edition for Microsoft Office

SAP BusinessObjects Analysis, edition for OLAP

SAP BusinessObjects Design Studio

SAP Lumira Desktop and SAP Lumira Cloud

SAP Predictive Analysis

SAP BusinessObjects Mobile BI


ASUG has been offering this workshop and direct quotes from past workshops attendees are as follows:


"Great session, really a thorough view to the BOBJ solutions.   Ingo is great presenting information and bringing real life examples"

"Ingo is a rock star professional who knows all things BI"

"Cannot expect more from this day! It was just great!"

"Highly recommended"


If you follow SCN like I do, you know that there are several questions on the above products, and ASUG has assembled a team of experts to help you answer your questions, for a full day.


Could this be you, pictured below?


Photo from previous ASUG pre-con - by SAP photographer


Register today


See you there?

The ASUG BI community has prepared another great set of webinars.

Here is a list of upcoming webinars in the BI / DWH area for the next two weeks:

March 5: Patching Strategies and Best Practices for Updating BI4.X System

March 10: EIM for Procurement Excellence

March 11: Reporting Results: ASUG Analysis Influence Council

March 12: Case Study: SAP NetWeaver BW to SAP HANA Migration - Prepare Now and Migrate Quickly with Animal Health International

March 14: Desktop Intelligence Compatibility Pack: Best Practices, Recommendations in SAP BI 4.1



All of these webinars will be at 11:00 AM (CT), 12:00 PM (ET), 10:00 AM (MT), 9:00 AM (PT) and you can use the links for each of the webinars to register.


These are ASUG BI webinars, so you will have to be a ASUG member to register for them.

For regular updates on new webinars you can also follow us on twitter by follow these hash tags : #ASUGBI #SAPBIWebinar


Use these great opportunities to learn more about the upcoming products and to ask your questions directly to the product managers for these products.

.... and remember these are just the webinars for the next two weeks.... there will be more.

Some of you might already be aware that I am working together with the ASUG BI area on several topics, such as ASUG Influence Councils and ASUG webinars. As part of the "influence" for the SAP products we are currently looking for some input from the ASUG community on possible Focus Topics for the Customer Connection program. In case you are not familiar with the Customer Connection program, here a short description and a link for further details:



Customer Connection is a simple process directed at incrementally enhancing and improving the products and solutions our customers are using today. It offers SAP customers the opportunity to suggest small enhancements to products and solutions in mainstream maintenance, providing a fast and non-disruptive delivery via SAP notes and Support Packages. Customer Connection is structured along Focus Topics, which are suggested by SAP or the participating user groups.



As you can see the Customer Connection program is for small enhancements for products that are already available to our customers.

We created this short survey to gather suggestions from you - our customers - on those topics to see where we perhaps should create a new Focus Topic.

Please do no understand this survey as a guarantee for a new Focus Topic but instead the survey is there to gather the different topics of interest and based on the customer feedback we will decide on the next steps.

You can follow this link to fill the short survey:

ASUG BI SIG - Customer Connection Requirement Gathering Survey

Hopefully some of you already tried our existing SAP NetWeaver BW on SAP HANA with SAP BusinessObjects BI trial and had a great experience.


Our trial is now available for a little over 4 months and so far we have :


  • Over 1400 people that activated the 30 day trial
  • Over 150.000 hours of usage


In case you would like to hear from another customer, what they did with the BW on HANA Trial, take a look at David's experience here.


So why am I writing this today ?


Because I proudly announce the updated version of our SAP NetWeaver BW on SAP HANA with SAP BusinessObjects BI Trial.

Our trial now includes:


  • SAP NetWeaver BW 7.4 on SAP HANA SP07
  • SAP BusinessObjects BI 4.1
  • New eclipse based BW modelling
  • Updated exercises based on those new releases


In addition we also are making the 244 GB memory instances available for the BW on HANA part (Amazon AWS Instance : cr1.8xlarge).

So here is what you need:


  • Go and use it - simple as that.



Here some additional resources:



Please remember that the software is free of charge, but that you will be charged for the Amazon AWS hosting costs, which is around 4.50 USD per hour when the system is running.

As some of you are probably aware, I was part of the team that created the SAP NetWeaver BW on SAP HANA Trial that is available on the SAP HANA Marketplace (Link : App: SAP BW Powered by SAP HANA - Trial Offer | SAP HANA)


With this trial you have access to :

  • SAP NetWeaver BW 7.3 on SAP HANA SP06
  • SAP BusinessObjects BI 4.0
  • Integrated scenarios showcasing features of the above systems.


The trial was very successful so far and we have seen a large variety of use cases, from the need for a training system up to the requirement to have a fully configured system for a proof of concept.


Now it is 2014 and we are looking for a new "challenge" and we are looking at the option to create a similar experience for our customers and partners for Suite on SAP HANA.


And this is very you can help us:


     SAP Suite on HANA Trial (Public Survey)


Take this link and provide us with your input and feedback on a possible Suite on SAP HANA trial edition available as a cloud offering.


We will very carefully look at all the feedback and consider all your input and suggestions during the planning process of this new trial offering.

The ASUG BI community has prepared another great set of webinars.



Here is a list of upcoming webinars in the BI / DWH area for the next two weeks:


December 9: BI4.1 System Configuration Wizard


December 10: Rapid Database Migration of SAP NetWeaver BW to SAP HANA with Rapid Deployment Solutions


December 11: SAP HANA Security - What You Need to Know


December 12: What’s New in Information Steward 4.2 Service Pack 1


December 17: SAP BW - Performance Tuning & Housekeeping




All of these webinars will be at 11:00 AM (CT), 12:00 PM (ET), 10:00 AM (MT), 9:00 AM (PT) and you can use the links for each of the webinars to register.


These are ASUG BI webinars, so you will have to be a ASUG member to register for them.


Use the opportunity to learn more about the upcoming products and to ask your questions directly to the product managers for these products.

It is hard to believe but this is SAP Mentor Ingo Hilgefort's 11th book: Integrating SAP BusinessObjects BI with SAP NetWeaver (3rd Edition) - SAP PRESS Bookstore. - see New SAP Press Book - Integrating SAP BusinessObjects BI with SAP NetWeaver (3rd Edition)


This is the third edition of his first book, Integrating SAP Business Objects XI 3.1 BI Tools with SAP NetWeaver which was released back in 2009.  I recall back in 2009 how impressed I was with his step-by-step instructions and how he tells you what works and what doesn't work.  The same is true for this third edition.


The first edition of the book helped us integrate BusinessObjects XI 3.1 with SAP.  It was a tremendous help with Crystal authorizations with SAP ERP and the other tools.  The second edition of the book helped us upgrade to BI4.0 SP4.  The current book will help you continue this journey to BI4.1.  The second version is listed as a BI Pattern book.


This book is available now from SAP-Press and it covers BI4.1 with SAP BW and ERP.  It also covers newer products including Lumira and Design Studioingo1.


You can buy the book in electronic format or hardback format.  The first book had 258 pages.  This version has more than twice that at 545 pages.  It not only includes all the BI clients but also a chapter on integration with CTS and the NetWeaver portal.


Even if you are an expert in one BI client, I recommend this book to learn how to use all the other BI clients with SAP.  SAP BusinessObjects Analysis, edition for Microsoft Office, SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Analysis, edition for Microsoft Office along with Crystal, Web Intelligence, BusinessObjects Explorer are covered


He covers how to use BusinessObjects Explorer with SAP NetWeaver BW Powered by SAP HANA as well.  How do you create a Universe on top of ERP?  This is covered on page 196 of the book.  I memorized this from the previous version as this is how I learned this.


On SCN, everyday, there are questions about BICS connectivity, especially with SAP BusinessObjects Web Intelligence - I encourage those on SCN to check out the book.  Ingo has high standards for books, blogs, presentations and this book is no exception.  It was edited by the great Kelly Weaver


Related Information

On a non-SAP note, Ingo volunteers in his spare time for Critter Cares, a charity in Canada that works with mammals. This charity is one of the semi-finalists in a fund-raising campaign so if Ingo has helped you (as he has helped me on numerous occasions) please support Ingo and vote here.


Additionally Ingo his presenting at BI 2014 in March in Orlando > consider registering for this event.  On December 11th he is giving a BI4 / BW on HANA webcast which is open to everyone (EMEA friendly time) - register here.

Some of you might be aware that some time ago I created a Kindle eBook for SAP BusinessObjects Design Studio.


Why did I decide to publish my books directly as Kindle eBooks ?


Well, I personally stopped carrying around books as soon as I got my first iPad and the eBook format allows me to react much quick to any changes in the software and publish the updates out to everyone.


In addition there is the benefit of a much leaner and cheaper process, which also leads to a much cheaper price and I think that no one has a problem with that.



SAP BusinessObjects Design Studio 1.2 has been released just a few days ago and I updated my eBook to reflect the necessary changes:


  • I updated the existing chapters to reflect the necessary changes of the 1.2 release
  • I added a chapter to highlight "What's new in the release 1.2"
  • I added a chapter to outline the product roadmap for the release 1.3
  • ... and I added a new sample application as part of the "What's new in release 1.2" chapter to show that you can now use SAP BusinessObjects Design Studio 1.2 and basically create a complete Ad Hoc reporting environment.



In case you did purchase the book already, here the steps to get the updated content:


  • Navigate to "Manage my Kindle"
  • Find the book in your own Kindle Library
  • Click on "Update available" next to the book title
  • Follow the steps to update the book


Please note, that it might take 2 - 3 weeks until Amazon enables this, even though the book is already updated and new customers do receive already the updated content - sorry - not much an author can do about that time frame.



As next step I am going to include a chapter on the new available public SDK and will include some examples as well as a chapter on a plug-in from partner graphomate showing some very interesting charting components.

In all the previous posts (Part 1, Part 2, Part 3, Part 4, Part 5, Part 6, Part 7) we discussed how customers can leverage SAP HANA, SAP HANA Live, and SAP NetWeaver BW on SAP HANA in different options.


Now this blog post is about a customer that uses SAP ERP and non-SAP OLTP environments and is looking at SAP Technology to create a custom DWH.


To put it in slightly different words, this is a customer that has SAP and non-SAP applications and did not deploy SAP NetWeaver BW, but instead is looking to create a custom DWH. So what solutions can SAP offer for this customer and can SAP HANA be part of this?


In the previous blog posts we did already discuss the value of SAP HANA Live for customers that are interested in operational reports, by delivering pre-configured content in form of SAP HANA models and content for the SAP BusinessObjects BI suite. In our landscape #8 – even though the customer did not implement SAP NetWeaver BW – SAP HANA Live can still deliver value in form of predefined content for the SAP BusinessSuite. Before we now look into the options how such a custom DWH could look like, let’s take a look first at the two available solutions to create such a custom DWH.


For a custom DWH solution, SAP is offering SAP HANA and Sybase IQ.



Figure 1: EDW with SAP HANA


Looking at the overview shown in Figure 1 and Figure 2, which outline some of the key capabilities of SAP HANA and Sybase IQ as EDW solutions, there is one question that comes up – “What is the key difference between SAP HANA and Sybase IQ”.



Figure 2: EDW with Sybase IQ


Without going into too much details, here just some key differences between SAP HANA and Sybase IQ:




Sybase IQ

Key Technologies

Columnar database
In-Memory engine

Columnar database


Delivery Method


Installs on commodity hardware

Main Purpose

Agile Data Mart

Operational Data Mart

Applications based on SAP HANA

SAP NetWeaver BW on SAP HANA


Open EDW

Extreme large data volumes (petabyte scale)



In the previous posts we did already discuss the different options of creating a data mart on top of the SAP ERP or the non-SAP OLTP environment, so I won’t repeat those scenarios here. So that leaves us with the custom DWH scenarios based on SAP HANA and Sybase IQ.




Figure 3: EDW with SAP HANA


Figure 3 shows the option to create a custom DWH solution based on SAP HANA. Customers can use different ETL technologies, such as SAP BusinessObjects Data Services or SLT to load the data from the different source systems into SAP HANA. In this scenario customers can also use SAP HANA Live to benefit from the pre-configured content for operational reporting based on SAP BusinessSuite.



Figure 4: EDW with Sybase IQ


Figure 4 shows the same concept, but this time we use Sybase IQ to create the custom DWH and we do not leverage SAP HANA Live for the pre-configured content for the SAP BusinessSuite. As mentioned in Figure 1 and Figure 2, depending on the customer’s choice, topics such as data level security or the life cycle management of the data models will then be solved based on the available technology from SAP HANA or Sybase IQ.


Now a lot of readers might think that SAP HANA or Sybase IQ is a “one or the other” question, but that’s not true. In the same way as SAP HANA can take on different roles in combination with SAP NetWeaver BW, it can take on these roles in combination with Sybase IQ as well.




Figure 5: Sybase IQ and SAP HANA Combined


Figure 5 shows a scenario where the customer is using SAP HANA for operational reporting and data is loaded from the OLTP systems into SAP HANA – most likely even in real time. SAP HANA is storing the most up-to-date information and in this scenario Sybase IQ is being used to store the “aged” data. In other words, SAP HANA is used for the more critical and more valuable information (using the higher value storage medium) and Sybase IQ is used for aged information (using the lower value storage medium).




Figure 6: Sybase IQ and SAP HANA Combined


Figure 6 shows another scenario where a customer, who uses Sybase IQ for the EDW solution, leverages SAP HANA as an environment for agile data marts. The information from the OLTP environments is loaded into Sybase IQ and data is loaded into SAP HANA to support specific agile requirements in form of data marts loaded with information from Sybase IQ.



This finishes the series on the different scenarios for SAP HANA, SAP HANA Live, and SAP NetWeaver BW on SAP HANA. I hope people see value in the material and I hope I was able to "show some light at the end of the tunnel".


... and remember, in case you would like to experience SAP BW on SAP HANA with SAP BusinessObjects BI yourself, you can leverage a 30 day trial.

In the previous parts (Part 1, Part 2, Part 3, Part 4, Part 5) we focused mainly on customers either without a complete DWH or with a custom DWH solution ( Part 5). In Part 6 we looked at customers that are using SAP NetWeaver BW without SAP HANA and in this part we will look at customer that are using SAP NetWeaver BW on SAP HANA.




Figure 1



In our scenario we are looking at a customer that has a heterogeneous landscape, with parts being based on SAP systems such as SAP ERP or SAP CRM, parts being based on non-SAP, and parts being based on standard relational databases.


In our scenario the customer made the choice to implement SAP NetWeaver BW on SAP HANA as EDW.




Figure 2


In Figure 2 you can see a scenario where the customer would use SAP NetWeaver BW on SAP HANA as EDW, but without fully leveraging all the capabilities SAP BW on SAP HANA is offering. In this option the customer is just replacing the database from SAP BW with SAP HANA and does not leverage any of the new options - such as a mixed scenario.



Figure 3


Figure 3 shows the first option how customers could leverage some of the new capabilities with SAP NetWeaver BW on SAP HANA. In this scenario the customer not only loads the data from the source systems into SAP NetWeaver BW but instead also replicates the data from the SAP ERP system into a SAP HANA managed schema.

In the situation where the customer is using SAP NetWeaver BW on SAP HANA, there are tables in SAP HANA managed by SAP BW and you can also have tables managed by SAP HANA (using SAP HANA Studio) - as shown in Figure 3. In our example the customer replicates the data from SAP ERP in real-time to the SAP HANA system. In addition the customer is also loading unstructured information - such as Twitter feeds - into SAP HANA directly.


With the data now in SAP HANA the customer can generate a Transient Provider in SAP BW on top of the SAP HANA Analytical models and then leverage the Composite Provider capabilities and combine for example data from SAP NetWeaver BW with the information in SAP HANA without having to load the data from SAP HANA into SAP NetWeaver BW.



Figure 4


Figure 4 shows another example how customers can leverage the new options with SAP NetWeaver BW on SAP HANA. In our next example (Figure 4) the customer is using SAP NetWeaver BW on SAP HANA like before and also replicates the information from SAP ERP into a separate schema in SAP HANA.

In this example all the unstructured information is already stored in HADOOP and the customer is not planning on moving the data from HADOOP into SAP HANA - and he does not have to do so. With Smart Data Access from SAP HANA the customer can then point to the information in HADOOP and - as pointed out in Figure 3 - then leverage the information and combine the data with data in SAP BW.



Figure 5


In Figure 3 and 4 we have seen options to create a Transient Provider based on the model in SAP HANA and then to combine the data from SAP NetWeaver BW with the information in SAP HANA - a so called "mixed scenario". Figure 5 now shows another option where our customer is generating a SAP HANA model based on information that was modeled in SAP BW. With SAP NetWeaver BW on SAP HANA customers can also leverage existing assets - such as a BEx Query or a InfoProvider - and generate an SAP HANA analytical model, which then can be accessed directly by connecting to SAP HANA.


A good example for this scenario is the usage of SAP Lumira, SAP BusinessObjects Explorer, or SAP Predictive Analysis in combination with data from SAP NetWeaver BW. In such a use case - knowing that these three BI clients can not connect to a BEx query directly - customers could use the integration of SAP NetWeaver BW on SAP HANA and generate the model in SAP HANA and connect the BI clients to the generated model.



Figure 6


So how about SAP NetWeaver BW on SAP HANA and SAP HANA Live ?


Figure 6 shows such a scenario. In our last example the customer is running SAP BusinessSuite on RDBMS (not on SAP HANA) in combination with SAP NetWeaver BW on SAP HANA. As mentioned previously we have two sets of schema in the SAP HANA system - one set of tables managed by SAP NetWeaver BW and one set managed by SAP HANA.


Our customer is also using SAP HANA Live as pre-configured content for operational reporting and those models are part of the SAP HANA manged content.


Our customer is loading the information from the SAP BusinessSuite into SAP NetWeaver BW - like in the prior scenarios - but is also using real-time replication to load the data from the OLTP environment into SAP HANA and uses then the pre-configured models from SAP HANA Live for operational reporting.



I hope people find this information useful and that this content helps to clarify some of the possible scenarios that are available with SAP HANA, SAP HANA Live, and SAP NetWeaver BW on SAP HANA.


In the next post we are looking at customer landscape #8, where a customer uses OLTP environments based on SAP technology and a custom DWH based on SAP products.


Filter Blog

By author:
By date:
By tag: