Having moved to SAP Design Studio from Xcelsius, I really missed Excel and the ability to do front end data manipulations, in SAP Design Studio. But not for long ! That was only until I found out how easy it was, to use Analysis for Office Workspaces for that.

BW workspaces are dedicated areas in a BW system where you can safely upload locally changed data without actually changing the source objects in the BW system. Follow steps below to see how we can use the two work spaces to get data – changed as desired, into SAP Design Studio.


Creating a BW Workspace


Create a workspace in SAP BW using transaction RSWSP. Enter a name and click on Create.

/wp-content/uploads/2014/11/b1_580518.png


Fill the other values – Expiry Date, Workspace Prefix, etc. Then Save and Activate it.

/wp-content/uploads/2014/11/b2_580519.png


Uploading local data to a Workspace

Go to Analysis for Office, insert a data source from BW and create a report. Add / Change data in the columns as required, using necessary front end calculations. Here, we have used a formula based on column C to create the new column D, as shown.


/wp-content/uploads/2014/11/b3_580535.png


After making changes to the data, select the range of data that you want to upload to the BW Workspace and then click on Create.


/wp-content/uploads/2014/11/b4_580536.png


Log in to the system where the workspace was created, and select the workspace.


/wp-content/uploads/2014/11/b5_580537.png


/wp-content/uploads/2014/11/b6_580538.png

Click on OK and proceed with configuring the local provider. Enter a description and technical name for the local provider. The technical name is prefixed with the value given when creating the workspace. Click on Next.


/wp-content/uploads/2014/11/b7_580539.png


Choose where the connection to the new local provider is to be placed, on the Analysis for Office report.


/wp-content/uploads/2014/11/b8_580540.png


Using the Workspace in a SAP Design Studio Application


Start SAP Design Studio and log in either locally or through the BI Platform.


/wp-content/uploads/2014/11/b9_580541.png


In the Outline section, right click on Data Sources, add a new data source and search for the BW workspace that now has the local provider.


/wp-content/uploads/2014/11/b10_580543.png

/wp-content/uploads/2014/11/b11_580547.png

Click on Ok. Edit the initial view of the obtained data source to view the data.


/wp-content/uploads/2014/11/b12_580548.png

And, we have the locally added column AA available now, in our data source in SAP Design Studio. This is comparable to the ‘Smart Export’ feature in Analysis for Office. Reusability of the data provider is one advantage of using BW Workspaces.

Source : http://visualbi.com/blogs/design-studio/analysis-office-sap-design-studio/

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply