Skip to Content
Author's profile photo Tammy Powlas

Going from BusinessObjects Analysis Office to BusinessObjects Design Studio – Mobilize your Spreadsheet?

First, I saw this from Thierry AUDAS on twitter:

So of course I had to check it out.

First, it helps to be on the latest patches of BusinessObjects Analysis Office (SP5) and Design Studio 1.0 SP1

Also, both tools need to be either “local” or “on the platform”.

I tried it local first.

First, start off in Analysis Office, and save your workbook.

Then, right-click your workbook and select “Smart Copy” (note the help says “Export Data Source”) – thanks to Alexander Peter for alerting me to Smart Copy


Then open your Design Studio Application


In the Outline section, right click on Data Source and select Paste External Data Source

Another way is to select right click on Layout as shown below:


Once you have done this, it is available as a data source to Design Studio, similar to the way a BEx Query is a data source.  Then you can drag it over and assign it to the Crosstab.


Then the Design Studio application can be deployed as normal either to the browser or the iPad.

So this is part of the “interoperability” of Analysis suite.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Muralikrishnan E
      Muralikrishnan E

      Hi Tammy,

      Thanks for sharing this info.

      Is this "interoperability" holds true in the reverse case as well? I mean Smart copy of Cross Tab data from Design Studio to Analysis Office through some way.


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I don't think it works the other way - but it's a great suggestion for Idea Place 🙂


      Author's profile photo Bhavin Shah
      Bhavin Shah

      Hello Tammy

      Thanks for sharing. I notice that when I follow the steps above, any conditional formatting or calculated field I have on the Analysis cross tab do not come over. Design Studio documentation says that it should come over. Can you please check on this?


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Bhavin,

      I don't have that particular scenario where I work; if the documentation says it should come over and it doesn't I recommend submitting a SAP support note/ticket.