Authored by Michaela Degbeon
In this blog I will provide a brief summary of a new capabilities in BW 7.3 called BW Workspaces which is a data modeling environment for the business user.
A BW Workspace is a kind of highly flexible but safe place for BW Data Modeling. It is maintained and controlled by IT and can be used by local departments to quickly react on new and changing business requirements. A BW Workspace is tightly connected to the powerful EDW capabilities of integrated and consolidated data. Plus it offers at the same time a rich environment for creating in a straightforward way ad-hoc data models. These can be models that connect central EDW data with local or external data, like flat file content. Furthermore the whole thing runs on BW powered by SAP HANA. Thus BW Workspaces perfectly combine integration, independence and speed . The HANA power enables super-fast data combinations and query execution of the BW Workspace data models since the processing is directly executed on the HANA engine. And BW Workspaces run completely in-memory.
Want to know more?
There are 3 easy steps in understanding a simple BW Workspace’s end-to-end scenario.
- Firstly a BW Workspace needs to be defined in the BW backend – a task that is normally done by a central IT team. The definition allows to control seize, memory consumption and authorized access. In addition it is defined what part of EDW data can be consumed by the BW Workspace: Sales data, product data or whatever central data is intended to be used for further modeling. Good to know: the data itself is not copied from the central EDW to the BW Workspace but logically exposed and no redundant data replication is necessary.
- Secondly the BW Workspace modeling and enrichment is done via the BW Workspace Designer tool. Key user can plug in external local data from e.g. flat files to the central data. Easily LOB or department-specific data models can be crafted in a smooth and intuitive manner. Technically you combine local data models with central models via JOIN and UNION operations and build CompositeProvider definitions that are processed completely in-memory. Users are guided step by step via a Wizard through the procedure of merging central and local models, defining the CompositeProvider and creating queries.The Workspace Designer itself runs in a browser and no extra software needs to be installed on the office PC.
- Lastly, regarding data consumption, there are multiple options available: you can go with the SAP Business Objects Analysis Clients or with the SAP BEx Query Designer. Furthermore any BEx Queries on top of a CompositeProvider can be consumed via the standard BW interfaces MDX and BICS using all certified BI clients.
Have you become even more curious and want to try it out by yourself? You can find further details and practice in the following link : http://scn.sap.com