Reporting and analysis data analysis with sap business information warehouse. Simple example of open ods view based on hana calculation view. After completing this tutorial, you will find yourself at a moderate level of expertise in maintaining bw on top of hana database, and exploring some key capabilities on bw powered by hana. This video shows the basic needs of ip and how to start development. Sap bex query designer how to create a simple query. In this blog, we are going discuss on how a cds view can be consumed in query browser for adhoc analytics.
Tutorial about creating queries in sap bex query designer. This tutorial has been prepared for those having advanced level knowledge on sap bw functions and sap hana native modeling. To open the query designer, choose start programs business explorer. This application displays all the analytical queries to which the user has access.
Sap bw integrated planning tutorial sap bw ip day 1 sap bw integrated planning tutorial sap bw ip day 1. The calculation view is based on a table with only 4 fields and the following content. To see the list of tools under business explorer, navigate to program files in. This functionality explores all the key features of hana database technologies and uses bw as a modeling tool for data modeling and analytical reporting. In the next window, you need to enter your login credentials. Query views that were created before upgrademigration will still run after a query has been changed with the sap netweaver 2004s bex query designer. Sap bw how to create your first sap bw bex analyzer query. Most important sap note for queries on open ods views and virtual tables. All key figures in the sap bw query must be numeric. Log into your bw system and the query designer will open. Do not assign any of the characteristics a display hierarchy, either explicitly or by a variable. Sap bw i about the tutorial sap business warehouse bw integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well.
The properties include things like field description, display settings, how a. The query browser is a fiori application using which you can quickly and easily search, browse, and tag the analytical queries. This will open the sap business explorer netweaver query designer. Open ods views can be created in transaction rsa1 and in the bw modeling tools of the hana studio. How to create your first sap bw bex analyzer query full course can be found at. To open the bex query designer, navigate to the business explorer query designer. Sap bw on hana i about the tutorial sap business warehouse bw powered by sap hana refers to using bw software suite on top of hana database.
Open ods views, and more provide flexibility with sap bw architecture is essential. Query designer acts as the bridge between sap bw infoproviders and the. For more information, seerestricting characteristics. Creating a bw query in sap business explorer query designer ibm. This tutorial is intended to make you comfortable in getting started with sap. Therefore, the first practical step should be to open the query designer in. Netweaver bi enhancements of sap bw and various options for querying, reporting, broadcasting and integration different formats such as pdf. It also includes data modeling, administration and staging area. Navigate to the queries initial screen using transaction code sq01. How to create a query this video goes through the steps to create a query using the modelling tools for sap bw and sap bw 4hana. The required data is then retrieved during query runtime. Open ods view example 1 sap netweaver business warehouse. Sap business intelligence bi means analyzing and reporting of data from different. Select sap logon screen, bw system as per your sap gui system.
1473 540 1092 792 33 994 675 1078 411 1391 1113 145 711 1261 1077 210 1247 1319 1171 324 943 1507 941 884 447 1366 1197 275 283 477 1030 962 708 1081 1144 1511 371 767 1343 1487 946 468 1243 1244 418