Create Analytic Views in SAP HANA

  • by Patrick Leonard, BI Consultant, Decision First Technologies
  • March 4, 2013
In this detailed video clip and accompanying written instruction, learn how to quickly create analytic views in SAP HANA by defining the view, joining tables, and setting measures and attributes.

SAP HANA Studio is the client-side tool that you use to interact with your SAP HANA system as well as create any resources to access your HANA data.

Beginning in the SAP HANA Studio Modeler perspective, the Quick Launch page and links to create different types of resources are available.

To give some overview of the Navigator panel on the left, the Catalog folder shows you the different schemas on the HANA database. Inside each schema, you have access to the respective tables, views, and column views. Inside the Security folder are the different users that have been established as well as the roles that are available to allow certain actions to be performed. Finally, the Content folder shows the various packages that have been created. Packages are collections of HANA collateral.

Now let’s follow the detailed steps for creating an analytic view. I suggest you watch my video demo below and follow along with this written article.

Patrick Leonard

Patrick Leonard is a business intelligence consultant with Atlanta-based Decision First Technologies. He has worked on multiple full-life-cycle BI implementations, with expertise in the healthcare and utilities industries.  He works extensively with dashboards, SAP HANA, mobility, and other data visualization tools. You can follow him on Twitter at @Pleonard_DFT.

If you have comments about this article or would like to submit an article idea, contact the BI editor.

Patrick will be presenting at the upcoming SAPinsider Reporting & Analytics 2016 INTERACTIVE conference, November 2-4 in Orlando. For information on the event, click here

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.