Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by SAP Expert
Page 6 of 12
Different database objects inside Catalog folder in SAP HANA Studio
It includes −Column ViewsEPM ModelsEMP Query SourceFunctionsIndexesProceduresSequencesSynonymsTablesTriggersViews
Read MoreGetting statistics details of SAP HANA system
_SYS_STATISTICS- This schema stores all system configuration and parameter details of HANA system.You can find this under Catalog folder in HANA Studio once you select relevant HANA system in System pane.
Read MoreUse of _SYS_BI schema in SAP HANA
Both the schema are system defined schemas. _SYS_BI schema is used to store all the metadata of created column Views.It is different from _SYS_BIC and _SYS_REPO schema and you can understand this from below −SYS_BI − This schema stores all the metadata of created column Views._SYS_BIC − Whenever you activate any HANA Modeling view, it is stored under _SYS_BIC System defined schema._SYS_REPO − Whatever the objects are there in the system is available in repository. This is used to create required run time objects.
Read MoreUse of _SYS_BIC schema in SAP HANA
When we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. _SYS_BIC schema stores all the columns views of activated objects.When the user activates the Attribute View/Analytic View/Calculation View/Analytic Privilege /Procedure, the respective run-time objects are created under _SYS_BIC/ Column Views.
Read MoreDisk utilization and configuration details view in SAP HANA
You can make use of M_DISKS System View which provides information about disk configuration and utilization of the host machine.SELECT * FROM M_DISKS;
Read MoreMaximum Column name length in SAP HANA
Maximum column name length supported in a table in SAP HANA is 127 chars.
Read MoreMaximum table count in a schema in SAP HANA
In SAP HANA, a maximum number of tables in a schema are 131072. To create a table, you have to right click on Schema name → New Table
Read MoreUsing an Analytic Privilege for specific time in SAP HANA
Yes, when an Analytic Privilege is defined you have an option of using it for a specific time period. You have an option of defining Privilege validity where you can pass validity details.You can also opt for SQL Editor or Dynamic where you can pass different validity conditions. When you use SQL option you can pass a SQL query and it will be set as per SQL queryFor Dynamic option, you can pass Stored Procedure to define validity.
Read MoreUsing different Projection options in Calculation view in SAP HANA
When you set data category as CUBE, the default node is aggregation. When you set data category as Dimension, default node is Projection.You can change the Default node by selecting Star Join checkbox.When you finish selection for data category, you get a default node under Scenario pane. Check the below snapshot:
Read More