Skip navigation
1 2 3 Previous Next

Business Intelligence

82 posts

Register now for Modeling Time Dimensions in SAP BW/4HANA


Modeling time dimensions in SAP BW/4HANA


Jüergen Haupt, SAP

Date:  Thursday, June 21,  2018

Time:  8:00 a.m. PT | 11: 00 AM Eastern

Duration: 60 minutes

Register now for SAP Analytics Cloud introduction with a focus on planning capabilities


Discover how SAP Analytics Cloud brings together an end-to-end Business Intelligence and Predictive platform, while redefining Planning in the Cloud. Whether you are a Corporate Controller, or responsible for a Line of Business, across every industry, SAP Analytics Cloud provides all the options and flexibility for a quick and successful implementation, for both SAP and non-SAP customers


Damien Fribourg, SAP

Date:  Wednesday, June 20,  2018

Time:  8:00 a.m. PT | 11: 00 AM Eastern

Duration: 60 minutes

Register now for SAP Hybrid Analytics


Whether you are accessing content or blending data from on-premise or cloud, hybrid analytics should provide a seamless experience. This webinar will explore SAP's approach to hybrid analytics and give you a solid understanding around the following topics:

  • Market forces forces for analytics and how hybrid scenarios can be leveraged to support them
  • SAP's analytics strategy and SAP solutions for hybrid analytics, including use cases
  • SAP Analytics Hub


Adrian Westmoreland, SAP

Date:  Thursday, June 14,  2018

Time:  8:00 a.m. PT | 11: 00 AM Eastern

Duration: 60 minutes

Register now for BI: Analysis Office 2.7


Learn what's new in SAP Analysis Office 2.7


Alexander Peter, SAP

Date:  Wednesday, June 13,  2018

Time:  8:00 a.m. PT | 11: 00 AM Eastern

Duration: 60 minutes

Register now for What's New in SAP Lumira 2.2


Learn what's new in SAP Lumira 2.2


David Stocker, SAP

Ashutosh Rastogi, SAP

Date:  Tuesday, June 12,  2018

Time:  9:00 a.m. PT | Noon pm Eastern

Duration: 60 minutes

Don't miss the opportunity to influence through SAP Customer Engagement Initiative cycle 2.  Registration closes on June 15, 2018.  See details in the initial posting.


Source: SAP

On behalf of our SAP Point of Contact Neil Goodman

askSAP Analytics Innovations Community Call:
SAP 2018 Become an Intelligent Enterprise with SAP Analytics for SAP S/4HANA

Please join SAP on June 28 for the second #askSAP Analytics Innovations Community Call of 2018.



New digital technologies allow companies to make core business processes more intelligent. Companies can automate business processes and augment employee's capabilities to let them do more than they could do before with more focus on strategic tasks based on real-time and forward-looking insights. This shift is accelerating in every industry and compelling every organization to transform into an intelligent enterprise to nimbly adapt to new market realities. SAP S/4HANA is the digital core platform to become such an intelligent enterprise. This digital transformation is driving the need for more analytics and a big opportunity which occurs through this transformation is to give all employees, partners and customers, immediate and forward-looking insights into what is going on and what is going to happen next. Join us on June 28 to hear from our panel of experts and users how SAP Analytics help SAP S/4HANA customers seize this opportunity to drive strategic initiatives across the entire organization.


During this live call you will:

  • Hear about the current challenges and strategic trends driving the intelligent enterprise
  • Understand how SAP Analytics fits into a SAP S/4HANA landscape to enable the intelligent enterprise
  • Discover the key use cases and benefits you can achieve when running SAP Analytics with SAP S/4HANA
  • Hear first-hand from SAP customer Northern Gas Networks how they leverage SAP Analytics in combination with SAP S/4HANA to run the business in real-time
  • Have plenty of opportunities to ask questions through live chat or twitter
  • Speaker 1: Ido Shamgar, Sr Director, Global Product Marketing SAP S/4HANA & SAPS/4HANA Cloud, SAP
  • Speaker 2: Tom Chelednik, Global Business Development Executive, SAP
  • Speaker 3: Christian Blumhoff, Senior Director Global Center of Excellence for Analytics, SAP
  • Speaker 4: Tom Pollock, Head of Smart Information Management, Northern Gas Networks
  • Speaker 5: Kevin McConnell, Machine Learning Solutions, Leonardo & Analytics Global CoE, SAP


Moderated by SAP Mentor Owen Pettiford.


Don’t miss this informative, interactive event on June 28. Submit your questions in advance via the registration form or via Twitter with #askSAP.


This is a new SAP Press book over 750 pages long!  It takes some time to read.   You can browse a preview here.  You can also review a report on the new SAP Press Lumira Discovery book here.


Speaking for myself, I recommend buying a hard-copy of the book.  It is far more technical than Lumira Discovery, and for me it was easier to consume in hard back.  The book covers end to end Lumira Designer, including IBCS principles, visualization best practices, planning, SDK, mobile and more.


Where possible, I encourage you to have the book open along with Lumira Designer and follow along.  Ideally please use Lumira Designer 2.1 when starting the book.


If you are new to Lumira Designer or Design Studio, this book is a good start for you.  Since the book is a good size, you may want to take your time in reviewing it as I did.





First, I followed along with some of the book, using sample data from a sandbox:


This is a sample of the basic layout, and I have total hours calculated in the title.


The book also draws attention to features I hadn't considered:


Source: SAP Press

You can send your application BI platform version to a mobile device.


I also played with the modified click through from graph to cross tab:

modified click through.jpg

I used the NetWeaver demo data source

var currentMembers = CHART_1.getSelectedMembers("0D_NW_REGIO");



if (currentMembers.length > 0) {

DS_1.setFilter("0D_NW_REGIO", currentMembers);




I also followed along with the tabstrip button navigation:

var tabnumber=TABSTRIP_1.getSelectedTabIndex();

if (tabnumber==4)



} else{

TABSTRIP_1.setSelectedTabIndex(tabnumber +1);



There is a chapter on CSS guidelines (must read) and chapters on performance.  I did skip the planning and SDK chapters, as I am not using that functionality.


There are chapters on building a sales application and KPI application that you can follow step-by-step.  So this is a nice complementary offering to the free Open SAP course on Lumira.  You can also.  The book also comes with application samples from BW on HANA.  The appendix is fun, as it covers little-know features such as the "Math Component".


I encourage you to check it out.  ASUG members receive a discount, learn more here


Please join ASUG for this upcoming related webcast:

And, join us June 4 for Jump Start ASUG Annual Conference 2018 SAPPHIRENOW with SAP Analytics Cloud/ Lumira Designer Session

See 2018 ASUG Annual Conference BI Brochure


As a valued member of the BI community, we wanted to let you know of some upcoming webinars that may be of interest to you! In addition to providing insights from the SAP's most respected voices on the most relevant and important topics today, these webinars also help you earn CPE's/PDU's depending on your area of certification.


Keep in mind you can always watch the archived webinars later—and we offer an extensive library of on-demand webinars you can also explore here: ASUG BI Webcast Recording/Slides Reference List for 2018


More upcoming webcasts can be found Upcoming ASUG Business Intelligence Community Webcasts



Lead cloud, innovate core

Support interop and hybrid scenarios




Analytics Hub is a catalog


SAC - premier analytics self service platform


Right side is on premise deployment


Source: SAP

Lumira Discovery innovations for 2019 will be minimal; SAP investment on SAC


Source: SAP

The positioning of the products is shown above


Source: SAP

Lumira 2.2 is planned for August this year; features are shown above

Variants will be supported


Demo of Lumira Designer 2.2


BW variants


Variants can be public or private


Runtime calculations


Calculation editor

2.2 - charts can show over 10K datapoints


Source: SAP

2.2 and 2.3 is shown above



source: SAP


Source: SAP


Source: SAP


Fiori look and feel for SAC


Source: SAP

Q4/2018+ marketecture


Source: SAP


Live and imported data connectivity


Source: SAP


enhancements to connect to BW (BEx conditions)

Universe - native query builder within SAC


Source: SAP

Expand data sources (SAPPHIRENOW announcements)?



Source: SAP

card view


Source: SAP

Build more data viz/semantics


Source: SAP


Look for it at SAPPHIRNOW

apps of analytic content

centrally governable

Authoring and consumption in browser


Source: SAP

Actions to script flow


Source: SAP

Citizen data scientist - predict and train models and manage in SAC


Source: SAP

Iniitally work on import


Source: SAP

Smart assist - do the thinking for you

Conversational analytics - search to insight


Source: SAP

integration with applications and with each other - heart of the "intelligence enterprise"


Source: SAP


Free available on tenants


Source: SAP

By quarter, aggressively expanding updates


Source: SAP


Source: SAP

Connect to on premise


Source: SAP

Immerse in your data, touch multi screen

Cisco - new Cisco WebEx board at SAPPHIRENOW, MS Surface Hub


Source: SAP

focuses on live connectivity with BW

Mobile is not a different product, but an end-to-end, native touch gestures


Source: SAP

Leverage existing investments; native BW query concepts


Source: SAP

Free content provided as part of SAC


Source: SAP

Marketecture slide showing SAP Analytics Cloud as a SaaS platform

Live connections cover BI area

Top right - application building capabilities; today many have on-premise Lumira Designer - app building is planned for SAC - it is a roadmap item in Q3


Source: SAP

Today have 2 different ways to talk to BW queries

First one is the live connection; many advantages - no additional modeling

No data replication with live connection

Generate HANA views from BW queries


Data Import use case is supported; may want to run report on a monthly basis or the data seldom changes - set up a schedule


Source: SAP

Recent innovations focus on core BW connections


Source: SAP

BW Variants supported, consumptive only

In future roadmap, create variants


Source: SAP

Respect query layout settings as shown above


Source: SAP

Create KPIs without relying on IT

Delegated to BW system


Source: SAP

Harmonize metadata - ability to modify measure and dimensions metadata; similar to semantic layer concept - rename dimensions


Source: SAP

Admin option - simple switch to improve performance of charts (wave 5)

Configure parallel sessions on BW system

"Be smart about this"


Planned for Q2/Q3 - continue integration of BW concepts


Source: SAP

Stengthen analytic capabilities

Planned for end of Q2 - search to insight - see suggestions based on live connection to BW query - text based search

"Show me net revenue for top 5 products"

Integration capabilities, making them smarter


For BW, HANA, Universes, live connections

Initial release supported for English only


Source: SAP

BEx query designer has default value filters

"Soft filtering" is planned for Q2 for charts and tables


Source: SAP

Planned for Q3

Today, for BW Live connections, have partial support for Linked Analysis

Q3 - support story scenario - chart to chart filtering for BW live connections



Source: SAP

Planned BEx conditions supported Q2


Source: SAP

These features are known for import connections, now coming to live connections Q3


Time series - prereq - native support for native dimension type time


Export to CSV is part of the Q3 backlog; may go to Q4

Technical - Live Data Connectivity



Source: SAP

More of what was said earlier


Source: SAP

I like the idea of no BEx query redesign


Source: SAP

This is where SAP gets the most questions

See what is highlighted in blue

Check SAP Note 2541557

Encourage that all the latest SAP Notes applied



Source: SAP

Recommend for Live connection using CORS (cross origin resource sharing) - secure cross domain requests

ASUG BI Community Newsflash

Welcome to the latest BI community newsflash for keeping you up-to-date on important BI/BW/Analytics initiatives, events, and member offerings. This newsflash features sections that highlight various activities and action items for you to be aware of. We hope this information allows you to take full advantage of your ASUG membership.

This month we have 2018 ASUG Annual Conference (co-located with SAPPHIRE NOW®) updates, the ASUG Call for Presentations and an announcement for the 2019 BI+Analytics Conference, and more...

Opportunities to Influence


SAPPHIRE NOW® and ASUG Annual Conference: June 5-7, 2018

We have more than 50 BI/BW/SAP HANA® sessions planned for conference, as well as a community meetup in the ASUG area on the show floor, nine influence sessions, and great roundtable sessions.

Register for the SAP and ASUG Annual Conference.

Here are some of the highlights of our Annual Conference community’s sessions. Be sure to click the links to review the details, then add them to your agenda.

2018 ASUG BI Sessions Schedule

2018 ASUG Annual Conference BI Schedule with Links

2018 ASUG Annual Conference BI Brochure

This is customer-driven education, helping you make the most of your SAP investment.


ASUG Hands-on Pre-Conference Session on June 4 in Orlando

Here is what is on the agenda:

  • Get a comprehensive overview of SAP Analytics Cloud and SAP Lumira®, designer edition.
  • Learn how to integrate the designer edition of SAP Lumira and SAP Cloud Analytics into an existing SAP software landscape.
  • Find out how to use the designer edition of SAP Lumira and SAP Analytics Cloud to create compelling visual stories on-premise and in the Cloud.
  • Participate in detailed, hands-on exercises with SAP Lumira, designer edition.
  • And get hands-on with SAP Analytics Cloud.

Spaces are filling up. Register now!

Care to Share? Call for Presentations Is Open for ASUG at SAP TechEd Las Vegas

The ASUG SAP TechEd Design Team invites you to submit a proposal for SAP’s premier tech conference, SAP TechEd 2018 in Las Vegas, taking place this year October 1-5th. For the 14th year, ASUG is partnering with SAP for SAP TechEd.

You are invited to take advantage of this opportunity to share your knowledge with thousands of attendees. If your submission is accepted, you will receive a complimentary, lecture-only ticket to the event.

This year SAP TechEd is arranged by conference tracks. The deadline to submit is May 30, so hurry.


Source: ASUG

2019 BI+Analytics Conference Announcement

BI+Analytics Conference dates and location are confirmed: March 11–13 in Dallas. (pre-conference sessions are back!). We are co-locating the event with our SAP-Centric Financials conference, so it is going to be amazing. Save the date!


Source: Eventful Conferences

Upcoming Webcasts

For a list of our 2018 webcast recordings, please visit this link.

Continue the conversation and follow @ASUG_BI on Twitter.

ASUG_BI (@ASUG_BI) | Twitter

Business Intelligence Link

Register now for SAP BW/4HANA Architecture Archetypes


SAP BW/4HANA opens up a variety of modeling and architecture options. These range from the classic but streamlined EDW approach, to agile approaches that emphasize bottom-up modeling and virtualization, to the real-time analytics approach, where data replication is central. In this lecture, these approaches will be presented and discussed.


Juergen Haupt, SAP

Marc Bernard, SAP

Date:  Thursday, May 24,  2018

Time:  8:00 a.m. PT | 11:00 am ET

Duration: 60 minutes

SAP offers the opportunity influence innovations for next releases through the influence program Customer Engagement Initiative (CEI).  This is the second cycle of 2018.

What innovations are there?

There are several projects for which you can register. The following projects are relevant for the SAP BI Community Members:



TitleLink to Customer Influence Site
SAP Analytics Cloud models connector for Web Intelligence
SAP Analytics Cloud Insights for IOS
Data modeling in SAP HANA 2.0
Help us define the features for the planned SAP Analytics Cloud live access to relational database
Understanding use-cases of a typical modeler in a company
Innovations on SAP Analytics Cloud Mobile
SAP Business ByDesign Customer Analytics
IoT Analytics
SAP Connected Goods and Machine Learning: Value-added Innovations with SAP Leonardo technologies
Combining IT and OT data at the edge
CoPilot Bot Integration Hub for Slack
SAP CoPilot Conversational Interaction
Customer Feedback for Fiori Floor-plans
Innovation of Fiori Floor-Plans
Predictive Analytics for Emissions and Compliance Management
Consumer Sales Intelligence
SAP Analytics Cloud content for SAP Hybris Marketing
Intelligent Purchase Order Accruals
Process Automation in Real Estate using Machine Learning
SAP HANA Performance Management Tools (Capture and Replay, Workload Analyzer, SQL Analyzer)
SAP HANA Python Client API for machine learning and Machine Learning Notebook

These projects can be found here .


Source: SAP


Source: SAP

Above shows a picture view of the opportunities


Follow-up after registration

When you register, you will be sent a confirmation from.  When you register for a project, you will be invited to an introductory call SAP; at this point further participation is optional. Typically signing a Feedback Agreement with SAP will be part of the procedure.

The deadline for this cycle is on June 17


How do I register on the Customer Influence website?
The process of registration is here online.

About the Customer Engagement Initiative

SAP wants customer’s early involvement in the development process. Many topics will be opened only for SAP customers, but there are also topics for which the contribution of partners is requested.

Note: The above information was pulled together from various sources: SAP, ASUG and VNSG with some edits by me.

Also check the SAP Continuous Influence topics listed below:


Continuous Influence OpportunityLink to project
SAP BusinessObjects Web Intelligence
SAP Analytics Cloud & SAP Digital Boardroom
SAP Analysis for Mícrosoft Office
SAP BusinessObjects Analysis edition for OLAP
SAP BusinessObjects BI Platform
SAP BusinessObjects Mobile
SAP BusinessObjects Roambi
SAP BusinessObjects Semantic Layer
SAP Crystal Reports
SAP Analytics Hub




Consider registering for these upcoming ASUG influence council sessions:

June 18 I: ASUG Analysis Influence Council Relaunch

2018 ASUG Annual Conference Influence Sessions can be found here

Appendix - Survey

The BI Survey 18, the world's largest annual survey of business intelligence (BI) users.


As a participant, you will:


* Receive a summary of the results from the survey when it is published

* Be entered into a draw to win one of ten $50 Amazon vouchers

* Ensure that your experiences are included in the final analyses



The BI Survey 18 should take about 15-20 minutes to complete. 


Click here to take part