Skip to Content

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.

To report this post you need to login first.

35 Comments

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

  1. 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

    (0) 
    1. 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

      (0) 
      1. 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

        (0) 
  2. 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

    (0) 
    1. 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

      (0) 
          1. 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

            (0) 
            1. 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

              (0) 
  3. BPC tech

    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.

    (0) 
    1. 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.

      (0) 
  4. 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.

    (0) 
  5. 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)?

    (0) 
    1. Tammy Powlas 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?

      (0) 
      1. Philipp Schornberg

        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

        (0) 
        1. Tammy Powlas 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”

          (0) 
          1. 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

            (0) 
  6. Nadina Flögel

    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!

    (0) 
  7. Gerardo Rendina

    Hi Tammy,

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

    Regards,

    Gerardo

    (0) 
  8. 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
     

    (0) 

Leave a Reply