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
SAP Basis Articles
Page 15 of 50
Getting MIN and MAX dates in table in SAP Web Intelligence while using a Break
This can be achieved by creating an Indicator as per condition you are looking for- minimum drawn date time for POST-Test and Maximum drawn date time for PRE-Test. Once you create this indicator, it will show “Y” for the rows highlighted in yellow as per condition and “N” for other rows.=If ([Drawn date] = Min([Drawn date]) In ([Patient ABO/RN]) Where ([PrePost] = "POST") ) Or ([Drawn date] = Max([Drawn date]) In ([Patient ABO/RN]) Where ([PrePost] = "PRE") ) Then "Y" Else "N"You need to apply a filter for rows with indicator value- “Y”.Other option is you can create 3 variables as ...
Read MoreActivating an Attribute view in SAP HANA
This can be checked by looking at view name in a package. If there is a Grey diamond mark on the name it means View is not activated.
Read MoreDefining a primary key in an Attribute view in SAP HANA
This can be done by selecting column name from the list of columns under Output pane.
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 MoreDifferent schema types in SAP HANA database
In SAP HANA database, there are 3 types of schema −User Defined Schema: These schemas are created by database users or administrators. All the schemas under Catalog tab except from System defined and SLT derived schemas are user defined schemas.System Defined Schema: These are generated as result of using HANA related functions. These are of following types −_SYS_BI_SYS_BIC_SYS_REPO_SYS_STATISTICS_SYS_XS-ENGINESLT Derived Schema: These schema are generated as part of SLT Data replication in HANA.
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 MoreMaximum Table name length in SAP HANA
Maximum table name length supported in SAP HANA is 127 characters.
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 More