Skip to Content
Author's profile photo Tammy Powlas

Trying out what is new in Analysis Office 2.3

So first I install the client, then try the Report-to-Report where Analysis Office is a receiver from Design Studio:

First you set up the RSBBS on the back end, then in Design Studio you can select right-click and “Jump-to”

So the “jump” is from Design Studio to Analysis Office

/wp-content/uploads/2016/05/rsbbs_959906.png

Note what is new in RSBBS as shown above – Analysis Office is a report type

In the above I am formatting cells (not new) but what is new is the table rules editor:

This is on the 4th tab of the Design panel

/wp-content/uploads/2016/05/6lastdataupdate_959886.png

You see the last data update of your multiprovider

/wp-content/uploads/2016/05/7cancellongrunningqueries_959908.png

It is also nice to have the ability to cancel long-running queries as shown above

You can also rename your measures from within Analysis Office

/wp-content/uploads/2016/05/9logoff_959909.png

And you can logoff now from Analysis Office; this is a long-standing request from the ASUG Analysis Influence Council More to come.

Assigned Tags

      38 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Michael Hamm
      Michael Hamm

      Hi Tammy,

      i am also testing the new features. Are you able to see AO formulas in the table rules editor if you select Formulas as ruletype?

      This does not work for me.

      BR,

      Michael

      Author's profile photo Tobias Meyer
      Tobias Meyer

      Hi Michael,

      as you can read in this post under "Highlights: Table Design Editor" you can only edit formats and new lines at the moment.

      regards,

      Tobias

      Author's profile photo Michael Hamm
      Michael Hamm

      Hi Tobias,

      yes and no 😉 It is correct that you only can edit formats and new lines, but ruletype text and formulas should still list objects for text and formulas. I first thought formulas lists all SAP formulas used in the workbook, but it does not.

      Instead:

      Ruletype Text: A rule is listed when an empty row/column is inserted in a crosstab AND a formula OR a text is added in the member header.

      Ruletype formulas: A rule ist listed when an empty row/column is inserted in a crosstab AND a formula is inserted in a data cell, column data or row data. (but NO text).


      I had an incident open regarding this and SAP will enhance the documentation/user guide with 2.3 SP01 what exactly a customer/end user can expect from the ruletype formula and text. As this is currently not documented.

      BR,

      Michael

      Author's profile photo Tobias Meyer
      Tobias Meyer

      OK I see what you mean. I never thought in this way. Thanks for the explanation.

      BR,

      Tobias

      Author's profile photo Krushna Mantri
      Krushna Mantri

      Wow....you are really very fast.....thanks for sharing the information.

      Much Appreciated.

      regards

      Krushna

      Author's profile photo Brian Marier
      Brian Marier

      Nice write-up!

      Author's profile photo Torsten Wirth
      Torsten Wirth

      Is anyone else experiencing the problem that logon after logoff is only working the first time with BIP logon screen in combination with SSO? When trying this the second time there is no logon window for BIP which means you will allways getting the same BIP connection which makes no sense because in our case we have:

      BO Dev <> BW Dev

      BO Live <> BW Live

      Which means what's happening after first logoff with logon afterwards makes sense but everything which is happening after the second logoff with logon again makes no sense.#

      Regards,

      Torsten

      Author's profile photo Michael Hamm
      Michael Hamm

      Hi Torsten,

      yes i experience the same with 2.3 SP00:

      1. Start AO and click on Open Workbook -> Logon screen with 2 systems appears

      2. Choose system A and select any workbook

      3. Log off with the new logoff feature and close the workbook, but not Excel

      4. Click again on Open Workbook -> Logon screen with 2 systems appears where system A is preselected

      5. Choose system A and open any workbook

      6. Log off with the new logoff feature and close the workbook, but not Excel

      7. click again on Open Workbooks -> No logon screen appears instead directly the Open Document windows appears and system A was automatically choosen.


      have you opened an incident?


      BR,

      Michael

      Author's profile photo Torsten Wirth
      Torsten Wirth

      Yes, I have. Excactly the same behaviour in our system.

      Regards,

      Torsten

      Author's profile photo John manlo
      John manlo

      Hello Michael,

      Try this by enabling below option.

      /wp-content/uploads/2016/06/2016_06_07_10_56_37_969816.png

      Thanks

      John

      Author's profile photo Torsten Wirth
      Torsten Wirth

      Hi John,

      This option is already enabled. Otherwise you will never get a logon screen in combination with SSO.

      Regards,

      Torsten

      Author's profile photo Michael Hamm
      Michael Hamm

      Finally an unsatisfying answer from SAP: This behaviour is a bug, but not in the way we thought! It is possible to log off when a BOE / BIP connection is used, but it is not possible to switch then between between BOE / BIP connections... This is only possible if you close the Excel session.

      According to the response from the SAP Incident this is not planned currently. So please vote if you need also this feature: https://ideas.sap.com/D35472

      Thanks & Regards,

      Michael

      Author's profile photo Torsten Wirth
      Torsten Wirth

      I have got the same answer some minutes ago. But this is the opposite:

      Re: LogOn LogOff in Analysis?

      Hi Torsten,

      we're fixing this bug. LogOff should really behave like closing/opening the Excel workbook, i.e. you should be prompted for a BI system again.

      However: logoff is not like in Bex analyzer where you can assign a new system to the query afterwards - this is handled by the system remapping functionality.

      By the way, the long awaited and frequently requested logoff-button has made it into release 2.3 ...

      Best,

      Alex

      If Excel is closed and opened again this is definately a new session.

      Regards

      Torsten

      Author's profile photo Clemson T
      Clemson T

      Hi,

      very intuitive article. I'm new to BO & Analysis with my background BPC/IP/BPS. Can some one guide how to get BO Analysis? I've BO suite installed but i don't see ANALYSIS add-in in excel and also it is not listed in BO Menu.

      also, Do we need special license to get Analysis? Is license per user? appreciate any inputs.

      Author's profile photo Torsten Wirth
      Torsten Wirth

      You will not find it in BO. It is a separate tool which will be installed locally. It is integrated in BO platform but you don't need BO platform for AO.

      Licences is allways a difficult topic because this changes and depends on your contracts with SAP. As we started to use it it was a separate licence. But please ask a SAP representative concerning that.

      Author's profile photo Daniel Klein
      Daniel Klein

      Is a BW update needed to set up Analysis Office as a receiver in transaction RSBBS? If yes, which version is needed? We are on BW 7.40 SP10 and don't see AO as receiver there.

      Author's profile photo Torsten Wirth
      Torsten Wirth

      2283045 - BBS: Support für neue Berichtsart 'Analysis Office' als BBS-Empfänger

      Author's profile photo Markus Hagedorn
      Markus Hagedorn

      Hello!

      Do the Analysis reports for the BBS (Jump from Design Studio to Analysis f. Office) be stored in BW or can also lie on the BO platform (we use the BO platform)?

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

      Markus - if you have set up RSBBS in BW you can still use when deploying to the BI platform.  Does this answer your question?

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      I would like to follow up on that question, maybe specify it: Can you use the RRI-functionality only to jump to Analysis Office documents, that are stored on the BW itself?

      Or can you also use it to jump to Analysis Office documents that are stored on the BI platform (in contrast to the openDocument links)?

      I couldn't see any information regarding a configuration/an example for the functionality yet.

      Cheers, Philipp

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

      Philipp:

      They do not need to be stored in BW.

      Please note the server prerequisite: SAP note 2283045

      Other notes from SAP:

      "It is required to have at least one static target

      (Implementation of dynamic targets in BadiRS_BBS_BADI_DYNAMIC)

      Jump to workbooks (prefix 00) or presentations (prefix 01)

      Handing over context to target workbook as filter"

      Author's profile photo Michael Hamm
      Michael Hamm

      Hi Tammy,

      if i understand you correct that it is possible to jump from a DS application to a AO workbook and pass the filters where both applications are stored on the BI Platform. I could not find a solution for this. Could you please give me a hint?

      I tried it with OpenDocument and RSBBS, but in the RSBBS i can choose only workbooks which are stored on BW.

      Thanks & BR,

      Michael

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

      Michael: could you share your version of BW and I can check?

      Author's profile photo Michael Hamm
      Michael Hamm

      Tested with BW 7.40 SP14 including 2283045, AO 2.3 SP01, DS 1.6 SP2 P1, BIP 4.1 SP08

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

      Michael:

      Please look at SAP Note https://launchpad.support.sap.com/#/notes/2283045/E - this had to be installed on one of our sandboxes for the functionality to work.  Have you looked at this note, applied the patch and you are experiencing issues?

      Author's profile photo Michael Hamm
      Michael Hamm

      I just saw it on the roadmap RRI as receiver for AfO is only possible with SAP BW and not on BIP.. 😡

      i opened an request on Ideaplace for this feature: OpenDoc with variables / RRI for AfO within the BI Platform : View Idea

      BR,

      Michael

      Author's profile photo Mario Panzenboeck
      Mario Panzenboeck

      Hi Michael,

       

      did you manage to solve this problem?

      We are facing the same issue - our workbooks are stored on BIP server and we want to implement RRI interface.

      I also saw the idea on influence.sap.com - they say this feature is delivered with 4.2 SP5 but there´s no corresponding note?!

       

      Thank you!

      Author's profile photo Markus Hagedorn
      Markus Hagedorn

      Yes, thank you.

      Author's profile photo Bob Dunsford
      Bob Dunsford

      Question: How can we set the Subsequent Refresh property to "Log off and Reconnect" as a default setting for all workbooks?

      /wp-content/uploads/2016/07/2016_07_14_9_28_27_995419.jpg

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

      Hi Bob - I don't know; I recommend creating a new discussion on this question.

      Author's profile photo Former Member
      Former Member

      Hello everyone,

      i´m trying to jump from Analysis 2.3  with RSBBS in a SAP Transaction, for Example KSB1. It´s possible but i have been directed into the web and i wanted to open the transaction directly in the SAP System. How can i achieve this? Can somebody help me. Thank you!

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

      Hello Nadina - please review the SAP Notes

      https://launchpad.support.sap.com/#/notes/2283045/E

      https://launchpad.support.sap.com/#/notes/2304137/E

      If you have more questions after reviewing, please create a new discussion

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      short question -> Jump target functionality to Analysis Office workbook doesn't work with SAP NetWeaver 7.01. Am I right?

      Regards,

      Gerardo

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

      Hi Gerardo - please see server prerequisites in SAP note 2283045

      Author's profile photo Hakan Keles
      Hakan Keles

      Hi Tammy,
      I have an issue with a planning Scenario.

      The Business department wants to plan data and in this context they want to add / push back manually data lines into the source (cube).

      I found the Default value 5 in the design area of Analysis and I have read that in former Versions (1.x)  the absolute limit was 1000 regarding this.
      Is this now increased?
      and how can we understand this Limit? is it the number of data lines or is also the combination of characteristic values important (such like a 'Limit of possible combinations of values')?

      Thanks and regards,
      Hakan
       

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

      Hello Hakan - I am not using planning; I recommend asking this as a question at answers.sap.com so the community can assist.

      Author's profile photo Former Member
      Former Member

      When jumping from a BEx rerpot to an Anakysis office workbook.document - should the system be passing parameters and thus maintaining the point-of-view?

      When i set up RRi (via RSBBS) betwwen two bex reports, this is the behavior,. We recently upgraded to AFO 2.4 and was glad to see it supported RSBBS, but after testing, it seems it only jumps to the AFO workbook in general, but does not pass parameters that are defined in the RSBBS Assignment Details?

       

      Can anyone shed light on this?

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

      Brad - please see https://blogs.sap.com/2016/08/14/report-to-report-interface-analysis-office-to-ecc-transaction/ - does this help/answer your question?