SAP Basis Articles - Page 17 of 50

To access HANA system on client tools, you need to open different ports to database for these clients. These ports refer to different servers and application service in HANA system.

You can add multiple local/remote HANA systems in HANA Studio. To add a system, you have to open HANA Studio from Program Files.Once you open HANA Studio, go to system pane on right side → Right click and select Add System. You can also add SAP HANA Cloud system or a new folder in system pane.When you create a folder, it allows you to add HANA system, cloud system or a new folder inside it. This folder option can be used to create hierarchies when you have multiple systems to manage in a distributed environment.When you click on Add System, ... Read More

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.

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 More

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.

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

SAP HANA studio client is available to run on variety of platforms. Following Operating systems can be used to run HANA Studio client tool:Microsoft Windows x32 & x64 versions with availability for −Windows XPWindows VistaWindows 7Windows 8SUSE Linux Enterprise Server SLES 11: x86 64-bit versionRed Hat Enterprise Linux (RHEL) 6.5Mac OS 10.9 or higher

You can install SAP HANA studio on Linux platform without Root user. In Windows platform, you can perform the installation without administration rights but it will be available only to the user who has installed it.Default Location on Window Platform: C:\Program Files\sap\hdbstudioDefault installation Location under MAC OS: /Applications/sap/hdbstudio (old) or  /Applications/sap/hdbstudio.app (new)Default installation Linux x86 64 bit: /usr/sap/hdbstudio

In SAP HANA, Data modeling can only be performed on Column store tables. You can’t select Row store tables while create data modeling views on top of HANA database. In below pic, you can see it only shows all column store tables to add in Data Foundation layer of a Modeling view.

When you have to run an OLAP query that perform sum of Sales in table with where clause in Country=’US’.Select Sum(Sales) from FCT_SALES where Country=’US’; It storage type is a column based storage in memory cells all the values for Sales will come together in database and when an aggregation ‘Sum’ is performed it will be much faster as compared to an OLTP query.If table is row based storage with values are stored with different data types coming together and a ‘Sum’ aggregation is performed, it will too tough to find values for ‘Sales’ column.In graph, column based tables show the ... Read More