Found 694 Articles for SAP HANA

In an Audit policy, you can define different audit levels in SAP HANA −EMERGENCYCRITICALALERTWARNINGINFO

In SAP HANA system, following audit trail targets are possible −Syslog (default) − Logging system of Linux Operating System.Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.CSV text − This type of audit trail is only used for test purpose in a non-production environment.

Choose SAP HANA MDX Provider from this list to connect to any MDX data source → Enter HANA system details (server name, instance, user name and password) and you need to click on Test Connection → Connection succeeded → OKIt will give you the list of all packages in drop down list that are available in HANA system. You can choose an Information view → click Next → Select Pivot table/others → OK.

SAP HANA Data Modeling feature allows you to create complex BI reports in real time and it can be easily integrated with different BI tools- Business Objects, Crystal Report, SAP Lumira and non-SAP tools like Microsoft Excel with use of MDX client as shown below.

SAP HANA product is written in C++ and JAVA and runs on Linux platform. Linux Operating System on which SAP HANA runs- SUSE LINUX 11.

When you are managing a large number of systems using HANA Studio, this can be used to find a specific system more quickly.To use find system option, the following steps should be performed −From the Systems view toolbar, choose the Find System (Find System) button.2. Enter a search string −You can also use “*” or “?” wildcards.It will display matching systemsSelect the system you were searching for.You can select several systems in the search results by pressing the CTRL key while selecting. You can use this, for example, to mark duplicate systems.Choose whether you want to open the selected system ... Read More

Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h  Host name-n  Instance number-u  User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux OShdbstudio -h hana -n 03 –u HANAADMINhdbstudio -h hana -n 03 -u "&hana"Mac OSopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u HANAADMINopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u "&hana"Once you run above from command line, this will open HANA Studio. If you are prompted to enter password ... Read More

Following tabs are available under SAP HANA Administration Console −OverviewLandscapeAlertsPerformanceVolumesConfigurationSystem InformationDiagnosis FilesTrace Configuration

You can drop a view using Drop command like we drop a table. You can perform all the operations that you perform on a table on the database view.Drop view "AA_HANA11"."DEMO_TEST";

You can alter the view, then we can use the Alter View command to alter the view.ExampleAlter view View_EmpInfo  as Select Emp_Details.Id, Emp_Details.EmplName, EmpProj.Projname from Emp_Details inner join EmpProjInfo on Emp_Details.Id=EmpProjInfo.Id;We have applied ALTER command to update an existing view with name- View_EmpInfo which is applying Inner Join on two tables on Id column to create a database view.