SAP HANA Dynamic Tiering (Extended Tables)
The concept name was not provided, so a precise definition cannot be written. Based on the available sources, the tutorials collectively cover SAP HANA topics such as dynamic tiering, system replication, SQL views, and query plan analysis — but without a specific concept to define, no accurate, source-grounded prose definition can be produced. Please supply the concept name so a proper definition can be written.
Tutorials that teach this
- Tutorial Reviewing Available Backups
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Additional checks in SAP HANA Cockpit and SAP HANA Studio
- Tutorial Create Tables and Import Data
- Tutorial Performing a Failback
- Tutorial Compare Prepared and Executed Plan
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Setting Up SAP HANA System Replication with HANA Studio
- Tutorial Convert Between an In-Memory Table and an Extended Table
- Tutorial Converting Between an In-Memory Table and an Extended Table
- Tutorial Managing Backup Files
- Tutorial Disable SAP HANA System Replication
- Tutorial Stopping and Restarting the Extended Storage Service
- Tutorial Adding Our Union Calculation View into the Converted Data Model
- Tutorial Migrate Records in Related Tables Using Stored Procedures
- Tutorial Detailed Query Plan and Indexes
- Tutorial Visualize a Graphical Query Plan
- Tutorial Enlarging a Dbspace File Using Reserved Space
- Tutorial Initializing Database Backup and Recovery
- Tutorial Creating and Removing Extended Storage
- Tutorial Create Tables and Import Data
- Tutorial Creating and Recovering Delta Backups
- Tutorial Create a New User and Assign Permissions
- Tutorial Migrate Records in Related Tables Using Stored Procedure
- Tutorial Creating Database Backups
- Tutorial Create Multi-Store Tables
- Tutorial Create Extended Storage
- Tutorial Dropping a Dbspace File
- Tutorial Importing Required Calculation Views
- Tutorial Adding a Dbspace File
- Tutorial Create Extended Storage
- Tutorial Creating a Calculation View from the Union of In-Memory and Extended Tables
- Tutorial Table Statistics and its Effect on Query Plans
- Tutorial Selectively Move Data Between In-Memory and Extended Tables
- Tutorial Multi-Store Tables
- Tutorial Monitoring SAP HANA Using SAP HANA Cockpit and SAP HANA Studio for SAP HANA Dynamic Tiering
- Tutorial Seeing Calculation View Results
- Tutorial Create a New User and Assign Permissions
Prerequisites
- Concept SAP HANA Modeler Perspective in SAP HANA Studio The concept name provided is **undefined**, and the supplied source snippets do not contain sufficient information to construct a grounded, accurate definition for a specific SAP developer concept. Please provide a valid concept name and relevant source snippets so a precise definition can be written.
- Concept SAP HANA Calculation Views A **Calculation View** is a type of SAP HANA data model that allows developers to define complex analytical queries by combining and transforming data from multiple sources, such as tables or other views. Developers use Calculation Views to expose business logic and aggregated data for reporting and analytics, supporting types such as [Dimension and Cube](https://developers.sap.com/tutorials/hana-cloud-calculation-view-cube.html). They can be created graphically in the SAP HANA Modeler perspective and consumed by applications or services, including CAP-based projects and Hibernate-based apps running on SAP HANA.
- Concept SAP HANA In-Memory Relational Database The concept name was not provided (marked as "undefined"), and the available source snippets do not contain sufficient detail to construct a grounded, accurate reference definition. Only one source ([S1]) references a relevant topic — setting up database artifacts using SAP HANA — but without a named concept to define, a precise and accurate definition cannot be written per the documentation guidelines.
- Concept SAP Web IDE for SAP HANA The concept name provided is "undefined," which does not correspond to a identifiable SAP developer concept. Based on the available sources — which cover former SAP development environments such as [SAP Web IDE](https://ui5.sap.com/#/topic/d3f5ad2ec52b4ed0b5a272c1ce52a6f3), SAP HANA XS Advanced, and related tutorials — no definition can be accurately constructed for a concept labeled "undefined." Please provide a valid concept name so that a precise, source-grounded definition can be written.
- Concept Union Node in SAP HANA Calculation Views A **Union Calculation View** in SAP HANA is a type of calculation view that combines rows from two or more data sources — such as in-memory and extended (data lake) tables — into a single unified result set. Developers use it to merge datasets that share the same structure, enabling queries to span across different storage tiers or data models transparently. It can also be incorporated into broader data models, as shown in [Adding Our Union Calculation View into the Converted Data Model](https://developers.sap.com), to serve as a reusable building block within more complex analytical scenarios.
- Concept SAP HANA Architecture and Internals
- Concept SAP HANA Cloud fundamentals The concept name was not provided, and the available source snippets do not contain enough detail to define a specific SAP developer concept with accuracy. The sources reference topics such as [setting up database artifacts](https://help.sap.com/docs/btp/sap-business-technology-platform/3cd69547217949e098fb4f2a88aa6d33?locale=en-US&state=PRODUCTION&version=Cloud) in SAP HANA, connecting via JDBC, spatial data visualization, and migrating to SAP HANA Cloud, but no specific concept name or substantive explanatory content was supplied to ground a precise definition.
- Concept SAP HANA Security and User Management The concept name provided is "undefined," and the supplied source snippets do not contain enough substantive content to ground a meaningful, accurate definition. A valid concept name and supporting source material are required to produce a reliable reference definition.
- Concept SAP HANA Cockpit Administration The concept name is missing or undefined, and the provided sources do not contain enough grounded information to produce a reliable definition without risking unsupported claims. Please provide a valid concept name so that a precise, source-grounded definition can be written.
- Concept SAP HANA In-Memory Platform Fundamentals
- Concept SAP HANA database management The provided sources do not contain sufficient information to write a grounded definition for an undefined concept. No concept name or relevant descriptive content is available from the given snippets to produce an accurate and sourced reference definition.
- Concept SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY) The concept name was not provided, so a precise definition cannot be generated. Please supply a valid concept name along with supporting source snippets so that an accurate, grounded definition can be written.
- Concept SAP HANA Information Views (Attribute, Analytic, Calculation) The concept name was not provided (marked as "undefined"), and the supplied source snippets do not contain enough extractable detail to ground a precise, factual definition. A reliable definition cannot be written without a clearly identified concept and supporting source content.
- Concept HANA Column Store and Row Store Tables The provided sources do not contain sufficient information to write a grounded definition for an **undefined** concept. Please supply a valid concept name and relevant source snippets so an accurate, source-grounded definition can be produced.
- Concept SAP HANA Information View Conversion to Calculation Views The concept name is not defined in the provided sources, and no factual claims about it can be grounded in the available snippets. The sources only reference tutorials on importing calculation views and converting information views, neither of which defines or describes an "undefined" concept.
- Concept SAP HANA Database Administration The concept provided is **undefined**, and the supplied sources do not contain sufficient information to produce a grounded definition. Please provide a valid SAP developer concept name so an accurate and source-supported definition can be written.
Concepts that build on this
- Concept Data Volume Management
- Concept Foreign Key Constraints and Referential Integrity
- Concept SAP HANA Cockpit POST API Usage
- Concept Extended Storage Dbspace Creation and Removal
- Concept SAP HANA Cockpit Administration
- Concept CSV Sample Data Loading
- Concept SAP HANA Dynamic Tiering Recovery
- Concept SAP HANA Smart Data Access (SDA)
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept Stored Procedure for Data Migration
- Concept SAP Web IDE for SAP HANA
- Concept PlanViz (PLV) File Analysis
- Concept SQL UNION ALL for Combining Result Sets
- Concept CSV Bulk Data Import and Batch Processing
- Concept SQL CREATE VIEW Statement
- Concept SAP HANA System Replication Takeover
- Concept SAP HANA Dynamic Tiering Query Plan Analysis and Index Creation
- Concept SAP HANA High Availability and Disaster Recovery
- Concept SQL Explain Plan for Query Execution Analysis
- Concept Selective Data Migration Between In-Memory and Extended Storage
- Concept SAP HANA Calculation Views
- Concept Table Statistics Creation in SAP HANA Dynamic Tiering
- Concept SAP HANA Monitoring Views (M_ prefix)
- Concept SAP HANA Multi-Store Tables
- Concept SAP HANA Backup and Recovery
- Concept CSV File Import for Employee Data