Hana_modelling

... A table type definition the „transfer structure‟ or „view‟ you can „SELECT FROM‟ ... And a SQL script function (which may invoke other SQL script functions)
Attribute View
Set Parameters
Table joins and properties
Create Hierarchies
Data Preview
Table Selection
Select Attributes
Save and Activate
© SAP AG 2009
Attribute View:
2.


Highlight table in selector tree (left-hand side, „Available‟) then add to list of „Selected‟ tables
Table joins and properti es
Set Paramet ers
Create Hierarchies

Standard Time view

Either create a new view Or select an existing attribute view as template
© SAP AG 2010
Attribute View:
Select table(s)
An Attribute View is a join of several tables

Build a „Data Foundation‟ based on transactional table

Selection of „Measures‟ (key figures) ... ... and attributes (docking points for joining attribute views)

Via “Add table” button search window

One can only add one table at a time using this wizard.
Set Paramet ers
Table joins and properti es
Create Hierarchies
Table Selectio n
© SAP AG 2010
Select Attribute s and Measure s
Save and Activate
Attribute View:
Define join properties Table Joins and Properties

Join Types


Can be regarded as Master Data tables
Can be linked to fact tables in Analytical Views A measure e.g. weight can be defined as an attribute.
© SAP AG 2009


this is basically your „fact table‟ (key figures and dimension IDs)
Looks a bit like a star schema
Join attribute views to data foundation

Modeling for HANA 1.0
Using In-Memory Computing Studio (II) Idea 3: If simple joins are not sufficient use SQL Script

Is a HANA-specific functional script language

Think of a „SELECT FROM HANA‟ as a data flow You can move functions into that data flow in order to
Data Preview
Table Selectio n
© SAP AG 2010
Select Attribute s and Measure s
Save and Activate
Attribute View:
Add table via drag & drop
Add additional tables to view

Analytic privilege is always a concrete implementation

Agenda
Levels of Modeling - Attribute Views - Analytic Views - Calculation Views - Export & Import

Via Drag&Drop from Navigator Tree

Set appropriate filter on schema Drag table(s) into the view
1. Filter on table name
2. Drag table into view
Set Paramet ers Table joins and properti es Create Hierarchies Data Preview
Attribute View:
Output field selection and filters Select Attributes to show up in view

The output structure of the view must be explicitly defined
Table joins and properti es Create Hierarchies Data Preview
Set Paramet ers
Table Selectio n
© SAP AG 2010
Select Attribute s and Measure s
Save and Activate
© SAP AG 2009
Attribute Views
Attribute View

What is an Attribute View?

Attributes add context to data. Attributes are modeled using Attribute Views.
SAP HANA
Modeling in the 1.0 Use Case
SAP HANA Olympics / January 31st 2011 Richard Bremer SAP Technology RIG
Agenda
Levels of Modeling - Attribute Views - Analytic Views - Calculation Views - Export & Import

Join text tables to master data tables If required: join master data tables to each other (e.g. join „Plant‟ to „Material‟)
Idea 2: create ‚Cube-like„ view by joining attributes view to ‚Fact data„

Enrich data (e.g. Add columns for calculated measures on the fly)
JOIN or UNION two or more data flows Include complex logic such as „CASE‟ statements

Inner
leftOuter rightOuter fullOuter textTable 1:1 N:1 1:N
3.

Cardinality


Language Column (for text join)
Note: the direction in which you draw the join matters (left table first)
View Creation Wizard
Attribute View Parameters

The first step of the creation wizard asks for basic view properties

1.
Enter a name (technical name) and description Select view type

In my eyes, this can be compared to „piping‟ on the Unix command line
Idea 4: Create something that looks like a ‚View„ and has SQL Script inside

This is a „Calculation View‟ – Consisting of ...

The second step of the creation wizard presents a selector for DB tables