In a SAP HANA Academy tutorial video Thomas Fleckenstein gives an overview of the SAP HANA Live View Browser by illustrating the pre-configured views available within SAP HANA Live packages. Check out Thomas’ video below.
(0:05 – 2:20) Basics of of SAP HANA Live View Browser
The SAP HANA Live View Browser helps people in particular Lines of Business get an overview of the available content on a certain SAP HANA system. Sometimes it’s difficult to get an understanding of the views available, which fields are available in the views, and what is absent and needs to be created by combining existing views together. The SAP HANA Live View Browser gives users this understanding.
Web browser based, the SAP HANA View Browser structures the available content via application component hierarchies. By clicking on the various application component hierarchies listed on the left hand side you can see which views are available for that component.
If you right click on a field in the view (ex. View Description) then handy search features appear including sort ascending, sort descending and filter. In Thomas’ demo he enters “Billing” into the filter option to see all of the views that contain “Billing” in their view description.
For a more generic search you can use the search tab in the top banner.
(2:20 – 3:30) How to Explore Views in the View Browser
Clicking on the star to the left of View Name will add that particular view to your favorites. To select a particular view click on the grey box to the left of it’s star. To get an overview of a selected view click on the button in the top left corner. All of the fields and types will be listed out so you’ll get a good impression of the view’s contents.
To see which tables are sending data through this view to the end user click on the open cross reference button at the top. The information will first appear as a table but clicking on the graph view provides a much more atheistically pleasing layout. Expanding the different views inside your current one show all of the data tables (marked with a black dot) that make up the view. The expand all button gives a comprehensive overview of the entire view.
(3:30 – 6:25) How to Execute a View with SAP Lumira
In order to dive even deeper and get a solid grip of a view’s master data the SAP HANA Live View Browser enables you to execute a view with both the SAP Lumira client and the SAP Office client.
Select a certain view and then click the Open with SAP Lumira button. Open the downloaded file and enter your user credentials to connect to SAP HANA. Select the proper Variable (Thomas chooses 004) and now you can analyze your view’s data with SAP Lumira.
Thomas quickly demonstrates how to create visualizations in SAP Luirma. He selects Distribution Channel Name as the Dimension for his Y Axis and Item Net Amount as his pie sector Measure to create a simple pie chart. Thomas also shows how to create a column chart and a tree map using the data from his selected view.
All of the data Thomas is using in SAP Lumira is live and coming in real-time from the SAP HANA database. Thomas also highlights how to create storyboards and apply filters.
(6:25 – 8:05) How to Tag Views and Generate SLT Files
Back in the SAP HANA Live View Browser the tag button allows the user to place tags on certain views so they will be easier to search for in the future.
The SAP HANA Live View Browser enables you to set up a SAP system landscape transformation replication server connection so you can replicate the data from a traditional database into a SAP HANA database. Select a view and then click on the Generate SLT Files button. Now all of the tables that are needed to fill that view will be listed in a CSV file which will serve as the input for the configuration of your SLT.
SAP HANA Academy over 900 free tutorial videos on using SAP HANA and SAP HANA Cloud Platform.