Skip to Content

This is an idea I obtained from David Stocker

First set up your Analysis Office application, and add a filter:


In the example below I am going to filter on project:


Then select the Create Web Application icon


Then Design Studio launches, and you can see it has takes advantage of the Analysis Office filter:


This is how it looks in when you run it in Design Studio:


So in theory the business analyst builds their dashboard in Analysis Office and sends it to Design Studio for the IT developer to complete the “professionally authored dashboard”.

Is this something you’ll try?

I’m looking forward to this ASUG SAP TechEd Session by  Alexandre Rivet Papagiannidis of Molson Coors Looking at One Source of the Truth with SAP BusinessObjects Design Studio

To report this post you need to login first.


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

  1. Former Member


    this feature would be really good, but in the moment, it´s not working on my computer.

    The Icon “Create Web Application” is not available in my Analysis for Office (Version With which Version you are working?

    I´m also not able to “Smart copy” a DataSource fro, Analysis for Office to DesignStudio. Evertime I trying this, there´s an error message, that the DataSource could not be initialized.

    Has anybody a solution for my problem?


    1. Tammy Powlas Post author

      I am using the same version as you.

      You need to go to Settings > Advanced Settings and click on checkbox to show Create Web Application

      For the smart copy, see Going from BusinessObjects Analysis Office to BusinessObjects Design Studio – Mobilize your Spreadsheet?

      You need to be either local in both Design Studio / Analysis Office or both on the platform.

      If you have more issues, please open a new discussion post in the forum.



  2. Former Member


    I have a question regarding this, when I try to Create Web Application with a very similar Worksheet the following error message pops up:

    Error 1: In one of the data sources an exception has occurred. SAP BI add-in has to connect to any data source separately. If you want to reboot, press the button “Restart” below. (ID-111006)”
    “Error 2: Nested exception; further details, see the inner exception ‘below:
    The system can not find the file specified”

    DesignStudio does not start. Also, I cannot find the Worksheet when I try to add it as a DataSource in the DesignStudio. I can only find the Query, although I have saved the Worksheet as an AAOE file in the NetWeaver Repository.

    SmartCopy does work, but this copies the Query, not the rest of the Worksheet.

    I’m working with AO (V1.4.0.2528), Design Studio (1.1SP1), SAP BW (730 SP9).

    Can you see what goes wrong here?

    Thanks in advance!

    Pelle Koeslag

    1. Tammy Powlas Post author


      What BI Platform version are you using?

      I was using BI4.1

      You may want to turn on the trace logs and send them to SAP support.



      1. Former Member

        Thank you for the fast reply!

        We are using BI4.0 (SP6?), but it’s not working correctly, which is (probably) causing this problem. We’re working on it and I’ll let you know once it’s solved.

        Thanks again,


  3. Former Member

    Dear Tammy, as discussed.. I had to update my SAP GUI to see the additional icons.

    Had to reinstall analysis too 😉

    So far it works now – but the result is ah 😯 . Well it works in opening DS Client and creating crosstab and a chart in an acceptable manner, run locally works too, but opened from my BI4.1 BOE platform the app shows lot of errors and I can’t use it . Rebuilding in DS would work. So sg. on my BOE 4.1 SP2 P1 seems not compatible with the created app-code?

    See yourself: – local version – simple things – ok


    And now the same openened in BI  launchpad:



        1. Tammy Powlas Post author

          Hi Wobi –

          I just tried this

          It is working for me

          Of course, when I upload to BI platform, I have to change the OLAP connections on the data source

          Only difference is I didn’t apply patch 1 of BI4.1 SP2

          Would it help if I did a recording later?

          1. Former Member

            Usually I use the olap connection from my bi server also in the analysis for Office  – so there is only one connection and I don’t have to change any. So my whole worklow is using the bi server – in DS I login with the bi server logon. – I will test differnt scenarios – keep you updated..


            1. Tammy Powlas Post author

              Hi Wobi – me again

              I just tried logging on Analysis Office via BI Platform, inserting data source and chart, then I selected Create Web Application in Design Studio

              It works for me.

              It sounds like the only difference may be I am on BI4.1 SP2 (no patch)

              I am also using Analysis Office 1.4 patch 5

              If it still is not working for you, maybe you could try the Smart Copy / Paste feature or submit a SAP support ticket (sorry)


                1. Former Member

                  hm afaik I am top on all patches – still the same – automatic generated app from analyis  (AFO) into DS  does not work on MY BOE BI4121 ;-(


Leave a Reply