Skip to Content
Author's profile photo Tammy Powlas

Using BusinessObjects Analysis Office to Prototype for Design Studio

This is an idea I obtained from David Stocker

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

/wp-content/uploads/2013/07/1filteraa_242142.png

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

/wp-content/uploads/2013/07/2filtershows_242143.png

Then select the Create Web Application icon

/wp-content/uploads/2013/07/3createwebapp_242153.png

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

4howitshowsinDesignStudio.png

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

/wp-content/uploads/2013/07/5runningit_242155.png

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

Assigned tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello,

      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 1.4.1.2585). 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?

      Thanks

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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.

      Regards,

      Tammy

      Author's profile photo Former Member
      Former Member

      Thank you for sharing this Tammy Powlas!

      Author's profile photo Former Member
      Former Member

      Hello,

      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

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

      Pelle,

      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.

      Regards,

      Tammy

      Author's profile photo Former Member
      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,

      Pelle

      Author's profile photo Former Member
      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

      :/wp-content/uploads/2014/01/11localhost_374195.png

      And now the same openened in BI  launchpad:

      /wp-content/uploads/2014/01/12boe_374196.png

      Wobi

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

      Wobi:

      Did you upload the application to the BI Platform?

      Author's profile photo Former Member
      Former Member

      Yes uploaded, does not work this way in my environment. It is an updated BI 4.0. Now 4.1.Sp2 p1...

      - Wobi

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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?

      Author's profile photo Former Member
      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..

      Wobi

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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)

      Tammy

      Author's profile photo Former Member
      Former Member

      I will check my update patches on analysis... and retest!

      Wobi

      Author's profile photo Former Member
      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 ;-(

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

      Oh noes 🙁

      I would submit a SAP support ticket (sorry)

      The other alternative is to use Smart Copy paste Going from BusinessObjects Analysis Office to BusinessObjects Design Studio - Mobilize your Spreadsheet?

      Author's profile photo Former Member
      Former Member

      Smartcopy does not work either - "unhandled event loop exception" 😥