SAP HANA Course for Modelers from www.sapstudent.com - Promotional Offer

Hello

We are happy to announce that, we have released video based SAP HANA Course for Modelers.

Some of the course highlights are:

1) Close to 200 videos which covers more than 40+ hours of content.
2) Quiz after every chapter which will be very helpful for the people planning for certification.
3) Videos are created by the people who has real-time implementation experience of more than 4 years in SAP HANA.
4) Study material is provided for each video and sample data to practice same thing in your own system.
5) Hands on videos on 6 different data provisioning techniques, 7 different reporting tools and for every option available for modelers in SAP HANA studio.
6) No need to worry even if you see new SAP HANA release after registering for course. You will get new chapter added for every new SAP HANA release which covers new features in it for life time.
7) Have got any questions after you register for course? No need to worry instructors will be available anytime through forums inside the course to clear your doubts.

For promotional videos, please look at the below link:
https://www.youtube.com/playlist?list=PLDa15_03h61dluXfRC68nTZp1LUAQQOLw

Use the below link to purchase course:
http://courses.sapstudent.com/courses/sap-hana-complete-course-for-modelers

As a promotional offer, we are giving FLAT 40% discount for first 100 members.

Use below coupon codes:

RSJAN8K - For people buying in INR
USJAN100 - For people buying in USD

Grab your chance before it gets over. HURRY..!!!

Best Regards,
SAP Student

Excellent Learning resource for SAP HANA, Data Services, SAP BW and SAP BOBJ

Hi All,

We have created new website and started publishing lot of information on SAP HANA, SAP BW, SAP Data Services and BOBJ.

Keep visiting for latest content.

The website name is www.sapstudent.com

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.

Navigation:

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.

Navigation:

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.

Navigation:

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

Navigation:

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.

Navigation:

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...