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.
Every chapter has a lot of videos to explain certain functions in detail. You can also view some letures as a preview for the course so have a look into it. Here are some examples with to show you what you can expect.
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:
So its not much but after SAP released the standalone addin for SAP Analytics Cloud, they still working on Analysis for Office.
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.
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 specify the mode for creating formulas with Table Design. And in the planning area there is a new setting called PlanningFunctionUploadFolder, which allows you to upload the values for executing planning objects from a file.
So it is nothing big, but Analysis Office is still developing and not dead, even if there is a new SAC Addin. I hope there will be some feature I submitted.
The SAP Transport Dependency Check (TDC) is a little tool that helps you to find corresponding transport requests in your SAP NetWeaver Business Warehouse which are not imported yet in your target system (e.g. production system). First you have to enter a transport request you want to check and also a target system and the last considered date (e.g. last go live).
The online help is not updated, but will be in a few days I think. Also the special addin for SAP Analytics Cloud 2.8 SP2 is released. If you have any questions feel free to ask.
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 have any questions or need any help, don't hesitate to contact me.
Until now, we speak of Analysis Office 2.8, if you have different text maintained for an infoobject, Analysis Office shows only the short text in the prompt dialog. The maintenance view of the InfoObject shows all different texts.
It is done, the latest version of my book Analysis Office - The Comprehensive Guide is available. It was a lot to do and so the book has now 346 pages. The 4th edition had only 299 pages. So there is some new stuff inside. The first 5 who contact me will get a promo discount code. Also I am happy if you want to write a review you get a review discount code.
So you can buy it in the store. In future I will create more videos if there is any interest. So please leave a comment.
Yeah finally is Analysis Office 2.8 available. It took a long time. Here is a overview what's new.
This are some sweet features even not everything is running smoothly.
Since last week the latest version of Analysis Office is available. I installed it right away and want to test it. And what I have to see? You cann't add hierarchies into the rows or columns of your crosstab. I tried to record it maybe you can see it in the video below.
This week I discussed with a colleague. He ask if there is any way to filter multiple entries in a hierarchy because there is no Paste or Upload function in the hierarchy filter dialog.
The Analysis Office Workbook saves a lot of information in it. The Microsoft Excel format xlsx is a container which can save a lot of other information besides the normal data. When you rename a xlsx file to a zip file you can extract it with for example 7-Zip. Now you see the following folder structure.
Now the book Analysis Office - The Comprehensive Guide 4th edition is now available via digistore24.com. You can use credit card, paypal and other payment options.
The latest version of Analysis Office is now available. It was released on 27.09.2019 and after the go live of my project is now done, I may have time to look more into Analysis Office again.
As you can see in this version there is not many things fixed or maybe they found not more? But the What's new Guide lists some new file system settings (technical parameter)
The admin guide now documented now all these parameters. A nice parameter is UseKeyForHierarchySelection, which allows you to define if you want to see the keys of a hierarchy in the first coloumn or second column of your prompt.
I just got an email from you via the contact formula. But When I answer to your email or to your shop order, I get an error "The email account that you tried to reach does not exist." I tried it several times, maybe your account is full? So can you please provide me another mail address or contact information? Maybe via Linkedin or so?
Thanks, I don't know any other way to contact you :)
Until the end of the month you can get my book with 30% off. Just use the discount code Summer2019. You can buy it here.
It's a kind of summer break at the moment and I haven't done a lot for this blog in the last time. But SAP now release the 7th service pack of Analysis Office.
You can now use the filtering data access mode with SAP Analytics Cloud data sources, analytic and planning models. There are also 3 new file system settings:
The setting ShowCutCopyPasteInGridContextMenu allows you to sepcify whether the cut, copy and paste entries should be available in the context menu for a crosstab cell. The setting EnableImprovedAddInCompatibility should improve the compatibility with other Microsoft Office add-ins. How this work we will see.
The setting UseSeparateDisplaySettingsForFilterDialog you can define if the display settings defined in the filter dialog should be saved with the workbook.
So as you can see nothing spectecularit fixes also a little bit:
I am still looking for Analysis Office 2.8, but now I am first enyoing my vacation.
Life experiences of a SAP Business Warehouse Consultant