Found 19 Articles for SAP Testing

Generating time data in SAP HANA

Updated on 12-Mar-2020 10:50:14
To generate time data and replicate your data, follow below steps −In the SAP HANA Studio in the Modeler perspective, on the Quick Launch tab, select the relevant SAP HANA system and choose Generate Time Data.In the field Calendar Type, select Gregorian.Enter the period for which you want to generate data. You should generate time data for all years for which data can occur in your application (Ex: 1999 to 2020).Select Granularity Day → Finish

Checking performance of SAP HANA system

SAP Developer
Updated on 18-Jun-2020 07:52:19
This can be checked in Performance tab under Administration icon in SAP HANA.In this tab, you can check the following:ThreadsSessionsBlocked TransactionsSQL Plan CacheExpensive statement traceJob ProgressLoad

Disk utilization and configuration details view in SAP HANA

SAP Expert
Updated on 12-Mar-2020 10:29:23
You can make use of M_DISKS System View which provides information about disk configuration and utilization of the host machine.SELECT * FROM M_DISKS;

Different Engine types in SAP HANA

Updated on 30-Jul-2019 22:30:22
In SAP HANA, following engine types are available:Join Engine: This is used for attribute viewsOLAP engine: This is used for analytic viewsCalculation Engine: This is used for calculation views

Checking topology of SAP HANA

Updated on 18-Jun-2020 07:42:40
The topology of SAP HANA system is maintained by Name Server. This is used to manage all the running components and data stored in each component.

Using fact and dimension tables in SAP HANA Modeling

Updated on 30-Jul-2019 22:30:22
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

Hiding null values in a column in SAP Crystal Reports

Anil SAP Gupta
Updated on 06-Mar-2020 05:21:13
I am not sure where this formula is written. You have to write this formula in suppress part of Section Expert.To open section expert, right-click Report Header → Section Expert  click x→2 or suppressAlso, note that you can write the formula in any section where data is present in your report. Try below formulaToNumber({Choice_.Choice1}) > 0 //You have to ensure choice1 should always a numeric value else report throws exception

Using activity in SAP for number range intervals and number range objects

karthikeya Boyini
Updated on 30-Jul-2019 22:30:22
As the name indicates, activity 02 is for intervals while activity 17 is for objects. There can be a different number range interval for a given SAP number range interval.

Upgrading SAP.NET Connector 1.0 to .NET Connector 3.0

Sai Subramanyam
Updated on 30-Jul-2019 22:30:22
In .NET connector 3.0.2, it has many bugs and one of the common is connection pooling. There is .NET or higher available. You can go to SAP Marketplace and get the latest version. Try checking this link to know about .NET 3.0 −