Acquiring data from SAP HANA views

You can acquire data from SAP HANA analytic or calculation views.

Data in an SAP HANA database is accessible in a "view"—a predefined virtual grouping of table columns that enables data access for a particular business requirement. Views are specific to the type of tables that are included, and to the type of calculations that are applied to columns. For example, an attribute view is built on dimension tables, an analytic view is built on a fact table and attribute views, and a calculation view executes a function on columns when the view is accessed.

You can connect to SAP HANA views in two ways:
  • By downloading data from SAP HANA

    Data is copied locally and can be manipulated and edited before being visualized in charts.

  • By viewing data in SAP HANA

    Data is read-only (that is, you cannot edit it), but you can visualize it in charts.

After connecting to a view, data is presented as columns, facets, measures, dimensions, and hierarchies in the application.