Skip to Content

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

/wp-content/uploads/2012/12/1smartcopy_167862.png

Then open your Design Studio Application

/wp-content/uploads/2012/12/2smartcopy_167863.png

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:

/wp-content/uploads/2012/12/3smartcopy_167873.png

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.

/wp-content/uploads/2012/12/4smart_167874.png

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.


To report this post you need to login first.

4 Comments

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

  1. 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.

    Rgds,Murali

    (0) 
  2. Former Member

    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?

    Thanks

    (0) 
    1. Tammy Powlas
      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.

      Regards,

      Tammy

      (0) 

Leave a Reply