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
-
Economics & Finance
SAP Basis Articles
Page 36 of 50
Difference between _SYS_BIC and _SYS_BI schema in SAP HANA
_SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository. When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in database.These column views are used by front-end tools like BusinessObjects to get the data in a query._SYS_BI:This schema in HANA system stores table created for variables, time dimension- Gregorian, Fiscal and schema and content mapping tables.
Read MoreSteps in installing SAP HANA Studio
SAP HANA studio runs on the Eclipse platform 3.6. To install SAP HANA Studio, it is two-step process.First to install Eclipse as per Operating SystemSecond is to install HANA software plugin in Eclipse
Read MoreInstalling SAP HANA software plugins for Eclipse
Once Eclipse installation is done, open software and Navigate to Help → Install New SoftwareWhen you click on Install New Software, a new window will open and you can perform HANA plugin installation.
Read MoreNavigation in SAP HANA Studio client
When you login to SAP HANA Studio first time, it doesn’t have any system added to it. You can add multiple local/remote HANA systems to Studio and manage them.On left side, you have system pane where you can add multiple systems in Studio. When you add a system in HANA Studio, it consists of different folders. Each folder in HANA system performs different functions. We will cover the details later in this tutorial. At bottom you have Properties pane and Job Log pane. In Job Log pane you can check the status of each action that you perform in HANA ...
Read MoreSAP HANA Modeling Perspective in HANA Studio
On right side you have Modeling Perspectives, under which you can see multiple options inside it. In SAP HANA Studio you have the options to access different perspectives that can be used to perform variety of different functions.You can see HANA Modeler Perspective in below pic −You can also perform a search on different options in Perspective by typing in search bar below Quick View.
Read MoreConfiguring SAP HANA Perspective shortcuts
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.
Read MoreTCP/IP port in SAP HANA to access Index server
For Index Server Instance No: 03Port # 30315Standard format: 3NN15 These port numbers are used for index server for SQL/MDX access port for standard database access. You should enable the access on these ports for all database clients. By default Index server Port no is 30015.The standard port number format for different instances 3NN15, NN- represents the instance number of HANA system to be used in client tools.Port 3615 should be open to connect to DatabasePort 31015 Instance No 10Port 30015 Instance No 00SSh port should also be opened.
Read MoreMultiple perspectives to perform different functions in SAP HANA
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
Read MoreCustomizing SAP HANA Perspective in HANA Studio
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.
Read MoreShowing and hiding menu items in SAP HANA Studio Perspective
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