Friday, May 26, 2017

SAP Convergence Strategy - BOC

The April 20, 2017, SAPinsider Q&A focused on the SAP BI Convergence Strategy.

So far, I've published posts on the convergence strategy itself, and on what's new in SAP BusinessObjects BI 4.2 SP4, and the merger of Lumira and Design Studio.and SAP Web Intelligence. The SAP BusinessObjects Cloud was also a subject of discussion.

SAP's Henry Kam took the lead in the discussion:

Organizations recognize that SAP BusinessObjects Cloud offers a unique value proposition in the market today by combining analytics, planning, and predictive capabilities. These 3 capabilities are not just available under a shared application user interface, but the key is that these functionalities are actually integrated seamlessly together in user workflows. Also resonating with customers is the SAP Digital Boardroom, which is a capability of SAP BusinessObjects Cloud. It provides users with a 360-degree view of their company’s performance in real time, using BOC which is a Cloud SaaS product, with the ability to securely access on-premise data, and displaying analytics on multiple large TV screens that are touch enabled.

Henry went on to discuss how organizations with on-premise deployments should be viewing the move to the Cloud:

We believe in taking a hybrid BI approach. Hybrid BI provides a seamless experience across both on-premise and cloud. When you access content or blend data from on-premise or cloud systems, you are doing hybrid BI. A seamless experience means that business users do not have to think about where data or content is residing; on-premise and cloud clients and assets work together. Sharing resources between on-premise and cloud deployments such as tools, data connectivity, visualizations, security, distribution, budget, organization, program management, training, licensing, and internal evangelization, does not require understanding whether the resources are on-premise or cloud. The journey many times starts with on-premise deployments, which must be extended and expanded into complementary cloud strategies with minimal disruption. One way we are realizing this vision is our planned innovation of providing a new experience which will consolidate access to analytics content from multiple hybrid (on-premise or cloud) systems into a unified experience. Keep an eye out for the analytics announcements at SAPPHIRE as we’ll be unveiling this new solution.

APOS realizes that data connectivity will be one of the most pressing matters for organizations wishing to take advantage of SAP BusinessObjects Cloud, which is why we develop the APOS Data Gateway for SAP BusinessObjects. Allan Pym described this APOS offering during the Q&A:

The APOS Data Gateway for BOC will allow for live data access to on premise UNV and UNX universes, as well as SAP BW (v 7.3 and higher), MSAS, Essbase (Q3) and relational datasources (mid Q2). APOS also has a connector that will enable acquiring data from UNV universes.

Note: The APOS Data Gateway connector for relational data sources has now been released.

You can find more about the SAP BusinessObjects Cloud roadmap in the Q&A transcript, which you can access from the APOS On-Demand Webinars page:



A future post will look at what's new in Analysis for Office.

Thursday, May 11, 2017

SAP Convergence Strategy - Web Intelligence

The April 20, 2017, SAPinsider Q&A focused on the SAP BI Convergence Strategy.

So far, I've published posts on the convergence strategy itself, and on what's new in SAP BusinessObjects BI 4.2 SP4, and the merger of Lumira and Design Studio. Let's turn our attention to SAP Web Intelligence.

During this year's Q&A, Gregory Botticchio told us that the Web Intelligence team had delivered approximately "50 innovations and cumulative enhancements." The top 6 most popular, according to Gregory:
  • Parallel refresh of WebI data providers, for all datasources
  • Commentary: add a comment in a report and in a table cell
  • Shared Element: share and reuse blocks (table, carts) between users
  • New SAP HANA access mode (direct access and OnLine)
  • dHTML catchup vs the Java applet
  • Dynamic, or Cascading, Input Controls

Coming in SP4 are improvements to the Web Intelligence dHTML client, new chart types and cumulative enhancements, but the biggest news in SP4 is a new Web Intelligence interface:

…we will mainly deliver a new, modern and elegant, SAP BusinessObjects Web Intelligence experience. It will be an interface build in HTML5, using some SAP Fiori UI5 elements. And it will be mostly an interactive viewer that you will have the choice to use in parallel of the existing one.

Gregory also gave us some details on the road ahead for Web Intelligence:

In the mid/long-term: We are planning a new simplified and modernized WebI Designer, to complete the story. Also we are thinking of changing the way to create reports by proposing Suggestions and Recommendations. Interactive Analysis for the end-users will also be key in this future release.

You can find more about the Web Intelligence roadmap in the Q&A transcript, which you can access from the APOS On-Demand Webinars page:



Future posts will look at what's new in Analysis for Office and SAP BusinessObjects Cloud.

Friday, May 5, 2017

SAP Convergence Strategy - Merging Lumira & Design Studio

The April 20, 2017, SAPinsider Q&A focused on the SAP BI Convergence Strategy, and nowhere is that convergence more apparent than in the merger of SAP Lumira and SAP Design Studio.
So far, I've published posts on the convergence strategy itself, and on what's new in SAP BusinessObjects BI 4.2 SP4.

The coming release of Lumira 2.0 will unite the Lumira and Design Studio code base in recognition of the fact, as David Stocker put it during the Q&A, that " the use cases of an agile viz tool and a custom app actually overlap in the wild." The merger of these two solutions is meant to simplify the workflow from business users to designers.

The backend convergence will facilitate such workflows, while the maintenance of separate client applications will preserve and improve usability for the business user and the designer. Blair Wheadon described the SAP vision:

Lumira 2.0 has major improvements in usability, data access, and is converged with SAP BusinessObjects Design Studio to enable the creation of sophisticated analytic applications… Data access: Key new features include online access to BW from Lumira Discovery 2.0 (the successor to Lumira Desktop) and improved access to Universe data in Lumira Designer 2.0 (the successor to Design Studio desktop 1.x) which removes the row limit for Universe access. This will ensure direct access to governed data and remove the need to create data extracts and ungoverned data silos. In addition to data access, the usability of Lumira Discovery is much improved with a single canvas UX, improved filtering and input controls, new chart features like smoothed lines and improved formatting control. Finally the ability to open a Lumira Discovery visualization with Lumira Designer and turn it into a full blown analytic application is very powerful. This means that any dashboard from the simplest visualization up to full-blown planning applications can be handled by the same tool. As requirements change, you don't need to switch tools.

The combination of Lumira Discovery 2.0 (formerly Lumira Desktop) and Lumira Designer (formerly Design Studio Desktop) will enable seamless collaboration between business users and designers to create custom dashboards and analytic applications from business user visualizations.

You can make this collaboration even more effective by expanding your data connectivity options. The APOS Data Gateway solution is designed to help you do just that. The APOS Data Gateway is a data connection and data transformation solution which provides extended data source and data volume options for SAP Lumira and SAP Design Studio. It also enables enhanced interoperability with BI components across the SAP landscape.

You can find more about the Lumira / Design Studio convergence in the Q&A transcript, which you can access from the APOS On-Demand Webinars page:



Future posts will look at what's new in Web Intelligence, Analysis for Office, and SAP BusinessObjects Cloud.

Wednesday, May 3, 2017

SAP Convergence Strategy - Highlights from the April 20, 2017, SAPinsider Q&A

As usual, this year's SAP Convergence Update event, brought to you by SAPinsider and APOS, covered a wide range of topics. While nominally about convergence, the conversation naturally turned to many of the individual SAP BI solutions, and how they are affected by the SAP Convergence Strategy.

The discussion concerning the SAP Convergence Strategy itself can be found here:


For your convenience, I'll break down some of the more salient topics discussed at the event here on the Well Managed BI blog. Today, I'll focus on the discussion on Service Pack 4 for SAP BusinessObjects.

During the Q&A event, SAP's Merlijn Ekkel told us:

Within SAP BusinessObjects BI 4.2 SP04, we release the initial version of our fully revamped BI Launchpad and Web Intelligence Viewer, where end users will gain the ability to leverage the new and fresh UI for BI with great experience. Besides these, many smaller enhancements have been added.

He also announced that the SAP BusinessObjects BI Platform 4.2 SP04 What's New presentation deck had been published only a couple of hours earlier.


More good news: According to Merlijn, SP4 marks the beginning of a major overhaul of the BI Launchpad, including "a revamp of the scheduling and publications process."


You can access the complete transcript from the APOS On-Demand Webinars page.

Thursday, April 27, 2017

SAPinsider SAP BI Convergence Q&A Transcript

The APOS-sponsored SAPinsider Q&A - SAP BI Product Convergence Update transcript is now available for you to view at:


This SAPinsider Q&A featured many SAP BI luminaries, including Jayne Landry, Merlijn Ekkel, Blair Wheadon and Ty Miller offering insights on the future path of the SAP BI ecosphere.

Friday, April 21, 2017

SAPinsider Q&A Highlights - SAP BI Convergence Update

APOS was proud once again, for the third consecutive year, to provide an opportunity to interact with some of SAP’s leading BI lights on the subject of SAP BI convergence. We don’t yet have an official transcript of yesterday’s SAPinsider Q&A - SAP BI Product Convergence Update: What’s Happening Today, What Is Coming Next, and What Does It Mean for You?, but here are some highlights.

By the way, when the transcript for the Q&A becomes available, we will post a link on our APOS On-Demand Webinars page, where you can also view a large number of past webinars on topics you may be interested in, such as:
  • Automated Report Testing
  • UNX Universe Adoption Testing
  • Semantic Layer Update with SAP’s Pierpaolo Vezzosi
  • SAP BusinessObjects Advanced Monitoring

...and much more.

This Q&A session was billed as a chance to:

…interact directly with Jayne Landry, Merlijn Ekkel, Blair Wheadon, Ty Miller, and several other key product leaders from BI product groups at SAP, including SAP BusinessObjects Web Intelligence, SAP BusinessObjects Lumira, SAP BusinessObjects Design Studio, and SAP BusinessObjects Analysis for Office. Here's your chance to take a look at the road ahead for SAP’s BI products, assess your opportunities, and seek clarifications to questions

It lived up to this billing quite nicely.

APOS COO Allan Pym started the session off asking Jayne Landry (Global Vice President & General Manager, Business Intelligence, SAP) about the progress of the SAP BI convergence initiative. Jayne responded:

We have made tremendous progress on the convergence front. When we started this journey 3 years ago we had 14 different client tools running on the BI platform! We’ve now got that down to 5, with Crystal, Webi, Analysis Office, Design Studio and Lumira... And we’ve adhered to the convergence principles we laid out from the start – all existing content is safe and all existing BI 4.x clients continue to be supported so that customers can move to the “go to” tools at their own pace.

Jayne continued with a description of upcoming convergence advancements:

The next big advancement is the convergence of Lumira and Design Studio into a single code line with the release of Lumira 2.0, currently in beta and planned for GA late Q2/early Q3. This will enable end-to-end workflows from rapid prototyping by business users through to deployment of production dashboards at scale by developers.

You’ll have to wait for the official transcript for more, but I can tell you that it will contain substantial content on a number of subjects of interest, including:
  • The Design Studio / Lumira convergence
  • SAP BusinessObjects Cloud
  • New Analytics announcements to be made at SAPPHIRE
  • Web Intelligence improvements
  • New features in SAP BusinessObjects BI 4.2 SP 4


Bookmark the APOS On-Demand Webinars page and check back over the coming days for a link to the official transcript.

Wednesday, February 22, 2017

Update: SAP BusinessObjects Semantic Layer Webinar

SAP's Pierpaolo Vezzosi joined us on February 16, 2017, to talk about what's new in the SAP BusinessObjects semantic layer. Back on February 2, it was SAP's Gregory Botticchio who joined us to talk about what's new in Web Intelligence. Taken together, these webinars give us a great view of the current and future states of the SAP BusinessObjects platform.

Pierpaolo's presentation featured a wealth of information, especially for people working with HANA and BW. He spoke specifically about:
  •  Linked Universes
  • Universes on BEx query
  • HANA

Below, I provide a fairly detailed look at the topics discussed, but it would definitely be worth your while to view the webinar on demand, as Pierpaolo provides live demonstrations on all of these topics, as well as a lively Q & A at the end.

Direct & Online Access to HANA

SP3 saw the addition of Direct access and Online access as methods to access HANA, allowing Web Intelligence reports to access HANA data without the need to build a universe between them, with best practices enabled.

Pierpaolo provided live demonstrations of Direct and Online access to HANA from Web Intelligence using the newer DHTML interface, because, as he reiterated, this is where most new development will occur, due to the impending deprecation of Java applets.

He discussed a number of access methods in detail, and when to use them:
  • HANA online - best for exploration. It is fast and best practices are enabled by default. By default, you can return only 5,000 rows, but the user can override this default. However, "good" reports in Web Intelligence don't return this many rows. The big constraint with online is that all calculations and filtering are pushed back to the HANA system, which means that some complex Web Intelligence calculation are not available in this mode.
  • HANA direct on relational sources - has all the functionality of Web Intelligence, including the complex calculations not available in online mode, and the best performance / cost ratio for reporting. The recommendation is that you start the design process in online mode to discover the data and the shape of the data, then move to HANA direct mode to make all Web Intelligence functionality available.
  • HANA direct on OLAP sources - if you need hierarchies. OLAP on HANA direct may be marginally slower, so if you don't need hierarchies, stick with HANA direct relational mode.
  •  HANA via a universe - if you need to customize your access to HANA. For example, if you want to rename objects and do not have write access to HANA views, you can use a universe to make access more friendly, or if you want to add a layer of security on top of HANA, but in general, SAP does not recommend using universes for HANA access. The default should be to use HANA views.

Authoring UNX Universes on BEx Queries

You can author a UNX universe on a BEx query as a means of improving user adoption. Users have welcomed the ability to access BW directly with Web Intelligence, but many have found BEx queries to be not business-user-friendly. Building a UNX universe on a BEx query simplifies the view of the BEx query for business users. Pierpaolo provides a detailed demonstration on how to author such universes.

Linked Universes

When linked universes were introduced in SAP BusinessObjects XI, their purpose was to make complex universe projects easier to manage. This idea returns in BI 4.2 SP3: You can construct UNX universes and allow objects in those universes to be inherited by a newer universe. Further, when you make changes to the original (or master) universes, the changes are propagated down to the derived universe.

Linked universes allow you to:
  • Deliver a modular approach to universe building in the Information Design Tool (IDT)
  • Insert the objects of a master UNX into a derived UNX universe, with automatic updates propagation to the derived universe

Use cases for this linked universes include:
  • Component Use Case- using a team approach in which each team supplies one or more components for the derived universe (e.g., customers, products, measures)
  • Kernel Use Case - building a large data foundation (e.g., the whole data warehouse) in the original universe, then showing subsets of that universe in derived universes (e.g., for Marketing, HR)
  • OEM Use Case - building a common universe, which is then extended in derived universes for various customers

Again, Pierpaolo provided a detailed demonstration on linking universes, and it is definitely worth your while to view the webinar on demand for these demonstations.

APOS Migrator for Web Intelligence

Allan Pym, APOS COO, also gave a brief description of the APOS Migrator for Web Intelligence, which enables:
  • Bulk conversion of universes from UNV format to UNX format
  • High-volume re-pointing of Web Intelligence reports from the old UNV to the new UNX

Wednesday, February 15, 2017

Update: SAP BusinessObjects BI 4.2 Semantic Layer

APOS is hosting another SAP update webinar on Thursday, February 16, at 11 am EST. This time, it will be SAP's Pierpaolo Vezzosi updating us on developments in the BI 4.2 semantic layer.

The semantic layer has always been one of the features that sets SAP BusinessObjects apart within the increasingly crowded BI space. Universes greatly simplify access to data by providing consistent, business-logic-friendly naming conventions across the enterprise data landscape.

The centrality of the semantic layer meant that it needed to be tweaked regularly to keep up with new BI requirements and technological developments, but there is only so much tweaking that a technology can take before it begins to become unwieldy. By the time SAP began to design BI 4, the semantic layer was perceived by some to be approaching those limits, and SAP undertook the task of redesigning the semantic layer from the ground up.

The new semantic layer was designed to support a clear vision of the future of SAP BusinessObjects, and new developments continue to build toward that vision. In our upcoming webinar, Pierpaolo will discuss progress toward that vision, and the road ahead.

Join us to catch a glimpse of the future.

Tuesday, February 7, 2017

SAP Web Intelligence Update Webinar Summary

Groundhog Day 2017 was not particularly informative concerning the length of our Winter here in Canada. A recent study determined that the rodents have been right only 37% of the time over the past several decades, which isn't even randomly inaccurate.

However, Groundhog Day did bring us a wealth of information from Gregory Botticchio in the form of a webinar that highlighted advances in SAP Web Intelligence and the road ahead.

Gregory told us about WebI themes if BI 4.2:
  • Building a Trusted Foundation - removing upgrade barriers with Linked Universes, and client improvements with Parallel Queries
  • Enabling the Business - collaboration through Commentary and Shared Elements, client improvements through GeoMaps and Big Numbers, and unleashing the ecosystem through Visualization Extensions
  • Leveraging the SAP Backend - SAP BW improvements with BEx-Authored Universes, and SAP HANA Enhancements with HANA Direct Access and HANA Online
These features were delivered in SP2, and enhanced in SP3 with:
  • dHTML Catchup - striving to achieve parity with the Web Intelligence Java Applet (an ongoing project)
  • Dynamic Input Controls - more than just cascading controls
  • Sets - authoring sets in the Infromation Design Tool, using them to query data, and consuming them through universes
  • Referenced Cells - using variables that return the value of a specified cell, maintaining the context of that cell, and listing referenced cells as Available Objects
  • Commentary - improved usability and lifecycle; performance optimization
  • Parallel Data Provider - parallel query support on BEx queries

When SP4 arrives later this year, it will launch a whole new set of Web Intelligence features that will improve Web Intelligence functionality and render the user experience more consistent with other SAP BusinessObjects solutions. 

SP 4 is scheduled to include:
  • A New Viewer
  • More dHTML Catchup
  • New Chart Technology
  • An SDK & Extensions

Click the link below to view the webinar on demand and listen to Gregory Botticchio, BI Product Manager, SAP, give us the lowdown on what's up next for SAP Web Intelligence

Wednesday, February 1, 2017

Update: SAP Web Intelligence

Happy Groundhog Day!

Has it really been a year since APOS last hosted an SAP Web Intelligence Update webinar?

Yes it has.

Between then and now, SAP BusinessObjects BI 4.2 SP3 was released, bringing many of the features promised in that webinar to life, including:

  • Java/DHTML Clients Parity
  • Cascading Input Control
  • Shared Elements
  • Comments
  • Parallel Queries

When SP4 arrives later this year, it will launch a whole new set of Web Intelligence features that will improve Web Intelligence functionality and render the user experience more consistent with other SAP BusinessObjects solutions.

History, as Mark Twain famously said, does not repeat itself, but it does rhyme, and we will soon have SAP's Gregory Botticchio, BI Product Manager, SAP, rhyming off what's new with WebI, as APOS hosts a new SAP Web Intelligence Update webinar. Sign up and listen to Gregory on Thursday, February 2 (Groundhog Day in the US and Canada), as he gives us the lowdown on what's up next for SAP Web Intelligence.

Register for this webinar...

APOS Administrator Users - Did You Know?

Did you know that you can now perform a search in Instance Manager for inactive instances in SAP BusinessObjects BI 4.x?

This search requires that you also have APOS Insight, as the search is based on integration between these two solutions.

Good news: If you don't have APOS Insight, you can download the free APOS Insight Elements package and use it with Instance Manager to perform these searches.

You'll find APOS Insight Elements for other tasks as well. It will allow you to:

  • Inventory all objects, including report objects, user group objects, folders, categories, and business view objects
  • Use object data to compare historical folder/object structures from different points in time
  • Inventory all report schedules within the system
  • Use schedule data to determine peak server usage as a step toward optimizing server performance
  • Inventory all report instances within the system
  • Use instance data to determine report usage patterns and know which reports are used the most, and which are rarely used
  • Look at the processing activity for a particular time and day and compare that processing activity with other times and days to form a picture of bursts, if they exist, and to reduce processing bottlenecks
  • Use inventories and analysis to initiate a systematic clean-up of your BI deployment to plan for migration, safeguard the health of your system, and prepare for growth.

Download APOS Insight Elements.

Monday, January 16, 2017

Webinar - Advanced Monitoring for SAP BusinessObjects

Gone are the days when BI monitoring consisted of irate information consumers calling to complain about the report they didn't receive. BI has become central to 21st Century enterprises, and BI monitoring strategies are evolving accordingly. The role of monitoring has increased, and will continue to increase, as BI becomes more central to informed management and operations, and to the financial well being of your organization.

An advanced monitoring strategy should provide you with the means to gauge the whole system health of your BI deployment, because it is no longer enough to know whether all servers are "dead or alive" and online, whether jobs have succeeded or failed, and whether critical services are running. There is so much more that you can know about your system from advanced monitoring methods, and so many ways in which advanced monitoring can make your proactive in delivering the best possible service to your information consumers.

Advanced monitoring techniques offer both a broader view of your deployment, covering a wide range of components and dependencies, and a more granular view, allowing you to act with confidence on the monitoring data you gather, and giving you a much better better picture of your system's health.

If advanced monitoring for SAP BusinessObjects is on your radar, join us to learn about developing a comprehensive and proactive monitoring strategy for your BI deployment.

What: Webinar - SAP BusinessObjects Advanced Monitoring
When: Thursday, January 19, 2017, 10 am / 2 pm EST