Found 594 Articles for SAP Basis

Advantages of using Calculation View without Star Join

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

368 Views

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.

Using SAP BusinessObjects dynamic recipient

Anil SAP Gupta
Updated on 06-Mar-2020 05:28:32

474 Views

In SAP BusinessObjects, you can deliver the reports as per business requirement. It is also possible to use dynamic recipient’s option to deliver reports to users based on their requirement or split reports based on different values of a characteristic.Let us understand this with an example, let us say you have 4 specific regions in the report and you want the report to be delivered to individual Regional Manager for their respective region. You can use dynamic recipient option to make it possible.To implement this, you need to create a dynamic recipient report by developing a webi report which contains ... Read More

Consuming Attribute/Analytic view in a Calculation view in SAP HANA

John SAP
Updated on 12-Mar-2020 08:14:26

197 Views

You can use Calculation View without Star Join to consume Attribute and Analytic view in SAP HANA. To use these views, you can add Projection node and add the views to the projections.In this, you can see how to create a Calculation view without Star Join. To add Project node, you can simply drag it from the right side.

Using parallel processing in SAP HANA

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

612 Views

With the use of column based storage in HANA, data is available vertically and hence operations on different columns can be easily performed. When there is a requirement to process to process more than one column, it is processed by the different processor.

Using SAP RSECNOTE tool to display information for ABAP and Java Stack

Anil SAP Gupta
Updated on 15-Jun-2020 11:58:49

416 Views

In SAP system, you can use tools like RSECNOTE and SAP EarlyWatch Alert which can be to find out the patches and verify their implementation status. You can access RSECNOTE by executing Transaction code: SA38 or ST13.RSECNOTE tool in SAP system is used to determine which important security notes or hot notes are missing in a system.You can refer more details about this tool in SAP OSS Note 888889. You can access this tool by calling T-Code: ST13 and entering RSECNOTE and then press F8 button.888889 - Automatic checks for security notes using RSECNOTE (outdated)You use transaction ST13 to start ... Read More

How much size does the VARCHAR takes- the defined size or the size of the content in SAP HANA?

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

92 Views

I am not sure whether someone can get you exact answer, SAP is not open source and implementation details and bits are not known to many except the creators and few others. If I go with the standard definition, for storage you will require the size of length of the data plus number of bytes for header information. So as per your example it will require 9 + 2 (for header) = 11 overall for storage.

How to get some customization done in SAP HR system?

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

114 Views

I am not sure that there exists something in SAP HR in pure form which supports your use case. But you can handle the scenario as mentioned by you by making some changes here and there.There exists an infotype ‘Contracts’ with SAP HR which stores the type of employment of the employee like permanent or contract. You can take care of this type by flipping the status of the employee type by some third party service.  Once the employee resigns then rehire him as a contractor but create a dummy pay roll so that it does not gets picked up ... Read More

How to upload a big CSV file in SAP Hybrid mobile app quickly?

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

137 Views

As you said you are using the hot folder concept, you need to ensure that the proper threads are being used at every moment for any operation.By default, the number of threads used for import is one. To be more technical, impex.import.workers thread is one if not set explicitly. Since in your case the file is big, make sure that you exploit all the available cores to the fullest. It is highly recommended that maximum threads at any point of time should not be more than twice the number of cores. For optimal working, you may need to work out ... Read More

What does an InfoStore refer to in SAP BO?

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

177 Views

Basically Infostore refers to the metadata about Objects and in BO terms – infoobject. An infoobject is basically an entity in SAP business Object universe. It can be a report or a user or an event as well.For E.g.: if we are speaking about an employee so an employee has a metadata like Name, Department, Designation, Salary and others. Infostore lists out this metadata when the context in Employee. So when you execute a GET request for getting infostore it returned you the metadata for an info object.

How to perform repetitive aggregation over a field in a SAP HANA table?

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

59 Views

The logic is pretty simple. You can define a local variable which is used for storing the total sum of all the groups. When you are performing iteration for each group, you can add the sum at the group level to the local variable.I am not suggesting code as it is very basic and straightforward.

Advertisements