When you add a system under SAP HANA Studio, you can see the different folders to manage different objects. HANA Studio provides different folders that allow you to manage Database objects, Design Time Repository objects, HANA Provisioning, HANA Security to manage users and roles and Backup folder. The available options in these folders also vary as per the selected Perspectives in HANA Studio. Following are the different folders in HANA Studio −BackupCatalogContentProvisioningSecurity

SAP HANA In-Memory data read time is in Nano-seconds and in conventional database it is in Milli-seconds so it is 1 million times faster as compared to conventional database.

This can be defined in Preferences under Window tab −When you open Preferences, you have to set this value in General tab.

This can be done using the Shortcuts tab of the Customize Perspective dialog. To configure shortcuts: Switch to the perspective that you want to configure.Select  Window → Perspective → Customize Perspective →Open the Shortcuts tab and choose the sub menu whose shortcuts you want to edit.Use the Categories tree to turn groups of related shortcuts on or off, or select categories to work with individual menu items in the Shortcuts list.Click OK to cause the changes to take effect.

Yes, you can choose to hide menu items and toolbar buttons and then show them again.Switch to the perspective that you want to configure. Select Window → Perspective → Customize Perspective -> Open the Menu Visibility or Tool Bar Visibility tab.Find the item you want to hide. You can do this two ways −Expand the menu or toolbar hierarchy to find the item you want to hide.Click the Filter by command group check box to see a list of command groups which contribute items, and choose the command group the item you wish to hide. Then navigate to the item ... Read More

This dialog allows you to customize the menu items and toolbar buttons which are visible in a perspective. You can change which wizards, views and perspectives are listed in submenus, change the availability of command groups, and tweak the visibility of menu items and toolbar buttons.

To customize a perspective, right click on Perspective name → CustomizeWhen you click on Customize, it opens a new window which can be used for customization of a Perspective.

In SAP HANA Studio, you have multiple perspectives to perform different functions. When you go to Open Perspectives, you can see long list of options. It has different Perspectives to manage HANA system like −SAP HANA DevelopmentSAP HANA Administration Console (Default)SAP HANA ModelerSAP HANA PlanVizBW Modeling (SAP BW on HANA functions)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 Script

Following ports should be opened to use HANA XS Engine service −         Name                 Default                  Range                   Default                 External           Fixed          HTTP            8000      8000-8099           80NN                    Yes                    No             HTTPS                    4300         4300-4399           43NN                   Yes                           No                                                        

For Statistics server instance No: 03                         Port # 30317       Standard format: 3NN17