Continuing the SAP HANA Academy’s “What’s New” video series examining the new features of SAP HANA SPS08 Tahir Hussain “Bob” Babar highlights some of SPS08’s modeling enhancements via a demonstration of building a graphical calculation view.
How to Unionize Data Sets in Calculation View (0:26 – 3:50)
In a modeling perspective in SAP HANA Studio Bob builds an information view with some data he has already imported into tables using DB2 Smart Data Access. Bob builds a graphical calculation view in newly created package.
In order to unionize two of his data sets first Bob drags a pair of projections onto his canvas and then populates them with the pair of data tables that he desires to combine. In this example Bob selects all of the objects from each of the tables and adds them to the output. Next the union icon is dragged onto the campus and the pair of projections are linked to the union.
Users will notice that now it is much easier to select and group objects in a calculation view. It is also very simple to create additional target columns by just pressing the green plus sign. Reordering the objects is quite intuitive via using the arrow buttons.
New Feature of Projections (3:50 – 4:04)
With a projection selected in the details box a user now has the option to select whether to fill the empty unions with either no row or row with constants from a drop down menu in the general tab of the properties box.
How to Join Unionized Data to Different Data Set (4:25 – 6:20)
Drag a join icon onto the campus, link it to the unionized dataset, and populate the join with a data set. By clicking on the line between the two datasets in the details box allows the user to select the cardinality of the join. After choosing the objects to be joined click add to output.
Selecting What Objects to Output (6:20 – 7:25)
Link the joined dataset to the aggregation. Then the objects in the table can be either outputted or added to the aggregated column. In this example Bob outputs every object except for page views, which he instead adds to the aggregated column. This automatically turns page views into a measure.
Setting the Semantics and Reviewing the Data (7:25 – 9:26)
By selecting the semantics icon on the campus any objects can be turned into a dimension by highlighting them and clicking the blue square icon. Make sure to grant users the rights to create the calculation view before clicking save and activate.
Now by looking at the raw data in the data preview Bob verifies that he has added the extra memberID data to his table along with their corresponding page views from the joined data.
Note that the UI for the calculation view has been updated in SPS08 to include new icons for the actions and new indicators for cardinality and objects on the campus.
Check out Bob’s tutorial view on the new feature of modeling with a graphical calculation view in SPS08.
View more tutorial videos about SAP HANA SPS08 at the SAP HANA Academy.
SAP HANA Academy – over 500 free tutorial technical videos on using SAP HANA.
SAP HANA Academy