SAP Testing Articles

Page 2 of 2

Disk utilization and configuration details view in SAP HANA

SAP Expert
SAP Expert
Updated on 12-Mar-2020 373 Views

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;

Read More

Hiding null values in a column in SAP Crystal Reports

Anil SAP Gupta
Anil SAP Gupta
Updated on 06-Mar-2020 481 Views

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

Read More

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

karthikeya Boyini
karthikeya Boyini
Updated on 30-Jul-2019 176 Views

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.

Read More

Using fact and dimension tables in SAP HANA Modeling

SAP ABAP Expert
SAP ABAP Expert
Updated on 30-Jul-2019 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

Different Engine types in SAP HANA

SAP ABAP Expert
SAP ABAP Expert
Updated on 30-Jul-2019 749 Views

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

Read More
Showing 11–15 of 15 articles
« Prev 1 2 Next »
Advertisements