SAP Articles

Page 50 of 91

Checking Compression ratio of a table in SAP HANA

SAP Expert
SAP Expert
Updated on 06-Mar-2020 1K+ Views

To check the Compression ratio for a table, you can navigate to Table Definition. Go to Runtime Information.To see Compression Ratio, go to Columns tab. You can see the compression ratio in the Main Size Compression Ratio [%] column.

Read More

Checking data disk, log disk and Trace disk in SAP HANA

SAP Expert
SAP Expert
Updated on 06-Mar-2020 648 Views

In SAP HANA Studio, you can use System Monitor to view details of your SAP HANA system at a glance. It tells about Data Disk, Log disk, Trace Disk, Alerts on resource usage with priority.To open System Monitor, select HANA system in System pane and click on the icon as shown below −Once you scroll on the right side, you can see all the information of your HANA system as you mentioned including CPU% and used memory.

Read More

Using SAP BusinessObjects dynamic recipient

Anil SAP Gupta
Anil SAP Gupta
Updated on 06-Mar-2020 928 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 Graphical calculation view via SDA

SAP Expert
SAP Expert
Updated on 06-Mar-2020 376 Views

Note that you can create Graphical Calculation Views using SMART Data access tables and you can also push aggregations to remote database.

Read More

Count distinct entries in SAP BusinessObjects

John SAP
John SAP
Updated on 06-Mar-2020 788 Views

Your requirement is not clear but I think you should use AND operator and count on this in the third column. Your formula should be like this=([First_Seen] = 1) and ([Authorized] = 1)Consuming Graphical calculation view via SDA

Read More

Getting error while running SAP oData service "HTTP Open failed: PLUGIN_NOT_ACTIVE

SAP ABAP Expert
SAP ABAP Expert
Updated on 06-Mar-2020 1K+ Views

To fix this, you need to run T-Code: SMICM and this will open ICM Monitor Service Display. You need to maintain port number 80000 for HTTP in SMICM.

Read More

Hiding null values in a column in SAP Crystal Reports

Anil SAP Gupta
Anil SAP Gupta
Updated on 06-Mar-2020 475 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

In SAP Business One, making HTTP request with SOAP body

SAP Developer
SAP Developer
Updated on 06-Mar-2020 490 Views

You can use web services wrapper provided by SAP which allow programmer to use the services provided by DIS. To perform an easy integration, it is possible to use SoapUI in open source version. The connection is performed using login service and with reference of its wsdl, login request can be created and XML definition of message san be seen.                        192.168.90.118          DB_TestConnection          dst_MSSQL2008          manager          Kuldip          ln_English          192.168.90.118:30000           To connect SAP Business One to a program, there are various options that you can try. For more details you can refer this link −https://blogs.sap.com/2014/07/28/connecting-an-add-on-to-sap-business-one/

Read More

Exporting delivery unit based on time filter in SAP HANA

John SAP
John SAP
Updated on 04-Mar-2020 255 Views

While export a delivery unit, you can restrict the export through “Filter by time” which means Information views, which are updated within the mentioned time interval will only be exported.After selecting Delivery unit from drop down list, you have to select checkbox and then enter the Time interval- From and To date.In below snapshot you can see we have highlighted “Filter by Time” option and user can select this checkbox to use time filter during export.

Read More
Showing 491–500 of 902 articles
« Prev 1 48 49 50 51 52 91 Next »
Advertisements