Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Dashboarding

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter Teaser
Sign up now for our monthly newsletter!
Sign up for newsletter
 

External HANA Views - Generating external HANA views from BW objects

In the first part of our series, you learned about the concept behind external HANA Views. In the article "External HANA Views - Advantages of automatically generated HANA Views" we explained the advantages and also the limitations of HANA Views. This is the second part of our three-part series on external HANA Views. In this post, we will show you how to generate the views for the respective BW objects.

Our "External HANA Views" blog series at a glance

  1. External HANA Views - Advantages of automatically generated HANA Views

  2. External HANA Views - Generating external HANA views from BW objects

  3. External HANA Views - Where are the external HANA views stored? 

 

InfoObject

To generate an external SAP HANA view for InfoObjects, first open the InfoObject in Eclipse. Under the description of the characteristic, you will find the options "External SAP HANA View for Master Data" and "External SAP HANA View for Reporting". Select the desired option and activate the characteristic. This creates a HANA view on the SAP HANA database that corresponds to the structure of the InfoObject.

001-external-hana-view-infoobject

Please note that virtual master data is not supported. To be able to replicate the authorizations in SAP HANA, the authorization objects S_TABU_LIN and S_RS_IOMAD must be assigned to the users.

Then it comes to the use of hierarchies, some special features have to be taken into account. If you generate a HANA view for an InfoObject that uses hierarchies, a HANA view for hierarchies is also generated.

If the InfoObject is not used as an InfoProvider and the setting "External SAP HANA view for master data" is active, a master data view and a hierarchy view are generated. This internal hierarchy view can be used in a query view to display the characteristic values in a hierarchical structure.

If, on the other hand, the InfoObject is used as an InfoProvider and the setting "External SAP HANA view for master data" is set, a master data view and a hierarchy view are also generated for internal use. In addition, another hierarchy view is generated for reporting and analysis.

002-reporting-hierarchy

The naming convention for the internal hierarchy view is <IOBJNM>_HIERARCHY. This is a calculation view of type DIMENSION. This view can be used in other SAP HANA views to display the characteristic values in a hierarchical structure.

The hierarchy view for reporting is generated according to the following naming convention: <IOBJNM>_REPORTING_HIERARCHY. It is a calculation view of type CUBE. This view can be used independently to display the characteristic values in a hierarchical structure. The transaction data is aggregated accordingly.

You can use hieid (hierarchy ID) and keydate (key date) as input parameters for both hierarchy views. If the keydate parameter is not passed in the call, the current date is used by default.

ADSO

Based on an ADSO it is also possible to create an external SAP HANA view. To do this, tick the “External SAP HANA view” option and activate the ADSO. When the DataStore object is activated, a SAP HANA view is created on the HANA database that corresponds to the structure of the ADSO.

It is also possible to create an external SAP HANA View based on an ADSO. To do so, check the "External SAP HANA View" option and activate the ADSO. When the DataStore object is activated, an SAP HANA View is created on the HANA database that corresponds to the structure of the ADSO.

003-adso-hana-view

The ADSO may only contain InfoObjects that are visible for reporting. InfoObjects with the setting "No master data check / No reporting" are not supported. This setting is made for each characteristic in the Details tab.

004-no-master-data

If fields are used in ADSO, they may contain a maximum of 20 characters in the name. Only the following types are supported:

  • CHAR: length 1 - 250
  • NUMC: length 1 - 250
  • CUKY: length 5
  • UNIT: length 3
  • LANG: length 1
  • DATS: length 8
  • TIMS: length 6

The following types are supported for key figures:

  • INT4: length 16 - 31 with 0 - 14 decimal places
  • FLOAT: length 16 - 31 with  0 - 14 decimal places
  • DEC: length 16 - 31 with  0 - 14 decimal places
  • CURR: length 1 - 31 with  0 - 14 decimal places; There must be an assignment to a CUKY characteristic and the length must be greater than or equal to the number of decimal places.
  • QUAN: length 1 - 31 with  0 - 14 decimal places; There must be an assignment to a UNIT characteristic and the length must be greater than or equal to the number of decimal places.

INT8, DATS or TIMS key figures are not supported.

Composite Provider

You can also generate calculation views for Composite Provider that you have created in BW Modeling Tools. To do this, check the "External SAP HANA view" option and activate the Composite Provider. When the Composite Provider is activated, a Calculation View is generated on the HANA database that corresponds to the structure of the Composite Provider. However, there are also some restrictions.

005-composite-provider-hana-view

For example, data from the following InfoProviders is excluded: Open ODS Views that do not use a Calculation Scenario, Aggregation Levels, and InfoObjects that are used as InfoProviders for which the master data access is set to anything other than standard. If the Composite Provider consists only of these characteristics, that is, Open ODS Views without Calculation Scenario, aggregation levels and InfoObjects without standard master data access, the HANA View cannot be generated.


A comparison of SAP BW, HANA Native and SAP DW Cloud - Download the whitepaper here!

Neuer Call-to-Action


In addition, for Open ODS views with Calculation Scenario, you must ensure that the SAP database user of the BW application server has SELECT authorization with GRANT OPTION for the table or view pointing to the Open ODS view. Moreover, request handling is not supported. All requests are always read.

When it comes to authorizations, there is another peculiarity to consider. Composite Providers can also contain native SAP HANA tables or views. These can be integrated directly or via an Open ODS View. The authorizations to access these native SAP HANA objects within BW are managed in BW.

It is true that BW authorizations are replicated when the external HANA view is created. However, it does not apply to the authorizations of the native SAP HANA objects. Therefore, the same user may not be able to access the external HANA view and the data in the HANA view may not match the data displayed in BW.

To resolve this issue, you can either disable the authorization check for the affected HANA view or maintain the authorizations manually in SAP HANA.

Local Composite Provider from BW Workspaces

In addition to the normal Composite Providers, you can also use local Composite Providers from workspaces to automatically generate calculation views. The same requirements apply as for normal Composite Providers.

In BW4HANA, the external HANA views are created in the Workspace Designer. To start the Workspace Designer, select the menu path Modeling → Workspace Designer under Home. You can create the workspace itself under the Configuration menu item.

006-workspace-designer

Then select the previously created Composite Provider and click on Change.

007-change-local-comp

In the Create Queries step, you can check the External SAP HANA view for reporting setting.

008-workspace-local-comp-external-sap-hana

After activation, the external HANA View is created.

009-view-generated

If you are working with BW on HANA, you can create the workspace using transaction RSWSP (Workspace Individual Processing).

010-bwonhana-create-workspace

To subsequently create a Local Composite Provider via Workspace Designer, use the web interface at the following URL:

https://<Web Server Host>:<Web Server Port>/sap/bc/webdynpro/sap/rsl_ui_my_workspace

011-bwonhana-change-local-cp

The following steps correspond to those on BW4HANA, which I have already described above. However, the Webdynpro interface looks less stylish compared to Fiori.

012-bwonhana-local-comp-workspace

Query

Queries can also be used to generate SAP HANA views. This allows you to model the desired drilldown in the query and then create a HANA view.

You must observe the following prerequisites. The query must be based on an ADSO or Composite Provider. The "External SAP HANA View" setting must also be active for the ADSO or Composite Provider. In addition, the Composite Provider used must not have any ambiguous joins.

013-adso-hana-view

If a hierarchy is used, an SAP HANA view must also be active for the InfoObject on which the hierarchy is defined.

014-external-hana-view-infoobject

In addition, input-ready planning queries are not supported.

If these requirements are met, you can activate the External SAP HANA View setting in BW Modeling Tools under the General tab, in the Remote Access section. When the query is saved, a SAP HANA view corresponding to the query structure is generated on the SAP HANA database.

015-query-hana-view

When generating the HANA View, the texts of the query elements are always added in the user's logon language. For key figures, the UID is used as the technical name in the HANA View if no technical name is defined in BW Modeling Tools. You can customize the technical name in BW Modeling Tools under Properties General Technical Name.

016-technical-name-keyfigure

If you use global elements such as filters and structures in your query, you need to consider the following. When the query is modified in BW Modeling Tools, the associated HANA View is automatically updated. However, this does not apply to global elements such as global filters or global structures. If you change these, the HANA View of the query is not automatically adjusted. This happens only after you save the query again.

Furthermore, the results of the HANA Calculation View may differ from the results of the query on the BW application server. This is because the Calculation View cannot perform calculations such as zero suppression.

For example, a HANA View can still be generated if the query contains certain BW functions. However, these are ignored by the HANA View. This applies, for example, to conditions, exceptions, display options such as number of decimal places, hidden key figures, and zero suppression. A complete list can be found in the SAP help.

If the query contains constant selections, cell definitions or exception aggregations, HANA View cannot be generated. In this case, the setting is grayed out.

017-query-external-view-not-possible

Our Summary - generate external HANA views from BW objects

As you can see, it is very easy to create external SAP HANA views. When setting up, you only have to take into account the special features of the underlying objects. Now that we have explained them in detail, we will show you in the next article where in the system the generated HANA views are stored.

Do you have questions about HANA Views? Are you trying to build up the necessary know-how in your department or do you need support with a specific question? We will be happy to help you. Request a non-binding consulting offer today.

Learn more about SAP BW

 

,

avatar

Sebastian

Sebastian Uhlig has been consulting companies in various industries on SAP BI solutions at national and international level since 2001 and covers the range from requirements analysis to the implementation of complex solutions. He has experience in leading project teams and is the architect of the product NextTables. He enjoys mountain biking and watching American football games.

Got a question about this blog?
Ask Sebastian

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts