Anil SAP Gupta has Published 115 Articles

Adding columns to output in an Attribute view in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 11:37:57

479 Views

This can be done in 2 waysYou can directly click on round circle in front of the column name in Details PaneYou can add a column to output by right click on the column and select → Add to OutputWhen you add a column to output pane, it is added ... Read More

Defining a primary key in an Attribute view in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 11:35:49

392 Views

This can be done by selecting column name from the list of columns under Output pane.

Learning SAP HANA Modeling and Administration

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 11:11:54

148 Views

There are various tutorials that you can follow and you can get a fair idea about SAP HANA Concepts. We have various text and video tutorials published free on our website which is developed by experts. You can easily follow them as they provide step by step documentation for all ... Read More

Checking configuration of XS service in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 11:06:32

268 Views

This can be checked under Configuration tab in HANA Administration. You need to scroll down and there you can check details under xsengine.ini

Use of SAP HANA Live browser

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 10:58:20

129 Views

With the use of SAP HANA Live Browser, you can easily browse and tag SAP HANA content views and they can be easily consumed SAP Lumira or SAP BusinessObjects (BOBJ) Analysis to analyze the data. This is based on SAP UI5 Web-based application.

Tables for generated Time data in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 10:50:47

482 Views

The following table contains generated time data in HANAM_TIME_DIMENSIONM_TIME_DIMENSION_WEEKM_TIME_DIMENSION_MONTHM_TIME_DIMENSION_YEARThese tables are represented in schema _SYS_BI

Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 10:40:32

196 Views

The following information is available under SAP HANA M_BLOCKED_TRANSACTIONS System View

Checking System limits in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 12-Mar-2020 10:26:47

312 Views

M_SYSTEM_LIMITS is a view to getting SAP HANA system limits. You can query this view to find the limitations of HANA system −SELECT * FROM M_SYSTEM_LIMITS;It will provide you details about Database Limitation Schema Limitations Tables and View Limitation Indexes and Constraints SQL SQL Script

Functional difference of using row vs column store in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 06-Mar-2020 06:11:52

156 Views

The following table explains few points about the use of row vs column store tablesTo know more about row and column store tables, refer the below link: SAP HANA is optimized for column storage.https://help.sap.com/doc/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/bd2e9b88bb571014b5b7a628fca2a132.htmlRead More

Using SAP BusinessObjects dynamic recipient

Anil SAP Gupta

Anil SAP Gupta

Updated on 06-Mar-2020 05:28:32

416 Views

In SAP BusinessObjects, you can deliver the reports as per business requirement. It is also possible to use dynamic recipient’s option to deliver reports to users based on their requirement or split reports based on different values of a characteristic.Let us understand this with an example, let us say you ... Read More

Previous 1 ... 3 4 5 6 7 ... 12 Next
Advertisements