Skip to Content
Author's profile photo Tammy Powlas

BusinessObjects Analysis Office 1.4 is now GA – Your First Steps

Last month SAP covered what is new with Analysis Office here.  Today is it generally available, according to the PAM.   This morning I was able to install it on my machine.

The install file is only 79.2 MB and installation is fairly easy.

/wp-content/uploads/2013/05/1install_224909.jpg

When you get to this screen you need to click the Enable 1.4 Features checkbox.

/wp-content/uploads/2013/05/2installsuccess_224910.jpg

Once you install you see the success.

Go to the Settings Tab to enable some new features:

/wp-content/uploads/2013/05/3figenable_224911.jpg

I can enable the launch query designer button and Create Web Application (launch Design Studio)

Note to BEx launch query designer you need to install the latest SAP Gui patch for 730; otherwise it is greyed out.

/wp-content/uploads/2013/05/4querydesigner_224918.jpg

After clicking “Launch Query Designer” you can then launch the BEx Query Designer:

/wp-content/uploads/2013/05/5bexquerydesigner_224919.jpg

More to come in future  – read access mode, reset data source, etc.  Watch the BusinessObjects Analysis Office space.

Assigned Tags

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

      Good news Tammy,

      Thank you.

      In A-Office we still waiting RRi with sap gui from Alexander.

      And supporting unx Universes.

      Author's profile photo Ignacio Llopis Tortosa
      Ignacio Llopis Tortosa

      Thanks for your article Tammy.

      I just tested the new option "Launch Query Designer" and I am really disappointed. I expected the same functionality as BEx Analyzer but I just found a shortcut to BEx Query Designer. If I open the Query Designer, modify the query and come back to Analysis, data is not refreshed. I also have to login each time I press the launch Query Designer button.

      Do I miss any configuration?  Is this the expected functionality?

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

      Hello Ignacio,

      I didn't mention all the features of Analysis 1.4 (I was out of the office and ran out of time)

      What I did was after changing the BEx Query, come back to Analysis Office and right click > Reset Data Source, and it was updated.

      I will try to write another blog on this later.

      If you still experience issues please create a discussion post on your question/issue.

      Kind regards,

      Tammy

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      I have got a Problem with Connection Query Designer with Dashboard.

      I have already poasted it. Did you see it

      Best Regards

      Eric

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

      No, I have not

      Author's profile photo Former Member
      Former Member

      Please Tammy,

      can you tell me How I can do it, so that you receive my Message.

      Regards

      Eric

      Author's profile photo Daniel Gröber
      Daniel Gröber

      Hello Tammy,

      Launch of Query Designer is only available with GUI 730? That would be quite annoying, as we are still using 720. Any reasons for that? Or patches for GUI 720?

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

      Hi Daniel,

      My understanding is that SAP GUI 720 went out of maintenance in April of this year.

      I don't work for SAP but my guess is it likely won't work for SAP Gui 720

      I recommend submitting a SAP support ticket on this.

      Regards,

      Tammy

      Author's profile photo Daniel Gröber
      Daniel Gröber

      We will change sooner or later - but the problem is, that it is not available for selected users which we wanted to use AO before the rest.

      Is there any "official" statement about the connection QD-Launch-GUI 730? Note?

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

      Daniel - I recommend opening a new discussion on this, instead of replying on the blog.

      I know I needed to be on SAP Gui 7.3 SP3 for this to work.

      Kind regards,

      Tammy

      Author's profile photo Bharath Ramamurthy
      Bharath Ramamurthy

      Hi Tammy,

      Launch Query Designer option will be enabled for SAP GUI >= 720 SP 10 and 730 SP03.

      Regards,

      Bharath

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      I have read your blogs and installed the latest version and the SAP GUI as well.

      Now when I try to insert the data source I don´t see the option to skip and connect to SAP BW - as we don´t have a BO server , I must use SAP BW as data source- can you help me ?

      thanks and regards

      Manu

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

      I see you posted as a discussion and you have received a couple of replies.  Please check the user settings.

      Thanks

      Author's profile photo David Stocker
      David Stocker

      It sounds like you might have switched your platform to one of the BOE options.  Try looking in your settings dialog, on the Platform Settings tab.

      Cheers,

      Dave

      Author's profile photo Anita Dixit
      Anita Dixit

      Hi Manu,
      To enable you to se the option 'Skip' and connect to SAP BW, please follow this :
      Go to Analysis Tab ->Settings->Platform Settings
      Preferred Platform : Selectable.

      This should set the 'Skip' button and let you connect to the system of your choice.

      Hope this helps.

      Cheers,
      Anita

      Author's profile photo Marian Canciu
      Marian Canciu

      Hi Tammy

      We are facing a bizzare notebook behaviour:

      - WIN7 64 bit and Office 2013 with 32 bit installed

      - analysis office 1.4 32 installer downloaded

      When starting the installer (as administrator) the prerequisites are checking for Office 2013 32 bit (which is actually installed) and we can't proceed with the installation.

      Is this a known bug ?

      Any workaround to solve this issue?

      Cheers

      Marian

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

      Marian - would you please post as a discussion so the experts can assist?

      Thank you,

      Tammy

      Author's profile photo Marian Canciu
      Marian Canciu

      Hi Tammy

      I posted a discussion but was hoping for a faster answer.

      This is really frustrating.

      Marian

      Author's profile photo David Stocker
      David Stocker

      Hi Marian,

      I've seen this before, but don't remember what the fix was.  I'll ask around for you on Monday Morning.

      Cheers,

      Dave

      Author's profile photo Former Member
      Former Member

      This is still an issue for us. I have Office 2013 installed as part of Office 365. My OS is Windows 8.1 (64bit). The install reports that I do not have Office 2013.

      [update]

      I found a patch that is now working.

      Thanks

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

      Hi Scott - I recommend either opening a new discussion thread on the forum or opening a SAP Support ticket with SAP -

      Also please check the PAM https://websmp206.sap-ag.de/~sapidb/011000358700000429322013E

      and SAP Note 1874429 - if your system meets those requirements in the note and the PAM, then please open a ticket with SAP Support

      Author's profile photo Former Member
      Former Member

      All good now, thanks Tammy.

      Author's profile photo Linda WONG
      Linda WONG

      Hi Tammy,

      We are currently using Bex 3.5 Analyzer and Query Designer. With Analysis Office 1.4, I am able to open Bex 3.5 Workbooks.

      Just wondering, will Bex 3.5 Queries and Workbooks still be supported by future release of Analysis Office (ie. after 1.4)? Is there any plan to support Workbooks/Queries only from Bex 7.x onwards?

      Linda

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

      Hi Linda,

      I don't work for SAP so I really can't say.

      I do know the SAP 730 Gui (old 7.20 Gui went out of maintenance in April of this year) doesn't ship with BEx 3.5

      Perhaps open a discussion thread so SAP sees this and can respond?

      Regards,

      Tammy

      Author's profile photo Former Member
      Former Member

      Hi Tammy

      is it possible to Scheduling the Workbook within Netweaver like the BEx Broadcaster?

      Thank you.

      Kind regards,

      Adrian

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

      You can schedule workbooks through the BI platform (not BW) ( see http://www.mastering-sap-and-businessobjects.com/scheduling-with-sap-businessobjects-analysis-edition-for-microsoft-offi… )

      It is not the same as BEx Broadcaster

      Author's profile photo Petra Koepfer-Behncke
      Petra Koepfer-Behncke

      may be a blond question where do I find the front end installer?

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

      Petra - did you download the software from Service Marketplace?  When it unzips there is an application file to execute.

      Author's profile photo Petra Koepfer-Behncke
      Petra Koepfer-Behncke

      thanks do you know the download folder is very little on this  page. I called It and then they said , that I have to create an access request which is what I did now.