Anil SAP Gupta has Published 115 Articles

Hiding null values in a column in SAP Crystal Reports

Anil SAP Gupta

Anil SAP Gupta

Updated on 06-Mar-2020 05:21:13

300 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 ... Read More

Use of SQL/MDX processor in SAP HANA Index server

Anil SAP Gupta

Anil SAP Gupta

Updated on 27-Feb-2020 10:45:44

287 Views

SQL/MDX processor in HANA system processes all SQL and MDX statements executed in HANA system. SQL statements are generated for all the tables, schemas and MDX statements are raised for OLAP data processing. SQL stands for Structured Query Language and is Relational database language to manage two dimensional objects in ... Read More

Different Engine types in SAP HANA Architecture

Anil SAP Gupta

Anil SAP Gupta

Updated on 27-Feb-2020 10:43:28

776 Views

In SAP HANA system, there are three basic engines used to processes queries in SAP HANA. Following engines are used −Join EngineOLAP EngineCalculation EngineJoin EngineUsed when querying an Attribute View in SAP HANAOLAP EngineAnalytic Views (without derived columns) use the OLAP EngineCalculation EngineCalculation Views or Analytic Views with derived columns ... Read More

Development Perspective in SAP HANA Studio

Anil SAP Gupta

Anil SAP Gupta

Updated on 21-Feb-2020 10:33:08

375 Views

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

SQL statement to add a table as Virtual table in SAP HANA Smart Data Access

Anil SAP Gupta

Anil SAP Gupta

Updated on 21-Feb-2020 10:29:56

769 Views

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

Maintaining topology details of SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 21-Feb-2020 10:08:25

338 Views

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.You can check service start time, memory used, CPU used, ... Read More

Details maintained under Name server in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 21-Feb-2020 10:06:46

344 Views

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 ... Read More

OnInit method is not getting called again when navigating back and forth from a view in SAPUI5

Anil SAP Gupta

Anil SAP Gupta

Updated on 17-Feb-2020 12:39:18

528 Views

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 ... Read More

How to hide and show a column of a row in SAP Detail window

Anil SAP Gupta

Anil SAP Gupta

Updated on 17-Feb-2020 12:37:46

452 Views

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 ... Read More

How to show only one view at a time in Wizard in SAP UI5?

Anil SAP Gupta

Anil SAP Gupta

Updated on 17-Feb-2020 12:35:22

250 Views

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 ... Read More

Previous 1 ... 4 5 6 7 8 ... 12 Next
Advertisements