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
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
You see the last data update of your multiprovider
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
And you can logoff now from Analysis Office; this is a long-standing request from the ASUG Analysis Influence Council More to come.
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.
as you can read in this post under "Highlights: Table Design Editor" you can only edit formats and new lines at the moment.
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.
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.
OK I see what you mean. I never thought in this way. Thanks for the explanation.
Wow....you are really very fast.....thanks for sharing the information.
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.#
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?
Yes, I have. Excactly the same behaviour in our system.
Try this by enabling below option.
This option is already enabled. Otherwise you will never get a logon screen in combination with SSO.
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,
I have got the same answer some minutes ago. But this is the opposite:
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 ...
If Excel is closed and opened again this is definately a new session.
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.
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.
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.
2283045 - BBS: Support für neue Berichtsart 'Analysis Office' als BBS-Empfänger
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)?
Markus - if you have set up RSBBS in BW you can still use when deploying to the BI platform. Does this answer your question?
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.
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"
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: could you share your version of BW and I can check?
Tested with BW 7.40 SP14 including 2283045, AO 2.3 SP01, DS 1.6 SP2 P1, BIP 4.1 SP08
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?
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
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?!
Yes, thank you.
Question: How can we set the Subsequent Refresh property to "Log off and Reconnect" as a default setting for all workbooks?
Hi Bob - I don't know; I recommend creating a new discussion on this question.
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!
Hello Nadina - please review the SAP Notes
If you have more questions after reviewing, please create a new discussion
short question -> Jump target functionality to Analysis Office workbook doesn't work with SAP NetWeaver 7.01. Am I right?
Hi Gerardo - please see server prerequisites in SAP note 2283045
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,
Hello Hakan - I am not using planning; I recommend asking this as a question at answers.sap.com so the community can assist.
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?
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?