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. You have to enter work with URL for SAP HANA tools.Enter the URL as per Eclipse Mars4.5 https://tools.hana.ondemand.com/marsEnter the URL as per Eclipse Luna 4.4 https://tools.hana.ondemand.com/lunaWhen you enter URL and press ENTER key, it will display all the software installation options under Eclipse for these URL’s. You can also select different options: Show only the Latest version etc.When you want to use SAP HANA cloud platform tools, you can also select this check box. ... 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.

You can install Eclipse Mars or Eclipse Lunar from Eclipse.Org site. Follow this link for the installation and select Operating System type-http://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/marsr

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

When you have to run an OLTP query just to display the specific records, In row based storage, when you run a Select statement all the different datatypes come together so it will be much faster to run a SELECT statement in Row based storage.Select * from FCT_SALES where Country=’US’;When the same query is run in column based storage, you need to find the values of each column in database and it is time consuming so it is not recommended to create a column based storage tables when your queries are not aggregated and required to run simple SELECT statement.Read More

In a general scenario, it is advisable to store the table as Column store when you have to run complex OLAP queries. OLAP queries include complex calculations and different SQL aggregation functions are used in the query.Select Sum(Sales) from table_name where Column1=’ABC’; Aggregate Functions include −Sum() - returns the sum of the numeric values in a given columnMax() - returns the maximum of the numeric values in a given columnMin() - returns the minimum of the numeric values in a given columnAverage() - returns the average of the numeric values in a given columnPercent() - returns the percentage of the numeric ... Read More