Rapid Deployment solutions in SAP Hana

Rapid Deployment solutions.

RAPIDMARTS:-

SAP has delivered Rapid marts  to reduce the developments duration period.

In that Rapid marts well will get below files

 

 

NOTE:

We are mentioned installation before previews topics be phase refer them

1. .DDL file --- if index files not verify DDL Provides
2. .ATL file
3. Index files
4. Attribute view file
5. analytic view file
6. calculate view file
7. .DFX file
8. .VLX file
9. .CNX file
10. .BIARI file

 

1. .XLF file

 

1. .DDL file:- if index files are not working DDL provides sct of SQL statements to

   create schema & Tables

2. .ATL file :- It is a ‘DS” file which contains DS for SAP R3 DS for SAP HANA, 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 command

“Create / Schema <schema name>]

3. Index files:- It contains the catalog in the form of folder which organize all tables in the form of folders. Table folder contains SQL query for creating table and .CTL file in 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 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                         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

 

4. Attribute view file:- This file is for attribute view:
5. Analytic view file:- This file is for analytic view
6. Calculate view file: This file is for calculate view
7. .DFX file:- IT is a data foundation files for BO enterprises contains structure (combination                of views & tables)
8. .DLX file:- it is business layer file which contains Data foundation
9. .CNX file:- Which contains JDBC connections for HANA of BO enterprises
10. .BIAR file:- it is a backup file for DO enterprise which contains universe design too, web & other reports
11. .XLF file:-We contains dash boards, for reaped analytics

 

 

PROCEDURE:-

1. Place Index file HANA DB installed directly

/use SAP/HAN/DDXX/work

2. Import Table from HANA DB by selecting 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

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

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

 

4. Import .ATC files into DS to

• After importing ATL we get Data store for R3 data store for HANA and projects.
• Configure RS Data store 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 project.
• Go to SAP HANA studio and refresh catalog preview the data of table whether data is there or not

 

5. 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 models will activate only when correct tables & correct catalog name,

other wise they don’t activate and activate

 

 

6. Restore backup file:-

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

• Select process type – complete upgrade up grade type (BIAR to live)

  Provide DIAR file Path

  provide authentication details of BO enterprise and the select universe, reports user’s provides accen control and finish

• So we will get UDT, which contains structures, objects
• So we need to connect our universe & into HANA DB

1. By providing ODBC, connection for universe
2. Directly creating connection in HANA data stores in HANA DB

Above steps for only UDI

 

7. IDT activities:-

Log on to IDT  -  create 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 Business layer and export business layer into system reporting log on to analysis. WebI, explorer, Dash boards end connect our rapid IDT for Rapid reports.