- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
SAP HANA Information Composer
What is SAP HANA Information Composer?
SAP HANA Information Composer is a web-based data modeling environment dedicated for non-technical users. It is an easy-to-use platform for end users who are not from a technical background of data modeling and analysis.
Information composer enables the user to do two main tasks, i.e. extract data from data sources (acquiring data) and manipulate or model that data into logical structures by creating information views. Two types of users uses Information composer; power users and authors.
Power users are the users capable of conducting data modeling operations such as extracting data, creating physical tables, creating data models and information and other reporting tasks. The role required for such users is IC_MODELING.
Another type of users are the authors which share the information views and reports created by power user with other users. These users can access the data in information views and workbooks. The role required to be assigned to users in this category is .IC_PUBLIC.
Information Modeler Vs Information Composer
One obvious question in your mind must be that how SAP HANA information modeler and information composer are different from each other as both of them are used for information modeling?
Well, there is a prominent difference between the two. The basis of difference between the information modeler and information composer is the target users. SAP HANA Information Modeler is for technical users with extensive data modeling requirements and technical knowledge.
Whereas, information composer is for non-technical users who are not IT and data science experts (with no database or modeling knowledge).
This tool gives such users a role to play in data analysis as they can also create reports as per their knowledge and insights in the data and provide a new perspective to the technical users.
The information composer is designed in such a way that it aids non-technical users with user-friendly interface, animations, hints and suggestions for modeling and reporting.
They can perform a range of advanced operations related to modeling such as creating attribute views, analytic views, calculation views, processing models, data management and administration, data loading and import/export tables.
Features of SAP HANA Information Composer
Below are some key features of information composer:
Data acquisition or extraction:
Users can easily extract data from data sources, cleanse the data, automate data typing, refresh data from the source, create physical tables and preview the data.
Users can upload data into information composer in two primary ways, i.e. directly from the data source or by first copying it on the clipboard and then pasting it in the information composer. File types supported for uploading are xls, csv, xlxs etc. You can have as much as 5 million cells per file upload in the information composer.
Users can combine two table fetched from SAP or non-SAP data source and create information views with added calculated fields. This way data models are created for reporting and analysis purpose to be further used by tools like SAP BO.
System and Server Requirements
Some important system and server requirements are:
- Internet Explorer with Silverlight 4 must be installed on the system.
- Recommended SAP HANA version is SAP HANA 1.0 Enterprise SPS3 and later.
- A minimum of 2GB RAM is necessary.
- Java 6 must be installed on the server (64-bit).
- OS supported are 64-bit Windows 7, XP, Vista, Server 2003, 2008.
- Information composer runs on a Lean Java Server which must be co-located with the SAP HANA Database Server.
Benefits of Using Information Composer
Information composer has got many advantages for its user base.
Here are some business-specific benefits:
Users from a non-technical background have a guided and user-friendly experience where they can upload, cleanse, compose, combine, and preview data tables as well as information views.
It provides easy self-service capabilities where users can extract data from local sources and combine it with enterprise data to create data models and publish views.
Better and quicker analytic outputs due to rapid development cycles on SAP HANA platform.
And some IT-specific benefits:
User need to recruit technical and IT professionals due to low pressure on them to create, model and upload data modeling objects and reports for other users (non-technical) to draw insights. This is because information composer enables non-technical users to do basic analytical operations without relying on IT.
It brings all the data in SAP HANA at a central portal which makes administration, management and security of data easy.
Applications of Information Composer
Core applications of the information composer are:
- Classify and cleanse the data
- Table creation and publishing views/tables
- Data source selection
- Combine and preview data
- Manage data fields
Uploading Data using Information Composer
Now that we have gained a good amount of theoretical knowledge about the information composer, let’s take a practical concept.
Follow the steps given below to upload data in SAP HANA using SAP HANA Information Composer:
To access the Information Composer, use the address structure given below with specific server and port numbers.
http://< server>:< port>/IC
Logon to the Information Composer from the login dialog. You will require details such as User Name, Password, and System name.
Go to the UPLOAD tab in Information Composer. You can upload data from different file types such as .xls, .xlsx, .csv etc. Also, you can select specific sheets from a workbook.
Step 3: Specify data source –
You can select a data source from two options; Data from file system and Data from Clipboard.
Once you select the data source for upload or data upload is complete, you can save the data as a draft. The saved data is available in IC_TABLES schema, under the Tables folder.
After data uploading completes, a preview of uploaded data represents in tabular form. Using the magnifying glass symbol given at the right, you can search for particular data entries in the table.
You can access the data from the schema called IC_TABLES.
If the data you uploaded has got repetitive and inconsistent data such as Indore, indore, or INDORE, the Information Composer has got an intelligent feature as “Cleanse Data”. This data cleansing option intelligently detects such inconsistencies and correct them.
In addition to this, you can do the correction manually by dragging and dropping the similar values and merging them.
Once a data table uploads, you can change the source by clicking on the Change Source option.
Step 6: Classify fields –
In this step, you will have to classify data fields as attributes or measures. The Information Composer gives you recommendations for measure fields.
However, you can also select fields and assign them as attribute or measure field by clicking on the respective checkbox. A primary key is also defined from the uploaded fields by default.
Step 7: Publish and Finish –
This is the final and crucial step in the process of uploading data. Through this step, data finally uploads as a physical data table in the SAP HANA database.
To publish the data you uploaded, give it a unique name and description if you like.
You get to select user roles from two options; Share this data with other users or Start a new Information View based on this data.
If you select Share this data with other users option then a user having IC_PUBLIC role can view the uploaded data set or table residing in HANA database.
And if you select Start a new Information View based on this data option, then Information Composer will launch a new modeling screen where the uploaded data is the primary data source.
Once you have made your selections click on Publish and Finish button.
You can access your newly uploaded data from the quick access section on the right of the IC main page. From here you can filter data from this icon. The filter options are; Draft user data, Private user data, and Public user data.
From the settings icon, you can Rename, Delete or Share data with others.
The tick symbol represent that the data table or data set is already published and the tick with user symbol represent that the data set is published and is shared with other users as well.
You can upload up to 5 million data cells into SAP HANA using the Information Composer.