November 4, 2012

SAP HANA Online Training

Hello Everyone,

We are offering online Training on SAP HANA from a real time experienced SAP BW & SAP HANA certified Consultant. We assure about the quality training for freshers and experienced DWH / BI professionals providing more emphasis towards the complete HANA Landscape and Hands on practical exposure with real time scenarios for a reasonable fee structure with the best technical derivables.

We would request everyone to project their interest towards taking up this opportunity on an Individual basis.

Do not miss to avail the best opportunity provided.
Please send us your enquiry & availabilty details to schedule the demo.

You can reach us on

For more Technical clarifications, Please do feel free to contact us on 7204606604.

The mode of training is Online.

May 1, 2012

My new website ''

Hello Everyone,

Thank you for visiting my blog. In last 2 months This blog has 120 average visitors on everyday, this gave me thought to get my domain.

15 days back i have registered by domain '' with an aim to provide good learning resource for SAP BI, BO and HANA.

What all you can at SAP Analytics Guru:

Blog: This is the place for all good documents(own and collection from different resources) and my experience on BI, BO and HANA. You will find some useful tips as you have in this blog.

In future i will completely move this blog to my blog section in website. At present I planned to keep the content in this blog for short time.

Forum: Place where you can ask questions related to BI, BO and HANA. I have categorized the forum in very good manner, so that you will not get confuse while posting the question and same for those who is interested to give replies.

Do visit forum to get look and feel. Registration is required to post or reply to the question.

Learning Path: I am planning to create step by step procedure documents for SAP BI and HANA(in future for BO). I will keep all my self prepared documents in this section and i will prepare learning paths for each module (where to start and how to proceed). I will try to provide at least one document for each section.

This page is still not published

Downloads: Here you can find collection good documents for three modules and category wise.

This page also under construction.

As you like my blog, if you need good documents and tips do visit my website and i will try post good articles regularly.

Once again thank you for encouraging me to do by visiting my blog... :)

I am new to webiste hosting and has zero knowledge in website creation. I tried to give better one and hope i will give best soon.

do write you comments and suggestion on my new website.

Give your suggestions if anyone has knowledge on php, that will be really helpful for me.

April 20, 2012

What all we can do at Quick Launch screen in SAP HANA - Part2

Hello Everyone,

In this document, I would like to take you through the different options available at Quick launch screen in SAP HANA.

We have 7 major sections in Quick Launch screen as show in below screen.

  1. Select System.
  2. New (where we can create all Models).
  3. Package
  4. Content
  5. Setup
  6. Data
  7. Help


In Part-1 document, I have explained about first 4 sections (Select System, New, Package and Content). In this one I will explain about the remaining 3 sections.

5) Setup: Here we can maintain the setting for HANA studio, configuration of server settings and schema mappings.

i) Manage Preference: In this functionality we can maintain settings for Information Modeler and Administration Console.

As an example I will show you how to increase rows displayed in data preview. If we do data preview on any View, we will get max of 5000 rows.

So how to increase the number of rows display in data preview.


a) Click on ‘Manage Preferences’ in Quick Launch screen.


b) Now Click on ‘Modeler’ --> Data Preview’ to get the below screen.


c) Here we can change the settings.

ii) Configure Import Server:

Here we need to maintain the Repository Server name for Data Services. The below screen will give you the idea.


iii) Delivery Unit: This is useful to create Delivery Unit which is a group of transportable objects (Packages). For example we can create the delivery unit for the objects which we want to move to the HANA next system or export to local system.

Note: This Delivery unit is identified by Vendor and Name.

Before we start delivery unit creation, we have to maintain the properties for Vendor. This can be done in ‘Manage Preferences’ section.


  1. In Quick Launch screen, click on ‘Delivery Unit’

      b) Click on ‘Create’

c) Give the Delivery Unit, Vendor and person responsible.

d) Click on ‘Add’ to assign the packages to the delivery unit.

e) Close.

Now we can export this delivery unit to local system or other HANA server.

iv) Schema Mapping: We use this functionality to map authoring schema to the physical database schema. This is done when the source schema (authoring schema) is different than the physical schema (Target Schema).

We can connect multiple source schemas to same target schema.


  1. Click on ‘Schema Mapping’ in Quick Launch screen.


b) Enter the Authoring and Physical schema.

c) Click on ‘Add’ to add it and Ok.

6) Data: In this section we can maintain the setting for Data Provisioning, generate time data and open sql editor directly.

i) Generate Time Data: This is used to generate time data and load it into the attribute view table.

We can generate two types of time data.

  1. Gregorian

   b. Fiscal

a) Click on ‘Generate Time Data’ in Quick Launch screen to get below screen.


b) Select Calendar Type i) Gregorian ii) Fiscal

c) If we select ‘Gregorian’ type, then give from year and To Year.

d) Select ‘Granularity’. Below are the available granularities.


d) If we select ‘Fiscal’ then we have to give the Variant table(T009 table)

e) Now click on ‘Generate’ to load the time data into HANA system.

ii) Data Provisioning: This is used to load the data into HANA system using SLT or Sybase Replication Server.


a) In Quick Launch screen, click on ‘Data Provisioning’.

b) If you are using SLT-based replication, choose ‘Source’.

c) Choose Load (for initial load) or Replicate (for data replication) as appropriate.

d) Select the required tables.

e) Choose Add.

f) If you are using the load controller infrastructure, choose Next and enter the operating system username and password.

g) Choose Finish.

iii) SQL editor: We can create the objects, tables and schemas from here instead using Information modeler navigation's.

7) Help: Here you will find all sap help documentation on SAP HANA.

Hope this document helps for the Beginners in SAP HANA...