Analysis Office 2.4 Workbook Protection and Styles

A new feature of Analysis Office 2.4 is workbook or sheet protection. It is similar to the Microsoft Excel Protect Sheet / Workbook function, but it is also different. When you need to protect your workbook or sheet and you use the Excel functionality, you can not refresh or drill down your Crosstab. But when you want to refresh your data or give the users the opportunity to drill down or filter, you have to use the workbook / sheet protection from Analysis Office.

Analysis Office Protect Options
Analysis Office Protect Options

You can define almost the same options like the normal Excel function. But if you protect your workbook or sheet with this function, the Excel ribbon also shows the protection. But if you remove it from there and and set it again with another password, it is no longer the Analysis Office protection, it is the Excel protection, which means you can not refresh or drill down anymore.

Microsoft Excel Protected Sheet
Microsoft Excel Protected Sheet

Instead you receive the following message. So be aware of which protection you use and communicate this also to your colleagues.

Analysis Office Excel Sheet Protection
Analysis Office Excel Sheet Protection

If you use Analysis Office IP you now have a new custom style called SAPError. This style shows you information if something in your planning doesn't work correctly. When you enter your value you can simply autocomplete them. Enter a prefix for a member and use F4/value help or CTRL-Space (autocomplete).

SAPError
SAPError

Normally you get also a message, but if you have suppress all messages, you don't see them.

Analysis Office Integrated Planning Message
Analysis Office Integrated Planning Message
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0