Analysis for Office
Analysis for Office · 16. April 2021
Since last week Analysis for Office 2.8 SP8 is available, and you can download it with your S-User. I just got a question if I could write about it, so here are the notes which fixes some bugs: AO 2.x: Template for patch for AO and AO_SAC (s-note 3035301) AO: SAC Live Data Connections - Input Readiness of BW planning queries can't get restored when opening a saved workbook (s-note 3038493) Array formula cannot be updated via VBA (s-note 3017643) BW OLAP Connection in Analysis Office Workbook...
Analysis for Office · 30. November 2020
Since last Friday the latest version of SAP Analysis for Office is now available. You can download it in the SAP Launchpad. As the last version we have some bugs which are now hopefully fixed: All crosstabs are removed from workbook (s-note 2990456) Date picker control using wrong calendar or chosen date is incorrect (s-note 2981896) Exception when saving a workbook with a chart sheet (s-note 2981234) Search result does not show translated texts (s-note 2977530) Planning sequence execution uses...
Analysis for Office · 16. October 2020
Since a couple of days the latest version of Analysis for Office 2.8 is available. Michael was a little faster and notice it on Twitter before me. So let's look into it. SAP fixes a bunch of bugs with this service pack. Here is an overview: AO 4 SAC: \"Group Members\" functionality not available when using BW Live Data Connections (s-note 2962476) AO: BEx Workbook Conversion - An exception occurs when trying to save a converted BEx workbook which contains formulas (s-note 2965890) Action has...
Analysis for Office · 02. July 2020
My video course about Analysis for Office is done. It will be released on 06.07.2020 @ 8:00 am MESZ. You find it under video.analysisoffice.net and you get more than 4 hours of 4k content for only 199€. The content will be extended if it is necessary. Here is a overview of the curriulum. Installation and Configuration Customize Analysis Office Basic Functionality Advanced Funtions Reporting with Analysis API and VBA Every chapter has a lot of videos to explain certain functions in detail. You...
Analysis for Office · 08. June 2020
I know its been a while since the last blog post. But I am currently working on the Analysis Office Video course to get it done. When you follow me on Twitter or Linkedin you get an update all the time. But back to topic. Analysis Office 2.8 SP3 is available almost over one week so let's look into it. These bugs are fixed now: #VALUE error for hierarchy leaves in SAPGetData in Fomula-optimized mode (s-note 2928899) BAdI is not executed when launching (s-note 2923786) Exception After Deleting an...
Analysis for Office · 21. April 2020
Currently I am working on my Analysis Office Video Course. It will be a full discover of Analysis for Office. So if you are interested in it, you can join the list to get a special price when it will be launched. Thank you for all your support.
Analysis for Office · 20. April 2020
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
Analysis for Office · 03. April 2020
After the latest service pack of Analysis Office 2.8 was released this week, the online help is now available. Analysis Office now offers a button for creating and deleting of comments in the ribbon menu. In former versions, SAP used the text of Microsoft Excel for comments. As Microsoft renamed the comments to notes, it was inconsistent in the ribbon and the context menu. Now it is consistently again. Also new is the file system setting UseLegacyModeForFormulaContext which allows you to...
Analysis for Office · 30. March 2020
Since today the latest version of Analysis Office 2.8 (release notes) is available. You can download it with your s-user in the SAP Support Portal. There are only a few fixes: AO: BEx Analyzer Workbook Conversion - Not all filters of Text Element converted (s-note 2902130) Chart Data Series are added again as Chart Data (s-note 2898931) Exception thrown when the login process is interrupted (s-note 2900972) Hierarchy selection disappears after confirming Filter Dialog in case of HANA (s-note...
Analysis for Office · 18. March 2020
If you want the latest edition of Analysis Office - The Comprehensive Guide, you can get it now with a 20% discount until easter 2020. Use the code Easter2020 in the online shop. If you want to read a review first, have a look at the review from Tammy Powlas or from Xavier Hacking. Tammys review is about the 3rd edition and Xaviers about the 1st edition. If you have any questions or need any help, don't hesitate to contact me.