Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Anil SAP Gupta
Page 5 of 10
Functional difference of using row vs column store in SAP HANA
The following table explains few points about the use of row vs column store tablesTo know more about row and column store tables, refer the below link: SAP HANA is optimized for column storage.https://help.sap.com/doc/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/bd2e9b88bb571014b5b7a628fca2a132.html
Read MoreUsing SAP BusinessObjects dynamic recipient
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 MoreHiding null values in a column in SAP Crystal Reports
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 MoreDevelopment Perspective in SAP HANA Studio
You have different ABAP and Java Perspectives to perform application development and to host applications on HANA system −ABAPABAP Connectivity and IntegrationABAP ProfilingJavaJava BrowsingJava EEJava Type HierarchyJava ScriptThese perspective can be opened by navigating to, navigate to Window option at the top → Perspective → Open Perspective → Other
Read MoreSQL statement to add a table as Virtual table in SAP HANA Smart Data Access
You can use following SQL statement for this −CREATE VIRTUAL TABLE ExampleCREATE VIRTUAL TABLE ABC.test_VT AT “ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;In this SQL statement, ABC.test_VT is Virtual table name“ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;- Remote location for creating Virtual table
Read MoreDetails maintained under Name server in SAP HANA
In SAP HANA system architecture, Name server is used to maintain topology of SAP HANA system. It details complete information about system landscape- all hosts in distributed environment, active components and services running on each component in a distributed system environment.Topology details of SAP HANA system is maintained.Name server holds the detail of each component and services running on each host and hence reduces the re-indexing time.
Read MoreOnInit method is not getting called again when navigating back and forth from a view in SAPUI5
You have identified the correct use case as it is by design as you have navigated back and forth, it renders the last version rendered and OnInit() does not gets called. But if you want to override this behavior, SAP lets you do it.You can delegate to the patternMatched event of router, so that wheever the view is rendered the OnInit() method is invoked.this.getOwnerComponent().getRouter().getRoute("").attachPatternMatched(, this);You need to attach the even handler to the router in the init method of the controller. Hope it helps and sorts out your requirement.
Read MoreHow to hide and show a column of a row in SAP Detail window
You just need to set the expression which binds to the visibility propert. Go to Data window and select your desired column which you need to show/hide. Then go to properties and look out for the “Visible” checkbox and click on the highlighted button.Now write the expression which should drive its visibility. Hope it helps.
Read MoreHow to show only one view at a time in Wizard in SAP UI5?
I will say not it is not a big out of box requirement. You can easily get it done. What you need to do is to hook up your requirement in the complete event of the wizard which gets invoked on each step completion. You just need to hide the completed view and show the next view. So you will be viewing only one view at a time.onComplete: function(oEvent) { var wdStep = oEvent.getSource(); wdStep.setVisible(false); }
Read MoreNot able to call another function within initialize method of controller in SAP UI5.
Yes, you are absolutely correct. It is very basic thing, you just need to use this operator for making the function call.onInit: function() { //Your logic this.CustomFunction(); } CustomFunction : function () { // some logic }
Read More