How to de-schedule or reschedule jobs/process chains in SAP in single shot using programs

Hi All,

In this post, i am going to explain that When we are working in Support projects we often face upgrades or system outages. When there is an outage/upgrade we need to de-schedule all the loads in BW system and reschedule them once system comes from outage/maintenance.

Then the first thing which comes in our mind is how can i stop all the chains running in my system in one shot. If we have huge number of process chains, it is going to be hassle process to perform.

Document Link: Click me to read the document will give you, how we can do this using programs

Hope it helps... 

Why Navigational attribute work as characteristic in Reporting and Modelling in SAP BI

Hi All,

In this post, i am going to explain that we all know Fact table is surrounded by dimension table and master data in connected to dimension tables using SID's.

So any master data object which has SID can act as characteristic in reporting or in Cube.

If you add an attribute to any characteristics, we know what are all the tables will generate.

Display time independent -- P Table

Display time depended -- Q Table

Navigational time independent -- X Table

Navigational time dependent --- Y table.

If you check P and Q table in BI system, it will not contain SID values. But if you check X and Y values, it will contain SID values for this characteristic and we will have SID values of main characteristic(to which this is navigational attribute).

The following figure illustrates the relationship between X table and the SID table of navigational attribute.

Let’s take we have defined LOCATION as navigational attribute for 0CUSTOMER.

As navigational attributes contains SID values, it will act as characteristics in reporting and Cube. 

Document Link: Click me to read the document for characteristic tables structure 

 Hope it helps...       

Loading Hierarchies from Flat File using the new DataSource and Transformation Technology

Hi All,

This post explains the Hierarchies loading from Flat File to SAP BW 7.3

Introduction: 

With SAP Netweaver BW 7.3, we are given a flexibility to load the hierarchies from flat file by creating transformations, InfoPackages and DTP’s. This paper explains the step by step procedure to load the plant hierarchy data, which is available in a Flat File, to ‘ZPLANT’ info object.

Document Link - Check the below link for step by step procedure:

Loading Hierarchies from Flat File using the new DataSource and Transformation Technology

Basic Navigations in SAP HANA Brand New System

Hi All,

In this post, I am going to show  the basic navigation's that we need to do when we login to the brand new SAP HANA system.

This includes the following.

1) Adding System

2) Package Creation

1) Adding System: Once the SAP HANA is installed and when we click on 'HANA Studio' the below screen will come up.

In the above screen left side, 'Navigator' space will show what are all the system available in this Studio. As this is new system the first step we have to do is add the system.

Step1: right click in the Navigator space, click on 'Add System'

Step2: In the next screen we have to mention 'Hostname' and 'Instance Number'.

Note: We can have multiple systems with same hostname but different instance number.

Select the language and click on 'Next'.

Step3: Here we have to authenticate this system by providing user name and password.

Click on 'Next' and then 'Finish' to see you system in the Navigator.

Once the system is added, a schema will be created based with the 'user name' we provided for authentication. In this if we drill down the 'catalog', we can see the schema with name 'P1001301'. Schema contains the objects(tables, views) created and customizations done by that particular user.

We have 2 main perspectives in SAP HANA.

i) Administration Console: Where in we can perform all DB level monitoring and activities.

ii) Information Modeler: This is the place where all can create their models in SAP HANA.

2) Package Creation: Package is a collection of objects modeled in SAP HANA. We can create 3 types of models/views in SAP HANA.

i) Attribute View.

ii) Analytic Views

iii) Calculation Views

iv) Analytical Privileges : Authenticate users before data is displayed or authentication of business rules.

Packaged is used to hold this objects in SAP HANA.

Step1: Goto 'Information Modeler' perspective (Window --> Open Perspective -->other -->Modeler -->Ok). We will get below screen.

The right side of the above screen is called 'Quick Launch' of Information Modeler.All the packages will be grouped under 'Content'

Step2: We can create the new package in 2 ways

1) Right Click on 'content' --> New Package

2) Directly click on 'Create' in the Quick Launch.

In then next screen give below details.

Package Name, Description.

Step3: Click on 'Ok' to see your package under 'Content' folder.

Each Package contains below sub folders.

1) Attribute Views

2) Analytic Views

3) Calculation Views

4) Analytic Privileges.

Hope this document will be helpful for beginers in SAP HANA hands on...

Different ways of table creation in SAP HANA

Hi All,

In this post, I would like to explain different ways of table creation in SAP HANA.

In SAP HANA, we can create tables in two ways.

1) Using SQL editor.

2) Using Information Modeler.

1) Using SQL Editor:

Step1: We can open SQL editor from i) Quick Launch ii) Right click on your schema --> SQL Editor iii) Right click on your system --> SQL Editor.

SQL syntax to create table in SAP HANA.

"create <table type> table <table name>(<field name1> <data type>, <field name2> <data type>, .....);"

we can create 3 types of tables in SAP HANA.

i) Column : Which stores the data on column level. This is mostly suitable for HANA data models. If we replicate tables from source, by default those will be replicated as column tables.

As we all know we get huge compression with columnar tables.

ii) Row: This tables are to store the system statistics or parameters. Sometimes Row store tables will give better performance on master data tables. however SAP HANA models gives very good performance on Columnar tables.

iii) Table Type: This tables are used to pass the parameters. These are used when we create Calculation views using SQL scripts in SAP HANA.

In this example, I am going to create table for customer information(CUST_INFO).

Step2: Open SQL editor and type the statement as given below.

Step3: Now click on arrow with green or F8 to execute this SQL statement.

Once it is successfully executed, we will get message like below

Step4: Now we can check the newly created table under our schema --> Tables like below.

Double click on the table name to display the Table Definition.

2) Using Information Modeler:

If we are not familiar with SQL, we can still create tables in SAP HANA by using graphical modeler.

Step1: Right click on your Schema in System and select 'New Table'

Step2: Now in the below screen give the Table Name, Schema and Table Type.

As we discussed already,we have 3 types of Table Types.

In this I am going to create the same table using graphical modeler.

Enter the required fileds and properties like data type, key and not null.

Use the 'Plus symbol' to add the new fields to the table.

Step4: Click on arrow or F8 to execute to deploy this table. After successful execution you will get the same message and given in first method.

Hope this document will be useful for beginners in SAP HANA.