Friday, 7 December 2018

How to Generate a HANA CDS Wrapper View

To generate from command prompt, please complete the following:

◈ Download and install the js application.
◈ Open the js command prompt.
◈ Install the dependent packages from the command prompt npm install.
◈ Open the folder hana-cds-wrapper-generator-master/view-generator and execute js.

Wednesday, 5 December 2018

Refreshing a SAP HANA Database using a database backup


One typical use case managed by SAP Landscape Management is refreshing a system – overwrite the content of an existing target system with actual data from the source system while maintaining system topology and configuration. General SAP Landscape Management functionality allows to manage such an exercise via a “Storage Based” or “Virtualization Based” approach:

Monday, 3 December 2018

Create Time-Related Tables and Generate Time Data in SAP HANA XSA Platform


Time data is necessary almost in any kind of data manipulation process, as well as adding time-dimension to the calculation views. So, ways to go for the time-dimension has changed a bit with the release of SAP HANA XSA Platform. In this blog post, you’ll see how to create time-related tables if required, and generate time data through the steps on SAP WEB IDE.

Friday, 30 November 2018

SAP S/4HANA: Key Adoption Scenarios to Consider Webcast Recap

SAP S/4HANA, SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Learning

This was a SAP user group webinar from yesterday.

Interesting developments are planned next year for 1809 in terms of system conversion; read below.

Wednesday, 28 November 2018

SAP HANA System Copy- Homogeneous On Multi Tenant Database – Refresh using SWPM

As explained on my last blog SAP HANA System Copy- Homogeneous On Multi Tenant Database that we have 3 Ways to do System Copy and i explain 2 Ways 1 and 3 according to the note -1844468 – Homogeneous system copy on SAP HANA, and i promised to add 2nd way as well , So below is the 2nd way to do system copy, For Pre checks and preparation please read the 1st blog,

Monday, 26 November 2018

XSA and SAP Web IDE For SAP HANA 2.0 SPS 03 Feature Revision 1: New Developer Features

Normally when we introduce new features for HANA, it is only done via a new release version (HANA 1.0 or 2.0) or an SPS – Support Package Stack (ex. HANA 2.0 SPS 0, SPS 01, SPS 02, SPS 03). However the XSA runtime and the SAP Web IDE for SAP HANA actually have a rather independent technical infrastructure from the HANA DB itself. Up to this point we’ve never used this feature to deliver new features separate from a HANA release or SPS. But it was always possible.

Sunday, 25 November 2018

Merge Multiple SCD Tables into A Single Dimension

Tracking historical changes within a dimension is a common task in data warehousing.  Achieving this in a HANA sidecar database (SCD) requires an explicit design focus.  In some cases, the data source system maintains dates and time stamps to denote a record or value’s creation, change, or validity threshold.  In SAP systems creation, change, or validity dates are often but not always maintained for a record, dimension, attribute, or value. One such example being SAP Human Capital Management (HCM) mini-master info-types, seen as below: