Monday, February 19, 2018

HANA Virtual Data Models Part 1

HANA Live Virtual Data Model is one of the key idea in the HANA technology. Below I will show you how core business data can be shared using well-defined views on HANA DB.

HANA Live VDM is a new approach to deliver predefined views to analytics applications. To be able to use SAP HANA Live you need to have your source table in SAP HANA.

Integration Approach and Side-by-side Approach

In the Integration Approach, you have your SAP Business Suite (ECC, CRM, etc.) on HANA. The other option is to use SAP BW. If you are using BW on HANA, data can be replicated from the source system to BW in real time (SLT). In both approaches real-time data is provided to reporting layer. The following picture shows replication to BW.

Transactional and master data from the source systems are immediately replicated to HANA tables, and these become the source for reports and applications. We are working here with an exact copy of the source data. Views on the BW side provide business-oriented data presentation. SAP delivers the entire catalog of pre-defined views required in various business areas. We can work on available structures or copy existing objects and modify them for our purposes.

What is available in standard structures?

You can review available models and structures using SAP HANA Live Browser. Using this UI5 Web-based application you can learn about data structures and dependencies. You can also preview real business data.

What are the types of available views?

We have a few types of views shown in the below picture.

1. Query Views

Views designed for direct use in applications and reports are called query views. In this structure you may convert data and currency, implement user-specific calculations.You should not include them in other structures.

2. Reuse Views

As a component, you can use reuse views. Reuse views are well structured and optimize objects that can be a puzzle of your solution. They are not designed to be directly used by reporting tools. In these structures you are enhancing data with key business logic, calculating fields, joining objects, filtering data.

3. Private Views

Private views represent SQL code executed on one or many tables/views. These are the basic building blocks of the model, usually focused on a small section of business data. Here you are doing basic selection, calculation and joins.

4. Value Help Views

One more type of views I would like to mention is value help view. That view provides value list for a specific business scenario and is used in a value help in a query view.

Tuesday, February 13, 2018

How can I use HANA Live Browser

SAP HANA Live Browser is a repository of HANA analytical views. The repository is based on SAP HANA Live standard and custom views.
It is a flexible tool to browse the definition of the views, data structure, and preview data on-line. You can also display data using SAP Lumira and Analysis for Office.
You can launch the repository by entering the following address: http://WebServerHost:80SAPHANAinstance/sap/hba/explorer/buser.html. If you are not sure what is the Web Server Host and SAP HANA instance, you can find it in using SAP HANA Modeler perspective in Eclipse (Properties > Path in the below picture).
One of the interesting features is the option to provide the access to business users. End users can display business data, models and structures according to assigned authorizations. Details regarding the installation of the tool you can find on the SAP HANA Documentation page.

Monday, December 2, 2013

How to copy BEx RKF (Copying Calculated/Restricted Key Figures)

There is an easy way to make a copy of you global Restricted/Calculated Key Figures. You can copy within the InfcoCube / MultiProvider or copy for one InfoCube to the second one.

Here are the steps:

  1. Run transaction code RSZC
  2. Choose the name of source and target object (it could be the same object)
  3. Choose the type of structure, you would like to copy
  4. Select the object and enter a new technical name for the copied objects.

 

In the same way you can copy other structures like query, filter, structures.

Tuesday, December 4, 2012

SAP BI Analysis Authorization - required concept in BW 7.3x

SAP NetWeaver BW 7.3 brings a lot of new features. Some old concepts are also superseded by new ones. The 'old' reporting authorization is no longer supported by BW 7.3. You need to migrate to analysis authorization before upgrade. You also can't switch back to 'old' concept.

When upgrading to analysis authorization, the following Notes will help you:

      931898 Migration Analysis Authorizations
      938871 Migration Reporting Authorizations II
      1001652 (characteristic 0TCAKYFNM), 958665, 946724
      942799 and 944929 (RSECADMIN)

There is an interesting Expert Session on upgrading into BW 7.3, that covers authoriation topics.

What kind of problems did you faced during authorization swith? Please share with us your experiences!

Tuesday, February 21, 2012

Attributes Change Run - applying changes in aggregates

Basics of Attribute Change Run

Attributes Change Run applies changes into aggregates if there was a change in navigation attributes used in aggregates or in hierarchies of a characteristic.

This process in necessary, because in aggregates data from InfoCube are persistently stored in aggregated form (In InfoCube, no data related to navigation attributes or hierarchies are stored).

To start Attributes Change Run, go to:

RSA1, use menu Tools>Hierarchy/Attribute Changes.

You will see there a list of available sets of InfoObjects and appropriate change status.

If you mark a line, and click InfoObject List button, you will see a list of objects that are planned for that Change Run.

The second important button is Execute button. Use it when you already market the line, for which you would like to start Attribute Change Run.

Change Run process steps

  1. Change Run checks which characteristics and hierarchies had changes since the last change run. Run specifies which aggregates must be adjusted.
  2. Change Run apply changes (dialog process for each required InfoCubes' aggregates).
  3. Activation of changes in master data and hierarchies.

There is a SAP lock, that (during point 1) is preventing other changes runs to start a job for the same time. Also rollups and aggregate builds are not executed. The name of the lock: CHNGRUN_ST

The second SAP lock (CHANGERUN) is locking objects (InfoObjects, InfoCubes, hierarchies) that are involved in the adjustment (point 2).

When the work is finished, the CHANGERUN lock is removed.

There could be only one change run in the initial phase (1). If other change run starts, it will fail immediately. It is not possible to start multiple change runs. Read about parallel change run in SAP Note 534630.

Additional Notes:

Change Run process can be monitored, restarted using RSDDS_CHANGERUN_MONITOR ABAP report. You can start it using se38 transaction.

It is better to run CHR for all newly loaded master data in the process chain. Do not start it for each master data load.

Usefully links:

Sunday, September 20, 2009

How to insert two queries into one BEx Analyzer workbook.

I frequently need to use data form different InfoProviders. Sometimes, instead creating MultiProvider, it is faster to put two or more queries into one workbook and create separate tab to display joined data. Here are 7 steps to create such a solution:

1. Create queries you would like to join.
2. Open one of the queries in BEx Analyzer and save it as a workbook.
3. Create two additional tabs in the workbook, and give them names (e.g., query2, results)
4. Edit the query2 tab by adding design items: click BEx Analyzer > Design Toolbar > Insert Analysis Grid
5. Click on the Properties dialog box, change Data Provider's name and click create button.
6. Choose the second query and confirm your choice.
7. Create a table, on the result tab, that merge data form both queries. Save the workbook.

What about selection screen? The variables related to the queries will be displayed on one selection screen, if you use the same variable in the queries - there will be only one field for the shared variables.

To learn more about analysis grid, read Analysis Grid section at sap.help.com.

Tuesday, June 9, 2009

Search sites about SAP BW using customer search

I created Search sites on SAP BW and Reporting, my search engine, focused on searching sites about SAP BW, using Google Customer Search. It shows results mainly form the sites: help.sap.com, sdn.sap.com, bwarea.com, sap.ittoolbox.com (BW group), sapfans.com (BW forum). If you think it is helpful, interesting or ... worthless - give me your feedback.