Rapid Deployment solutions in SAP Hana

Rapid Deployment solutions.

RAPIDMARTS:

SAP has delivered Rapid marts to reduce the development duration period. In that Rapid marts well will get the below files   

NOTE:

We have mentioned installation before previews topics are phase refer them

• .DDL file --- if index files do not verify DDL Provides
• .ATL file
• Index files
• Attribute view file
• analytic view file
• calculate the view file
• .DFX file
• .VLX file
• .CNX file
• .BIARI file
• .XLF file

 .DDL file:- if index files are not working DDL provides a set of SQL statements to create schema & Tables

.ATL file:- It is a ‘DS” file which contains DS for SAP R3 DS for SAP HANA, a project which contains Job to transfer data form Table  R3 --- HANA tables

NOTE:- If you don’t have DDL or index files we can import tables under DS for data strove for SAP HANA for ‘DS’ directly [Before doing these step we need to create schema manually in SAL Editor by providing the command “Create / Schema <schema name>]

Index files:- It contains the catalog in the form of a folder that organize all tables in the form of folders. The table folder contains a SQL query for creating a table and.CTL file in an XML file, attribute folder it combines binary files.

[Before importing tables we need to keep index files in HANA DB in specified path] We need to keep in a specified path.

/usr/SAP/HAN/DBXX/Work

(XX---instance number) We can import those files from HANA DB select in import option in HANA Studio navigation File         

Select tables select target HANA system                        

Select above mention path and Next                     

Type<schema name>, <Table Name> and click on add. Select import selection type Import selection  

IMPORT:           

• Catalog + data
• Catalog only
• Replace the existing tables
• So, will get tables

Attribute view file:- This file is for attribute view:

Analytic view file:- This file is for analytic view

Calculate view file: This file is for calculate view

.DFX file:- IT is a data foundation files for BO enterprises contains structure (a combination of views & tables)

.DLX file:- it is a business layer file which contains the Data foundation

.CNX file:- Which contains JDBC connections for HANA of BO enterprises

.BIAR file:- it is a backup file for DO enterprise which contains universe design too, web & other reports

.XLF file:-We contains dashboards, for reaped analytics

PROCEDURE:

If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Training"   This course will help you to achieve excellence in this domain

Place Index file HANA DB installed directly

/use SAP/HAN/DDXX/work

Import Table from HANA DB by selecting the option in HANA studio, file                 

Import                                

select tables                                

select work directory (HANA DB installed directory)                  

type schema name, table name/schema name .*                               

Click on add

Import

• Catalog + data
• Catalog only
• Replace the existing tables

If the above step is not working will SAP has delivered.DBL file to create schema & tables

Go to  SQL Editor on SAP HANA studio parte SWL DDL file and execute and refresh the catalog folder, so with object server  catalog with tables  

Import.ATC files into DS to

• After importing ATL we get Datastore for R3 data store for HANA and projects.
• Configure RS Datastore by providing R3 creditors like server name – user ID,-- password, client number, system number works directions
• Configure HANA DATA STORE by providing creditors Like ODBC connection, version, user name, password
• Execute the Job under the project.
• Go to SAP HANA studio and refresh catalog preview the data of table whether data is there or not

SAP HANA Tutorials

Importing information models:

Click on file; import select information models select path & ok So we will get package and information models – witch packages  

Notes:- This information model will activate only when correct tables & correct catalog name, otherwise they don’t activate and activate    

Restore backup file:

We can restore universe & Reports from the BLAR file by using the upgrade manager

• Select process type – complete upgrade type (BIAR to live) Provide DIAR file Path provide authentication details of BO enterprise and the select universe, reports users provides access control and finish
• So we will get UDT, which contains structures, objects
• So we need to connect our universe & into HANA DB

By providing ODBC, connection for the universe

Directly creating connection in HANA data stores in HANA DB

Above steps for only UDI  

IDT activities:

Log on to IDT  -  create a project – Place.CNX,DFX, .BLX in specified path   C:/uses/username/.business objects/ BIM BI modeler – 14/work

• So will get data foundation, connection, business layer
• So edit connection by providing HANA ODBC connection Exporting into system Repository
• Activate Data foundations & activate the Business layer and export business layer into system reporting log on to analysis. WebI, explorer, Dashboards end connect our rapid IDT for Rapid reports.