SAP Developer has Published 85 Answers

Use of different files in SAP HANA Cockpit for offline administration

SAP Developer

SAP Developer

Updated on 19-Jun-2020 14:25:31

Start, Restart, Stop System Operations: To perform start/stop/restart of HANA systemDiagnosis Files: This is used to access log, trace and other diagnosis files.Troubleshoot Unresponsive System: You can use this to trigger the collection of transactional information and displays this information for troubleshooting performance issues.SAP HANA Documentation - SAP HANA Offline ... Read More

Advantages of using Calculation View without Star Join

SAP Developer

SAP Developer

Updated on 18-Jun-2020 09:45:10

When you use Calculation view with Star Join, you have the following benefits:It simplifies the design process.You need not create Analytical views and Attribute Views and directly Fact tables can be used as Projections.3NF is possible with Star Join.

Advantages of using Column based tables in SAP HANA

SAP Developer

SAP Developer

Updated on 18-Jun-2020 09:41:12

In a Column store table, Data is stored vertically. So, similar data types come together as shown in the example above. It provides faster memory read and writes operations with help of In-Memory Computing Engine.In a conventional database, data is stored in Row based structure i.e. horizontally. SAP HANA stores ... Read More

Applying Variable on calculated column in SAP HANA Modeling view

SAP Developer

SAP Developer

Updated on 18-Jun-2020 09:35:40

Yes, you can set a variable on top of “Calculated column”. In the bottom box, you need to select the column on which you want to set a Variable.Click on Add and from the drop-down, you can select “Calculated column” as below:

Using Analytic View in SAP HANA

SAP Developer

SAP Developer

Updated on 18-Jun-2020 09:21:55

You are correct. In SAP HANA, Analytic Views are used to implement Star Schema queries wherein we join one Fact table to multiple Dimension tables. Analytic views use the real power of SAP HANA to performcomplex calculations and aggregate functions by joining tables in form of star schema and by ... Read More

Performance Analysis of an Attribute view in SAP HANA

SAP Developer

SAP Developer

Updated on 18-Jun-2020 08:59:49

In SAP HANA Modeling, you have an option of switching to Performance Analysis mode. This is used to check if Joins in Attribute view are meeting with performance optimized joins and cardinality based on data in the table.You can see 2 options when you select Performance Analysis mode:Join Details:This defines ... Read More

Using Time subtype of an attribute view in SAP HANA

SAP Developer

SAP Developer

Updated on 18-Jun-2020 08:45:52

Time subtype Attribute View is a special type of Attribute view that adds a Time Dimension to Data Foundation. To know more about the difference between Standard Attribute view and Time Attribute view, you can refer this SAP thread:https://archive.sap.com/discussions/thread/3253551

Adding a package to Delivery unit in SAP HANA

SAP Developer

SAP Developer

Updated on 18-Jun-2020 08:33:50

In SAP HANA, Delivery unit is known as single unit, which can be mapped to multiple packages and can be exported as a single entity so that all the packages assigned to Delivery Unit can be treated as a single unit.Delivery units can be used to export all the packages ... Read More

Checking performance of SAP HANA system

SAP Developer

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

SAP HANA row and column store table

SAP Developer

SAP Developer

Updated on 18-Jun-2020 07:24:39

SAP HANA Modeler Views can only be created on the top of Column based tables. Storing data in Column tables is not a new thing. Earlier it was assumed that storing data in Columnar based structure takes more memory size and not performance Optimized.With the evolution of SAP HANA, HANA ... Read More

1 2 3 4 5 6 7 ... 9 Next
Advertisements