Skip to Content
Author's profile photo Tammy Powlas

SAP BusinessObjects Analysis Office 2.2 – How to Videos

I uploaded some “how-to” videos reviewing only some of the new features for SAP BusinessObjects Analysis 2.2.  See BusinessObjects Analysis Office 2.2 Available – Reviewing New Features

Please note these videos have no sound.  If I have time I will try to upload some more how-to videos with sound.

SAP BusinessObjects Analysis Office 2.2 – New Excel Formula Features

This is a new feature where you can insert Excel formulas that “stay” with the workbook.  It uses an absolute reference, that “stays” when you navigate.

You may provide a measure name in the first column of the Excel formula

SAP BusinessObjects Analysis Office 2.2 New Open Data Source

This was a question asked at last week’s Reporting 2015 conference – different ways to search.

As the video shows, when you are looking for a data source you can now search for it by InfoProvider, Query and Query View

SAP BusinessObjects Analysis Office 2.x Logoff API Replace System

These features are not new to 2.2 and the replace system feature has been downported to 1.4 SP12, but I thought I would share.

Related

If you are interested in influencing SAP for this product and are an ASUG member, please join ASUG in January for the relaunch of the Analysis Office Influence Council – register here

Assigned tags

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

      Hello Tammy,

      Thank you very much for your postings. I am very interested about what this new version can provide us.

      I have one question: Did you try to use this "New Excel Formula Features" for planning functions? I mean, instead of adding a new collumn or row, if it works when you insert Excel formulas directly on the planning cell.

      Thank you once again,

      Rodrigo Mourinho

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

      Hi Rodrigo - we are not using planning, so I cannot test this. 

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Thank you for your reply.

      I have downloaded the AO 2.2 and this New Excel Formula Features does not work for planning functions :/

      Author's profile photo Joost Peeters
      Joost Peeters

      Hi Tammy,

      thanks for your post!

      I was wondering if you already tried/discovered some of the other features that were announced for AO 2.2? Specifically the workbook caching. It's mentioned in the roadmap slides as being part of AO2.2, but I haven't been able to find any reference to it yet.

      Thanks,

      Joost

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

      Hello Joost - thank you for reading/commenting - I haven't had time to try that; if I do, I will try to find time to post/share.

      Author's profile photo Eric Bolle
      Eric Bolle

      Hi Tammy,

      thanks a lot for your post!


      We plan to move from Analysis 1.4.8 to a new version but today we balance between the 2.1SP03 (no more the excel issue) & the 2.2 SP00 so have you an advice.

      About Ao 2.2 SP00 :

      Seems that at the moment there is no documentation about it within the help.sap.com/boaa

      site

      No What's new, No User guide...

      So a question is there any change within the ao_app.config? .

      Eric

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

      Eric - in most cases, it is advisable to go with the previous release (2.1) and latest SP, especially without documentation

      What is your question re: config file?

      Author's profile photo Eric Bolle
      Eric Bolle

      Thanks Tammy,

      About the Ao_app.config file my question is

      Between the 2 versions the 2.1 SP03 and the 2.2 SP00 do we have any new parameters?. 

      Eric

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

      Eric - I will need some time to check - I believe so, but I didn't change anything myself to the file between versions

      Author's profile photo Torsten Wirth
      Torsten Wirth

      There are new parameters between 2.1 SP2 and SP3. That's a little bit strange. Not all options are in the config files, not all options are in the adminguide. I have also found some which are only mentioned in notes.

      I allways use a tools (e.g. diffmerge) to compare both config files (old and new ones) and add the new parameters to the file.

      Author's profile photo Eric Bolle
      Eric Bolle

      Hi Torsten

      Thanks

      On my side, about new parameters , my comparaison give me the following ones.

      MaxNumberOfParallelThreads" type="Int32"

      UseThreadPool" type="Boolean"

      RemoveDataBeforeSaving" type="Boolean"

      ShowDSVariantsForWorkbooksWithOneDS" type="Boolean"

      MessagePopupSeverity" type="String"

      But the 3rd is not really a new one! it's amazing.

      I try to build a file to summarise all options by collecting the different sources of information, but not an easy task.

      Author's profile photo Torsten Wirth
      Torsten Wirth

      Hi Eric,

      MaxNumberOfParallelThreads" type="Int32"

      UseThreadPool" type="Boolean"

      Sounds really interesting. I will try that setting with next SP. But I have not found this in Adminguide.

      Regards,

      Torsten

      Author's profile photo Tobias Meyer
      Tobias Meyer

      Hi Torsten,

      yes this sounds really interesting. But you are right, nothing in the Adminguide. Can anyone says something about this parameters?

      thanks

      Tobias

      Author's profile photo Torsten Wirth
      Torsten Wirth

      That are the final entries in the ao_app.config.

        <!--default: value="10" -->

        <MaxNumberOfParallelThreads />

        <!--default: value="True" -->

        <UseThreadPool />

      But I don't know what this is for. I have never seen that AO can work with several queries in parallel (that would be really interesting because it would improvde speed for bigger workbooks a lot). Instead AO is working query by query in a sequence.

      And there is still nor information in the Adminguide for this parameters.

      Author's profile photo Tobias Meyer
      Tobias Meyer

      Hi Torsten,

      you can find the parameter explanation in the new admin guide.

      MaxNumberOfParallelThreads:

      You use this setting to define the maximum number of parallel threads that Analysis can use to open the SAP HANA data sources of a workbook. The default value is 10. This means that up to 10 SAP HANA data sourcers can be opened with parallel threads. You can enter any integer value for this setting. If you set the value to 1 or lower, no parallel threads will be used. The data sources will be opened sequentially.

      Author's profile photo Torsten Wirth
      Torsten Wirth

      Hi Tobias,

      Thank you. I have not seen it in the documentation. My fault.

      That would be a nice feature for BW Queries. We are using BW on HANA in some months but this will not help. 😉

      Regards,

      Torsten

      Author's profile photo Eric Bolle
      Eric Bolle

      Hi Tammy,

      Thanks, take your time.

      Eric

      Author's profile photo Former Member
      Former Member

      Dear all,

      For my company it would be very important to know does AO 2.2 BO server side add in support BO Version: 14.1.5.1568  ?

      there is a note 2215163 excisting, but so far it is not yet released.

      thanks

      iiro