Friday 28 September 2018

Terms and Conditions


This Agreement contains the complete terms and conditions that apply to you in joining, buying and all other activities you will make in our website. By using or shopping from this Website, you agree to be bound by its terms of use and shall comply thereof. This Agreement describes and encompasses the entire agreement between you and us, and supersedes all prior or contemporaneous agreements, representations, warranties and understandings with respect to the Site, the content and computer programs provided by or through the Site, and the subject matter of this Agreement. Amendments to this agreement can be made and effected by us from time to time without specific notice to you. Agreement posted on the Site reflects the latest agreement, and you should carefully review the same before you use our site.


The Site allows you to shop online. However, you are prohibited from doing the following:

  • Use our site, including its services and or tools, if you are not able to form legally-binding contracts, are under the age of 18, or are temporarily or indefinitely suspended from using our sites, services, or tools.
  • Collect information about users’ personal information.
  • Post false, inaccurate, misleading, defamatory or libelous content.
  • Take any action that may damage the rating system.


The has the sole discretion to provide the terms of payment. Unless otherwise agreed, payment must be received by prior to the acceptance of an order. Unless credit term has been agreed upon, payment for the products shall be made by credit card. Invoices are due and payable within the time period noted on your invoice, measured from the date of the invoice. has the discretion to cancel or deny orders. The is not responsible for pricing, typographical, or other errors in any offer by and reserves the right to cancel any orders arising from such errors. Satisfactory payment must be received prior to goods being shipped.

Our online payment processor, they collect your information at checkout to process your purchase. Upon checkout, there is also an optional check-box to allow us to contact you for marketing purposes. This is opt-in and is compliant with GDPR. If you would like your purchase history deleted please contact us.


The does not have to provide a refund if you have changed your mind about a particular purchase, so please choose carefully.


We promise our premium users for 100% Money Back Guarantee if the premium user fails to understand or not satisfied with our digital training service. No human interactions mandatory after purchase. We are liable to support/help to provide the digital training material in video formate after successful payment.

User required to provide the following details within 30 days of purchase if they are not satisfied with our service who claim for refund.
  • Statement of valid reasons/lists saying why you are not satisfied
  • Valuable feedback which supports your reason
  • Reference link or screenshot of authorized/trusted books/source which is biased to your reason of non-satisfaction.
  • Order date and order number

The List Price displayed for products on our website represents the full retail price listed on the product itself, suggested by the manufacturer or supplier, or estimated in accordance with standard industry practice; or the estimated retail value for a comparably featured item offered elsewhere. The List Price is a comparative price estimate and may or may not represent the prevailing price in every area on any particular day. For certain items that are offered as a set, the List Price may represent “open-stock” prices, which means the aggregate of the manufacturer’s estimated or suggested retail price for each of the items included in the set. Where an item is offered for sale by one of our merchants, the List Price may be provided by the merchant. In cases of mispriced in our catalogs in which the item’s correct price is higher than our stated price, we will, at our discretion, either contact you for instructions before shipping or cancel your order and notify you of such cancellation.

We do not warrant those product descriptions or other contents of this site are accurate, complete, reliable, current, or error-free. If a product offered on our website is not as described, your sole remedy is to return it in unused condition.


You hereby acknowledge that all rights, titles, and interests, including but not limited to rights covered by the Intellectual Property Rights, belong to the site and that you will not acquire any right, title, or interest in or to the Program except as expressly set forth in this Agreement. You will not modify, adapt, translate, prepare derivative works from, decompile, reverse engineer, disassemble or otherwise attempt to derive source code from any of our services, software, or documentation, or create or attempt to create a substitute or similar service or product through use of, or access to, the Program or proprietary information related thereto.


FRAUDULENT ACTIVITIES are highly monitored on our site, and if fraud is detected we shall resort to all remedies available to us, and you shall be responsible for all costs and legal fees arising from these fraudulent activities.


We will not be liable for indirect, special, or consequential damages, or any loss of revenue, profits, or data, arising in connection with this Agreement or the Program, even if we have been advised of the possibility of such damages. Further, our aggregate liability arising with respect to this Agreement and the Program will not exceed the total price of the subject products paid or payable by you.

We make no express or implied warranties or representations with respect to the Program or any products sold and offered on our website (including, without limitation, warranties of fitness, merchantability, non-infringement, or any implied warranties arising out of a course of performance, dealing, or trade usage). In addition, we make no representation that the operation of our site will be uninterrupted or error-free, and we will not be liable for the consequences of any interruptions or errors. This site and its information, contents, materials, products, and services are provided on an “as is” and “as available” basis. You understand and agree that your use of this site is at your own risk.


You agree not to disclose information you obtain from us and or from our clients, advertisers, and suppliers. All information submitted to by an end-user customer pursuant to a Program is proprietary information of Such customer information is confidential and may not be disclosed. Publisher agrees not to reproduce, disseminate, sell, distribute or commercially exploit any such proprietary information in any manner.


This Agreement will remain in full force and effect while you use the website. You may terminate your membership at any time for any reason by contacting us via email or the Contact Us page. We may terminate your membership for any reason at any time. Even after your membership is terminated, certain sections of this Agreement will remain in effect. We may delete the practice exam result history data at any time for registered users and after the expiration of premium membership for premium users. The may go down for maintenance purpose or due to any technical issue with/without prior notice. As part of our content moderation system, we may modify or delete any content/part of content submitted by users.


Members on this website are prohibited to use the services of the website in connection with any commercial endeavors or ventures. This includes providing links to other websites, whether deemed competitive to this website or not.

Upgrading HANA XSA & WebIDE

Obtaining the Software

It’s easy to forget exactly what’s been installed, so I have captured here the pieces I needed.

Search Words Description  Filename (as at 11-Sept-2018) 
EXTAPPSER Extended App Services – XSA server binaries EXTAPPSER00P_88-70001316.SAR
HRTT  HANA Run Time Tools, required for WebIDE  XSACHRTT06_62-70002322.ZIP 
XSACMONITOR  XSA Monitoring, required for WebIDE  XSACMONITORING06_5-70002324.ZIP 

Wednesday 26 September 2018

Difference in query results when run from HANA MDX and HANA SQL

SAP HANA offers multiple access options to query SAP HANA views available in database:

◈ The HANA SQL access, the primary HANA access, allows you to query HANA views using the SQL query language. This access is optimized for on-premise solutions.

◈ The HANA MDX access, that offers multi-dimensional concepts to HANA models, allows you to query HANA views as cubes (including HANA hierarchies) through the Multi-Dimensional eXpressions (MDX) query language.

Tuesday 25 September 2018

HANA SDI is super set of all, if and only if – HANA is the main data target.

Now a day’s lot of questions are coming around HANA SDI like HANA SDI is the only future data integration solution for the SAP?  Should we use SAP SLT or HANA SDI for data replication now? SAP Data services will be die in future?

To answer all these questions let me try explaining what is SDI technology and How it is different from existing data integration tools.

Friday 21 September 2018

Business Partner configuration while doing conversion from ECC to HANA.


While performing SI check, we normally get the error for Business Partner as shown below :

The major errors we usually get is CVI_MAPPING and CHK_CONT_MAP.

Wednesday 19 September 2018

How to import the ST05 trace file into HANA Studio and display as a graph

Some ABAPers might have already noticed this button “Graphical Explain” in tcode ST05 but do not know how to use it properly.

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Monday 17 September 2018

Build database objects/services in HANA service using SAP WebIDE Full-Stack : Part 2

This blog is part of a blog series which shows to build HANA database artefacts using the SAP WebIDE Full-Stack and the new HANA service on Cloud Foundry.

Create Nodejs. Module

In this section, I am going to show how to create a nodejs module and add an OData service within it. This OData service will be used to expose the contents of the table/view modeled earlier.

Friday 14 September 2018

Build database objects/services in HANA service using SAP WebIDE Full-Stack : Part 1

I walked through the steps to install and configure the HANA service on SAP Cloud Platform Cloud Foundry environment, In this blog series, I will focus on how to get started with building database objects using SAP WebIDE Full-Stack service. One of the main advantages of using SAP WebIDE is that you can now build a full-stack application (Database object, services with business logic and UI components etc). In this blog series, I am going to focus on how to create database objects and expose them as XSOData services. I have come across several requirements where data needs to be stored in SAP HANA service and needs to be exposed for other cloud platform services to consume. Hence, I will start by showing how to create DB artefacts and end by showing how to expose contents of a table using an OData service.

Thursday 13 September 2018

Sneak peek into HANA as a Service: Database artifacts and Calculation Views

If you are lucky to come to TechEd, I have plenty of instances to share for you to configure and deploy yourself. We will be using the Cloud Application Programming model to build a little something on top of them.

Monday 10 September 2018

The SAP HANA JSON Document Store – Use Case Part-2

Example Use Case for the Document Store


In part one of this blog series the Document Store was introduced. The most interesting part about this is the possibility to interact with the relational world inside SAP HANA, e.g. joining a collection with a table. Since this is a very abstract feature, the following sections will introduce an example use case including SQL queries for a better and deeper understanding of the SAP HANA JSON Document Store.

Friday 7 September 2018

Schedule HANA 2.0 backup using SAP HANA Cockpit 2.0 SPS 06

As we are aware that SAP HANA Cockpit is the new web based tool for SAP HANA Administration, recently I have been involved in BW/BPC HANA implementation migration project and I installed the latest SAP HANA Cockpit 2.0 SPS 06 patch 04 release to monitor and administer the non production and production HANA databases.

Wednesday 5 September 2018

SLT Replication Logging and Replay To Retrieve Lost Data

We know SLT used for real-time replication to HANA but if we face below situations then SLT logging and replay is useful.

1. Table replication shows fine but some data fields not updated correctly(Due to product bug or any other reason) – example cases are flag fields where data changed multiple times in particular time.

Tuesday 4 September 2018

Multiple SAML2 Identity Providers for HANA XS Artifact – How It Works

SAML 2 Single Sign-On (SSO) is usually a must-have for live HANA connections in SAP Analytics Cloud (SAC). In such a setup, the InA service, which is a HANA XS artifact, is configured with a SAML 2 Identity Provider (IdP), typically the same IdP as the one used by SAC. This IdP is often the corporate SAML 2 Identity Provider.