Archive for the ‘HANA’ Category

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

How Does SAP HANA Change the Traditional Enterprise Information Management (EIM) Process?

In the traditional EIM process, typically there are separate ETL, Replication and SDA processes and functions. Traditional processes introduce latency to the data in the data warehouse, as well as other challenges to getting data into one location seamlessly. Today’s world is moving faster, and the need for clean, real-time data is imperative.

Chances are, if you’re reading this blog, you’re no stranger to the power of SAP HANA. But to recap, the SAP HANA platform removes the burden of maintaining separated legacy systems and siloed data. It hold capabilities to transform and cleanse data in real-time from multiple sources.

SAP HANA also has features that enable you to both manage data and improve your data quality. These options offer real-time transformational possibilities that were unthinkable until recently. These features allow you to transform data in real-time with Smart Data Integration (SDI) or conform and cleanse data with Smart Data Quality (SDQ).

To download full PDF and Continue Reading…

contributor_don_loden_lgAbout Don Loden

Don Loden is an information management and information governance professional with experience in multiple verticals. He is an SAP-certified applications associate on SAP EIM products. He has more than 15 years of information technology experience in the following areas: ETL architect, development, and tuning: logical and physical data modeling; and mentoring on data warehouse, data quality, information governance, and ETL concepts. Don speaks globally and mentors on information management, governance, and quality. He authored book SAP Information Steward: Monitoring Data in Real-Time and is the co-author of two books: Implementing SAP HANA, as well as Creating SAP HANA Information Views. Don has also authored numerous articles for publications such as SAPinsider magazine, Tech Target and Information Management magazine.

Categories: HANA

Creating Repository Roles in SAP HANA Studio

What are Repository Roles?

Repository roles are roles that are created as development artifacts within the SAP HANA system. They start as design-time objects and become runtime objects upon activation. They can be utilized within a security model just like database roles. However, they offer numerous advantages over catalog or database roles.

Why Should I Use Repository Roles?

  • The definition of the repository role is stored in the SAP HANA system repository. Using package security, we can control access to individual repository roles for a diverse group of security administrators. For example, super administrators can be given access to change the definition of all repository roles while a department level administrator can be given limited access to roles that affect only his/her users.
  • They help prevent assigned privileges from being deleted from the system when the grantor’s user account gets deleted. Repository roles are granted as the system user _SYS_REPO and this account cannot be deleted from your system.
  • They are owned by _SYS_REPO. This system account cannot be deleted, unlike database roles that can be removed from the system when their creator’s database user account is deleted.
  • Repository roles can be transported from one HANA system to another using HANA Application Lifecycle Management (HALM) or using the Delivery Units (DU) Export and Import process.
  • Through auditing, we can track the true grantor of the repository roles.
  • When a user is coped in SAP HANA Studio, all of the repository roles are also copied.
  • Because they are development artifacts, the standard SAP HANA Version management tools are supported.
  • They are granted and revoked via special stored procedures. Users only need EXECUTE access to these procedures to grant and revoke rights. Unlike database roles which can only be revoked by the original grantor.

To download full PDF and Continue Reading…

contributor_jonathan_haun_lgAbout Jonathan Haun

Jonathan Haun is a Director in the Data & Analytics solution at Protiviti. He has over 15 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.


Categories: HANA