In the details tab, you can see the list of fields copied over from the data source. This view can be later used in other native HANA modeling. As you also see there is a check External HANA View, with this the system automatically creates a HANA view. In the general tab, double-click on the write optimized DSO to make this as write optimized Advanced DSO. In this case, we copy the template from the data source. You can either create a standalone DSO and add info objects to it or you can just make a copy of underlying data source or other object provided below to copy the structure of data source. Let us create a staging layer with write optimized DSO.ĭouble click on the dragged object and enter the technical details below. Now drag and drop the Datastore Object (advanced). Here you have the option to change the description, data properties and so on.Ĭlick Activate to activate the data source The middle section is the modeling space, and on the right, you can see the different modeling objects to consume to design.ĭouble click on the dragged item and give the source system name and nextĬlick next and type the data source string you want to search and nextĮnter the technical details and Datasource type and finish Under created info area right click and go to create Data flow object Goto the Unassigned node for example and right click and go to create Info Area There is an option to create one object at a time and as well to take a flexible approach to create a data flow which is simpler. Let’s take an example of Sales header data and use this to create the data model. I will try to keep this simple and not dive into every detailed aspect of each object which I will try to cover in other documents on each subject. Now I will focus on creating a data model in BW/4HANA eclipse modeling using the new objects available. like in the older versions of BW.ĭata sources allow you to connect to source systems, for example, S4(ECC system) and replicate the data sources. Once you provide the required details and finish you will be logged into modeling spaceīW Repository contains the Info Areas which in turns contains the modeling objects, data models etc. The first step is to add a BW project which is nothing but connecting to your BW/4HANA system. I will not be covering about HANA therefore, I will jump to BW/4HANA details.Ĭlick on the below-highlighted icon to change the perspective which in this case will be BW modeling. You will be directed to the HANA Modeler perspective(screen). When you click on HANA Studio, you get the initial screen layout.Ĭlick on the Workbench on the top right of the screen. I will try to show what I see as a most feasible option. Note – There could be more than one ways to access or create an object or an application. Pre- Requisite: Once the SAP HANA Studio with BW/4HANA plugins is installed. SAP BW includes the consolidation of data from multiple systems which eventually provided more agility and governance in the IT landscape. Most SAP BW systems include complex business transformations, consolidation of SAP systems, non-SAP systems etc. The advantage of SAP BW is not limited only to the performance of an OLAP system. Some might think why do we need BW4/HANA and achieve what is needed in S4HANA itself. This performance improvement is achieved by moving the complex BW operations and calculations to the HANA database. Aggregates are not required, few indexes are needed, data loads and execution of queries is fast. SAP BW/4HANA is built on top of SAP HANA and provides high-performance capabilities. SAP BW/4HANA will receive much of the innovation being developed moving forward. However, with BW/HANA we have a more stable platform, more scalability and tighter integration and use of HANA optimized objects. Note that BW 7.5 on HANA with SP4 also gives the opportunity to use eclipse based modeling. With BW/4HANA, we can no longer consume the old classical BW objects. These versions would still have the possibility to consume the old classical BW objects as standalone or being converted to HANA optimized objects. These versions introduced modeling objects like Composite providers, Transient providers, Advanced DSO, Open ODS view and so on. With the introduction of HANA DB, the SAP BW versions supporting it are from 7.3 -> 7.4 -> 7.5 before BW/4HANA came in. SAP BW has been evolving continuously from SAP BW 3x to now BW/4HANA. The BW GUI still offers a representation of classical administrative workbench without the key modeling capability.Īll the modeling of data flows, objects, data models happens within the Eclipsed based SAP HANA Studio. The reader would get the look and feel of the new eclipse based modeling in BW/4HANA and how to create a data model flow in BW/4HANA.īW/4HANA modeling is eclipsed based and happens within the HANA Studio. The purpose of this document is to provide details on how to do modeling in BW/4HANA with steps.
0 Comments
Leave a Reply. |