Archive for the ‘HANA’ Category

SAP HANA 2.0 supports LDAP!

via SAP HANA 2.0 supports LDAP!

One of the great new features available in SAP HANA 2.0 SPS0 is its support of LDAP authorization. SAP also takes that a step further in SAP HANA 2.0 SPS3 by also adding support for LDAP authentication with automated user provisioning. With this in mind, one could now state that SAP HANA supports LDAP in the enterprise environment. However, closer inspection of the evolution of its LDAP capabilities in required. Because SAP HANA’s LDAP support evolved from authorization to authentication and provisioning in later versions, the setup can get a little confusing. In many ways the components of authorization and authentication can each operate independently. However, using both together is the most practical approach. With that in mind, lets look at authorization, authentication and user provisioning each in more detail. I will also conclude with an example setup using SQL commands.

Categories: HANA

Protiviti Authors Set to Launch New Book, Data Provisioning for SAP HANA®

Five of Protiviti’s Data Management and Advanced Analytics practice SAP experts have come together to write a 375-page guide, Data Provisioning for SAP HANA. Before making data available in SAP HANA, the data must be standardized, integrated and secured. This book details the options to accomplish that data provisioning, introducing readers to the various tools available and providing detailed case studies that demonstrate those tools in action.

SAP provides several options to extract, transform and load (ETL) data into SAP HANA. Data Provisioning for SAP HANA looks at each tool independently to understand the strengths and weaknesses of each, and where each typically sits in the IT landscape. Those tools include:

  • SAP HANA smart data integration (SDI)
  • SAP HANA smart data quality (SDQ)
  • SAP HANA smart data access (SDA)
  • SAP agile data preparation
  • SAP data services
  • SAP landscape transformation replication (SLT)
  • SAP data quality management (DQM)
  • SAP HANA data in the cloud

Each chapter demonstrates how to install, configure and develop in these tools and case studies show how these tools were implemented in a number of organizations.

This book will be helpful for decision makers who want to understand the different options available to load data into HANA for new implementations, or for companies looking to simplify the IT landscape by utilizing some of the new tools to ETL data into HANA. Architects, developers and system administrators will also appreciate the book’s step-by-step instructions for configuration, development and administration of these data provisioning tools.

Congratulations to our authors: Don Loden, Managing Director; Managers Russ Lamb and Vinay Suneja; Senior Consultant Vernon Gomes and Consultant Megan Cundiff.

Data Provisioning for SAP HANA is expected to be available in June in hardcover and ebook format. Pre-orders are being accepted here:

Categories: HANA, Industry Trends

Demystifying SAP® HANA: Understanding Options, Determining the Best Path

Although SAP HANA products have been around for some time, they continue to evolve, and we continue to find that many clients remain unsure of how to best unlock the potential of HANA solutions within their organizations. Most know that HANA is SAP’s high-powered, in-memory column and row store database. Yet many overlook the fact that SAP HANA is much more than a really quick database. It offers a multitude of functionality, including a database which also serves as the db foundation for many of SAP’s Netweaver based solutions, a development platform and a data warehouse solution. In addition, SAP HANA can function as the foundation for the BI platform, providing users the ability to model business scenarios in real-time, adding tremendous value. Yet, not all versions of SAP HANA are equal.

At the recent 2018 BI/HANA conference, Protiviti Managing Director (and co-author of this post) Don Loden presented a breakout session on understanding and demystifying the SAP HANA options available. During that session, Loden discussed real-world use cases and used product demonstrations to help attendees understand when and where HANA options make sense and the impacts these solutions have on complex global organizations.

During the conference session, Loden outlined the most common options for SAP HANA. First is SAP Suite on HANA or SAP S/4HANA.  With both, HANA becomes the data platform that runs business suite applications. But in a true S/4HANA world users see another lift in performance because S/4 has been purposely designed for HANA.

Click here to read more.

Don Loden






Russ Cohen





Categories: HANA

We Asked: What’s Your BW Strategy? The Answers Surprised Us

Recently, as part of Protiviti’s Data Management & Advanced Analytics practice’s popular Expert Webinar Series, my colleague Vinay Suneja and I reviewed the various options available to BW customers to migrate to HANA. Our discussion included overviews of SAP HANA Enterprise, SAP BW on HANA and SAP BW/4HANA, clearly differentiating the business value each of these technologies bring to an organization’s landscape. Several hundred people attended and many of those guests asked questions, both throughout and after the presentation. What we learned from those questions confirms much of what I see in my day-to-day work with current clients: there is still a great deal of confusion in the marketplace about how organizations can optimize their investment in data tools to deliver the best return in terms of simplicity to the architecture, and provide best value to business for overall organizational growth.

During the webinar, we took a look at what we believe are the top three options for companies looking to refine, or define, a holistic Business Warehouse (BW) strategy using the SAP solutions that are best for their needs. Every day, we see that organizations are investing in increasingly complex architecture with many building blocks, resulting in complex data lineage causing reconciliation issues, longer nightly batch data management and lack of real-time data due to inflexible data loads in the resident BW system, among other issues.

The first, SAP HANA Enterprise with a side car, is an independent system which can extract data directly from ECC and other source systems, providing a multitude of analytical capabilities with text, spatial, big data, and predictive algorithms.  The second world be a migration to SAP BW ON HANA, bringing agility and versatility to data models. Finally, we covered the new release of SAP BW/4HANA, a migration and upgrade that brings redesigned modeling and enterprise-wide data warehouse capabilities integrating data from operational and digital business.

To download and Continue Reading…


About Sri Velicheti

Sri Velicheti is a Director in Protiviti’s Data & Analytics practice advising clients in information management strategy, business intelligence, data warehouse, data governance, and master data management. He has 18+ years’ experience in implementing SAP solutions for diverse clients in the Manufacturing, Utilities, Public Sector and Banking industries. He has been a thought leader and a frequent speaker at SAP Analytics conferences and other regional conferences.


Categories: BW, HANA

SAP HANA Expert Webinar Series

If you’re not sure how to make the most of your SAP HANA solutions, join one or all of these informative webinars, led by Protiviti subject matter experts.

From how to determine What’s Your BW Strategy: BW on HANA, BW/4HANA or HANA Enterprise? to Mastering the HANA Security Model, you’ll have the opportunity to learn more about the SAP HANA topics that are driving today’s data management industry. Our series will also touch on What to Consider when Moving to HANA 2.0, Best Practices for Optimizing your HANA Views and SAP HANA Deployment Options: On-Premise, Cloud or Hybrid. 

Join us on Thursdays beginning September 7 at 2:00 pm eastern for a deep dive into Everything HANA.

Register for one or all five!

What’s Your BW Strategy: BW on HANA, BW/4HANA or HANA Enterprise
Speaker: Sri Velicheti, Director – Business Intelligence and Vinay, Suneja, Senior Consultant – Business Intelligence
Thursday, September 7 @ 11:00 am Pacific / 1:00 pm Central / 2:00 pm Eastern

If you are debating whether to migrate to SAP BW on HANA, implement SAP HANA Enterprise, SAP BW/4HANA or provide a combination of these moving forward, you will want to take advantage of this webinar. You’ll gain a pragmatic approach to your SAP HANA journey, including practical insights for making the right choice and understanding how the choice you make influences your SAP S/4HANA journey.

Key Learning Points

  • Learn the value proposition and compare pros and cons of SAP BW/4HANA vs. SAP HANA Enterprise based on your specific system landscape
  • Discover a comprehensive three-step process focusing on business applications, usage statistics, and technical infrastructure that will influence your SAP HANA migration strategy
  • Understand the impact of “change” to your technical organization and opportunities to retrain your workforce to meet future demand

Sri Velicheti is a Director of Business Intelligence in Protiviti’s Data Management & Advanced Analytics group, advising and delivering solutions in Enterprise Transformation, Advanced Analytics, and Enterprise Performance Management using data as a strategic asset. An experienced business leader, he brings more than 15 years of work in implementing and managing enterprise wide applications driving results, extracting value to steer business growth with forward-look analytics.

Vinay Suneja, who joined Protiviti’s Data & Analytics practice in 2016 and is currently a Senior Consultant, provides Big Data analytics solutions to Fortune 500 clients. He is proficient in SAP BI/BW and Big Data technologies including Design Studio, Lumira, Webi, HANA and Hadoop.

Mastering the SAP HANA Security Model
Speaker: Jonathan Haun, Director – Business Intelligence
Thursday, September 14 @ 11:00 am Pacific / 1:00 pm Central / 2:00 pm Eastern

Join us for this thorough overview of how SAP HANA’s security mechanism works. You’ll walk through technical explanations and practical examples, including best practice strategies to properly provision users and manage repository roles, explore how third party authentication can integrate with SAP HANA, and find out how to provide selective access to data using analytic privileges and more.

Key Learning Points

  • Gain best practice strategies to properly provision users and manage repository roles
  • Explore how third-party authentication can integrate with SAP HANA; see examples using SAML and Kerberos authentication
  • Find out how to provide selective access to data using analytics privileges in SAP HANA

Protiviti’s Jonathan Haun wrote the book on HANA Security – literally! He’s recently published the SAP HANA Security Guide via SAP Press and has co-authored three other books on HANA-related topics.

What to Consider when Moving to HANA 2.0
Speaker: Jonathan Haun, Director – Business Intelligence
Thursday, September 21 @ 11:00 am Pacific / 1:00 pm Central / 2:00 pm Eastern

This webinar will introduce you to a comprehensive overview of everything needed to implement or upgrade to HANA 2.0, the “next generation data management platform for digital transformation.” This includes impacts to SAP applications, key changes to the platform as well as information regarding the hardware and operating systems required.

Key Learning Points

  • Discover what’s new and different with HANA 2.0 and what steps are ahead to implement or upgrade to HANA 2.0
  • Examine the hardware required to support HANA 2.0
  • Understand what operating systems are required to support HANA 2.0

Protiviti’s Jonathan Haun is widely regarded as a HANA experts and recently wrote the book on HANA Security – literally! He’s recently published the SAP HANA Security Guide via SAP Press and has co-authored three other books on HANA-related topics.

Best Practices for Optimizing HANA View to Create a Robust Analytic Platform
Speaker: Marshall Kelley, Manager – Business Intelligence
Thursday, September 28 @ 11:00 am Pacific / 1:00 pm Central / 2:00 pm Eastern

SAP HANA is an extremely fast and powerful tool, but has your organization solved the challenge of how to best optimize HANA views for speed, flexibility and reusabilty? Attend this session to hear strategies for creating an analytical foundation in SAP HANA, which can then be leveraged directly for simple analysis and/or re-used in secondary views for advanced analysis.

Key Learning Points

  • Fundamentals of HANA modeling, and why these techniques are crucial to performance
  • Why HANA models are like icebergs and why it’s important to pay attention to what’s under the surface
  • How to optimize all types of HANA views to achieve speed, flexibility, and reusability
  • A look at Calculation Views: current and future state
  • Why performance testing isn’t just for the racetrack
  • Common challenges faced when accommodating multiple tools and use cases

Marshall Kelley is a Data and Analytics Manager at Protivit, where he specializes in strategy, design, and implementation of end-to-end business intelligence solutions for customers across all industries. He is trusted by clients for his cross-functional skills combining technological expertise with business acumen. Marshall frequently speaks at industry conferences and is an SAP certified instructor who has trained hundreds of users in various SAP BI tools. His specialties include: SAP HANA, SAP BusinessObjects, SAP Design Studio, Microsoft Power BI, Microsoft SQL Server, Business Intelligence, Information Delivery, Reporting and Visualization.

SAP HANA Deployment Options: On-Premise, Cloud or Hybrid
Speaker: Scott Golden, Managing Director – Business Intelligence 
Thursday, October 5 @ 11:00 am Pacific / 1:00 pm Central / 2:00 pm Eastern

Navigating the decisions around SAP HANA platforms can be daunting. In this session, Scott will review the deployment options available and offer tips on determining which might bet he best fit for your business needs, budget, and resources. Whether it’s on-premise for maximum control, in the cloud for fast time-to-value or through a hybrid model that supports a variety of deployment scenarios, this webinar will cover them all, and more.

Key Learning Points

  • Review the pros (and cons) of on-premise, cloud or hybrid platforms
  • Address security and performance concerns
  • Discuss license types: perpetual versus subscription
  • Analyze Cloud Options: Subscription, Hosted, Platform as a Service (Amazon, Azure)
  • Learn best practices to achieve maximum operational efficiencies

Scott Golden is a Managing Director in Protiviti’s Data Management and Advanced Analytics practice. He joined the firm in November 2015 when the company he co-founded, Decision First Technologies, was acquired by Protiviti. Scott brings more than 20 years of experience in developing and implementing analytic solutions across a variety of industries and involving a number of technologies. Solutions include large enterprise data warehouses, small targeted data marts, and real time ODS coupled with reporting, dashboard and visualization solutions deployed locally and in the cloud.

Categories: HANA

Creating Dynamic References in Universes

This is a guide to create easy dynamic references in a universe for easy dynamic date filtering in BusinessObjects. The following steps are for universes based off HANA Analytic and Calculation Views. 

A common ask from a client is automation, and we are definitely fans. It’s preferable to write a report once, then not have to touch it again, a la the old Ron Popeil adage: “Set it and forget it.” There are many Web Intelligence documents that are time-based analyses. Perhaps a year-to-date (YTD) report that compares the current year over the previous three years. Without some kind of dynamic data in there for filtering, we are stuck constantly updating the date. If this report is also on a scheduled burst to users, updating the date range becomes a monthly (even weekly) activity. Who wants to keep doing that?

We recently implemented a solution with one of our clients that offers a plethora of dynamic date options to use as filters in Web Intelligence. Given that we can filter a data dimension by another object in the query, we can use these dynamic dates to always return the appropriate dates regardless of when they are run/bursted. Let’s walk you through the steps to create them in a universe via the Information Design Tool (IDT).

    1. When is now? 
      The first step is to create the current date. Organizationally, we are going to create additional folders and sub-folders to make it easier for our users. Let’s create a few folder and sub-folders:


To download PDF and Continue Reading…

About the Authors 

Jason Kehl

Jason is a Manager in Protiviti’s Data Management & Advanced Analytics practice. A multi-year veteran of SAP products, he has helped customers move from BEx Queries into HANA powered BusinessObjects, upgrade environments, security and administration, and build various reports and dashboards. Jason is proficient on SAP BW, Business Explorer queries, Web Intelligence, Information Design Tool, Universe Design Tool, Lumira, HANA modeling, BusinessObjects administration, security and upgrades. He has also spoke at numerous ASUG and SAPinsider events.


Russ Cohen

Russ is a senior consultant in Protiviti’s Data Management & Advanced Analytics practice with a strong business and technological background in SAP HANA modeling, Design Studio, Lumira, Web Intelligence, and Information Design Tool. Russ is familiar with and has worked on multiple databases including HANA, ECC, BW, as well as OLAP and relational databases. he is skilled in all stages of the development cycle: requirement analysis, design, development, testing, deployment and end-user training abilities.

Categories: HANA, IDT

Top 5 Reasons Why You Need an SAP HANA Security Strategy

As more organizations make the move to SAP HANA-based solutions, many of those same companies are failing to recognize that building a solid security strategy is just as important as the platform itself. With most of the SAP ecosphere running something based on SAP HANA, solutions like Suite on SAP HANA (SoH) and S/4HANA are bringing the dream of running ERP and Analytics on the same platform to life, prompting more organizations to grant access directly to the SAP HANA database.

But is that the best strategy to keep your valuable data secure? Have you considered the gaps that exist in your SAP HANA security model? Do you HAVE an SAP HANA security strategy in place? Here are the top five reasons all organizations need to address their SAP HANA security model before it’s too late:

  1. Fraud can cause an organization to lose both money and its valuable reputation. When an SAP HANA system operates an SAP ERP application serve, someone only needs to INSERT, UPDATE or DELETE access to the SAP ERP tables to commit mass fraud.
  2. When your SAP ERP system is offline, it is hard to conduct business. So yes, securing your SAP HANA system is also about system availability. An untrained administrator with a high level of privileges can be just as dangerous as a hacker trying to bring down your system. You’ll need a sound SAP HANA security model, SoD and training to prevent these types of mistakes.
  3. Hackers try to gain access to your systems and data for a variety of reasons. Typically, they’re not breaking in to perform routine maintenance. More likely, they hack into your system to steal information, commit fraud, extortion, denial of service and other malicious acts. You must make it very difficult for them to penetrate your SAP HANA database security.
  4. Compliance means that resistance to implementing SAP HANA security if futile. Most organizations have obligations to external regulatory agencies and must adhere to their security standards. SAP HANA is one of many systems that are subject to numerous regulations. Therefore, you need to have a security model and security strategy for all SAP HANA systems.
  5. Access to data must be governed. Almost all SAP HANA solutions involve the storage of master data and transaction data. Such data often needs to be segregated within the organization. Without a proper security model in place, most organizations have no means of securely distributing data hosted in SAP HANA.


To help organizations understand what’s required to create a sound SAP HANA security model, I recently authored a book titled SAP HAN Security Guide, now available from SAP-Press and Rheinwerk Publishing.



The book addresses the following key areas of security and other topics:

User Provisioning Repository Roles
Object Privileges System Privileges
Package Privileges Analytic Privileges
Encryption Auditing and Monitoring
Troubleshooting Security Recommendations

SAP HANA Security Guide is available from SAP Press in hard copy or ebook format at: SAP-PRESS. Hard copies are also available from Amazon.

About Jonathan Haun

Jonathan is currently working as a Director at Protiviti. He has over 16 years of BI and IT experience. He currently focuses exclusively on Business Intelligence tools, technologies and EIM processes. He has helped hundreds of companies implement BI tools and strategies over the past 10 years. With Protiviti, he primarily works with the SAP BusinessObjects IDD and EIM tools. This includes experience with Data Integrator, Data Services, Universe Design, Web Intelligence, Crystal Reports, Xcelsius, BusinessObjects Enterprise, HANA, BOE architecture and server sizing. He is also a contributing author to the SAP Press book “Implementing SAP HANA” and the SAP Insider Book “SAP HANA HA and DR Essentials” The views and opinions on this blog are my own. They do not necessarily represent the views and opinions of Protiviti or SAP.

Categories: HANA, Security

Getting Started with BW4HANA

Big Data with SAP HANA & Hadoop

Purpose –

This is part 1 of series of blog to get started with BW4HANA.

In this part we will create a BW4HANA instance from the image deployed by SAP on Cloud Platform like AWS or Azure.

Prerequisites –

  • SAP SID. It usually starts with S and is 11 characters for eg-: S0012345678. You can get SID from SAP.
  • SAP Cloud Appliance Library account (link). Fill in the necessary information using your SID above.
  • Access key and Secret key for your Amazon Web Service (AWS) account if you are using AWS to host your instance.

Let’s Get Started –

  1. Open the SAP Cal (link) in your favorite browser


  1. Login with your SAP ID

1-2.png3. On the top right corner there is a search option, Search for “BW


4. Select the appropriate instance from the below list and click on Create instance.      …

View original post 211 more words

Categories: HANA

How to secure information views in SAP HANA

As more and more organization implement SAP HANA native or standalone, the need to understand how to provide access and secure information views has emerge.  The intent of this article is to provid…

Source: How to secure information views in SAP HANA

Categories: HANA

Multistore Table Partitions in SAP HANA 2.0

Starting with SAP HANA 2.0 we can now partition a single table between in-memory storage and SAP HANA Extended Storage (AKA.. Dynamic Tiring). This is an excellent feature because it simplifies the…

Source: Multistore Table Partitions in SAP HANA 2.0

Categories: HANA