While export a delivery unit, you can restrict the export through “Filter by time” which means Information views, which are updated within the mentioned time interval will only be exported.After selecting Delivery unit from drop down list, you have to select checkbox and then enter the Time interval- From and ... Read More

The cross database container access is managed in Global.ini file in Configuration under System Administration.To access global.ini file you need to navigate to Administration tab in HANA Studio → Configuration and there you can find Global.ini file.

Note that you need to check table under schema name under which it is created. You can confirm schema name on top of SQL editor.In below snapshot, you can Current Schema: AA_HANA11.To check if table is created, go to schema name under Catalog folder → Tables and search for the ... Read More

To check table definition, you need to right click on table name → Open Definition and this will open table structure under HANA database.

In SAP HANA Studio, Content folder contains all the design time repository objects. In this folder, all objects created in HANA system are managed under packages. To create a new object, you have to first select a Package.In a package you have different HANA Modeling Views- Attribute Views, Analytic Views, ... Read More

Following objects are available in a Package under Content tab in HANA system −Attribute ViewsAnalytic ViewsCalculation ViewsAnalytic PrivilegeStored ProceduresSub-PackagesDecision Tables

_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 ... Read More

In SAP HANA system _SYS_REPO user is required to create run time objects that are saved in HANA database under _SYS_BIC schema. When you activate modeling views in HANA, SYS REPO provides the read access to users on these modeling views. That is why it is required to grant _SYS_REPO ... Read More

Select the system that you want to access as Remote Data Source and enter the authentication details. You have to enter the Connection Properties and Credentials for remote system.On right hand side, you have option to Test the Connection or you can also run to create the data source.Read More

You can also create a remote source using SQL statement as below −CREATE REMOTE SOURCE Source_Name ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral_DSN_Name’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In this SQL statement- can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.In ... Read More