Information Models are multiple database views of transactional data
stored in the physical tables of SAP HANA Database used for Analytical
purposes. Analytical Data Modeling is only Possible For
Column Tables i.e. Information Modeler only works with column storage tables.
For that reason
Replication Server creates SAP HANA tables in column store by default.
Data Services also creates target tables in column store as default for SAP HANA database. The SQL command to create column table: "
CREATE COLUMN TABLE Table_Name
..". Also the data storage type of a table can be modified from Row to Column storage with the SQL command "
ALTER TABLE Table_Name
COLUMN".
We can Choose to publish and consume SAP HANA tables data at four levels
of modeling using SAP HANA Studio Information Modeler Perspective.They
are
Attribute View,
Analytic View,
Calculation View and
Analytic Privilege. These content data models are basically the combination of
Attributes and
Measures.
No comments:
Post a Comment