SAP HANA studio is the interface between HANA database and reporting layer. It is the area where we degin our muti dimentional models (ex: based on start schema – where we have fact table and dimention tables).
SAP HANA studio consists of several applications. It is also called as Perspectives (It means to see from different angle).
Currently we have four perspectives Read more
Transaction Code (TCODE) Description (TTEXT)
/SAPDMC/LSMW LSM Workbench: Initial Screen
/SAPTRX/ASAPLOG Appl. system log for event handling
/SAPTRX/ASC0AO Define App. Object and Event Types
/SAPTRX/ASC0AP Define application parameters
/SAPTRX/ASC0SCU Assign Scenario to Users
/SAPTRX/ASC0SD1 Define Solution / Scenario
/SAPTRX/ASC0SD2 Define Solution / Scenario Read more
SAP IMC Studio (In-Memory Computing studio) Authorizations
SAP In-Memory Computing studio is also used for user provisioning. It allows you to create users, roles, role hierarchy and more. There are 3 Types of privileges you can create in SAP In-Memory Computing studio.
1. System privileges Read more
SAP HANA provides various interface reporting options
ODBO – (OLE DB for OLAP)
Requests are sent to the database via MDX (MultiDimensional eXpression language). Multidimensional reporting is available via Excel Pivot Tables. HANA ODBO drivers is available via the Other/Advanced option of the Data Connection Wizard.
ODBC – (Open DataBase Connectivity)
Requests are sent to the database via SQL (Structured Query Language). In early testing, Excel was *not* a good choice
for ODBC-based reporting since ODBC reporting is based
on MSQuery which has a limitation of 4,000 tables.
JDBC – (Java DataBase Connectivity)
Popular on Unix platforms Read more
In SAP HANA we have 2 types of Hierarchy
1. Level Hierarchy
It’s rigid in nature, where the root and the child nodes can be accessed only in the defined order (ex: organizational sturctures)
To define a level hierarchy we need one attribute per hierarchy level.
2. Parent/Child Hierarchy
The hierarchy can be explored based on a selected parent, and there are cases where the child can be a parent. Read more
SAP In-Memory database requires the replication of data from a source system. There are three methods of data replication from source system to SAP IMDB.
If your source is ERP system then SAP recomments using SAP Landscape Transformation (SLT) Replcator. Source can also be non-SAP system. As name suggests it updates HANA system using database triggers.
While connecting to SAP source system Replication Server uses remote function call (RFC) network communication channels and for non-SAP source system it uses database connection. SAP HANA system and SAP LT Replication Server uses database connection for communication. Read more
In order to connect to SAP HANA database BI provides 2 types of connection drivers (ODBC and JDBC). You must first create relational connection using one of the driver. Once the connection is created and tested then you can use it to build the data foundation for your universe. Read more
Profitability Analysis (CO-PA)
It provides two forms of analysis. Costing based and Accont based and you can use both of these types simultaneously.
Operating Concern : It’s a multidimentional data structure for Profitability Analysis (product group, customer and region) Read more
Customer Testimonials and Executive Sessions.
As per ebook 27 Fortune 500 customers has implemented SAP HANA and seems they are happy with the results.
SAP HANA in Action – Customer ebook