Activating any missing service in SAP HANA

SAP Developer
Updated on 30-Jul-2019 22:30:22

611 Views

In Services tab under Landscape, you can right click on any service name and select Start Missing Service. This service activates any inactive service in your HANA system.

Using fact and dimension tables in SAP HANA Modeling

SAP ABAP Expert
Updated on 30-Jul-2019 22:30:22

1K+ Views

The fact table contains measure values and primary key for Dimension tables. Dim tables contain master data. Fact and dimension table are joined in HANA Modeling to achieve some business logic.Example of Measures − Number of unit sold, Total Price, Average Delay time, etc.Dimension Table contains master data and is joined with one or more fact tables to make some business logic. Dimension tables are used to create schemas with fact tables and can be normalized.Example of Dimension Table − Customer, Product, etc.Suppose a company sells products to customers. Every sale is a fact that happens within the company and ... Read More

Opening diagnosis mode automatically in SAP HANA system

SAP Developer
Updated on 30-Jul-2019 22:30:22

258 Views

In following scenarios. When you open Administration editor, it is opened automatically in diagnosis mode:When you open the Administration editor for a system without an SQL connectionWhen you initiate the start, stop, or restart of a systemYou can also open diagnosis mode manually by navigating to following path:

Table mapping while data replication from flat file in SAP HANA database

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

289 Views

Table mapping is last step while uploading data using an Import option in HANA Studio. This shows the data that already exist in the table and also shows the information about the schema and table to which we are going to load the data.Click on Finish to load the data.

Stop and start a tenant database in SAP HANA

SAP Developer
Updated on 30-Jul-2019 22:30:22

2K+ Views

A SAP HANA administrator can start tenant databases either individually, or it can also be done once by starting the whole system and same is for stopping the database.To perform this, navigate to SAP HANA Cockpit -> Open the Manage Databases app -> You have to select tenant database that you want to stop or start -> Select stop Tenant Database or start Tenant Database in the footer toolbar.The database starts stopping or starting and will be completed in few minutes.

Different services to add to tenant database

SAP Developer
Updated on 30-Jul-2019 22:30:22

500 Views

Following are the main services that you may need to add to a tenant database:indexserverxsenginescriptserverdpserver

Using header rows during flat file upload in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

328 Views

This can be done using File import option. While importing first file, you have an option to “Add columns” in new table so you can create addition columns as per column names in other CSV’s. You can also define their datatypes, length, Primary key, not null and other column properties in same window.

How do we connect SAP Business One with Ubercart?

Sai Subramanyam
Updated on 30-Jul-2019 22:30:22

268 Views

This can be done using SAP DI server as it is using XML based format for importing data and more suitable for external data exchange. You can refer to below documentation for more details on SAP BI DI Server. https://archive.sap.com/documents/docs/DOC-7699 The DI Server enables business partners to develop SOAP-based solutions to read, write, update, and remove data objects on the database level. It provides a suitable infrastructure for server-oriented partner solutions. SAP Business One Web Services wrapper (B1WS) exposes the DI Server functionality as Web Services to provide a better usability. Developers only need to add the web references to ... Read More

Importing limited number of rows from CSV in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

381 Views

Yes, this can be done using File Import option in HANA Studio.  In Import data from local file wizard, un-check the option- Import all data and you can mention Start Line and End Line value.

Running T-code me51n again in SAP system throws an error

Syed Javed
Updated on 30-Jul-2019 22:30:22

355 Views

Try using breakpoint on my include in EXIT_SAPLMEREQ_010 and check if it gets to breakpoint on the second run.It could be possible that error gets stuck due to standard SAP procedure. Try to run this T-code: me51n in different environments and check if it works fine.

Advertisements