Schlagwort: analysis for office

Since 13.01.2017 the SP1 of Analysis for Office 2.4 is available. You can download it here. You need a S-User to download it.
There are three new file system settings:

• UseDataSourceDeltaUpdate
• EnforceDatePickerForCalendarDayVariable
• SetEmptiedDoubleDataCellsToValue0

There are also some changes in the User Interface Customization.

You can now create, delete and reorganize groups and elements. A nice feature too is when you create a toggle button, you can get the button state. This I haven’t tested yet, but it could be very
useful. About the file system settings:

• UseDataSourceDeltaUpdate

The default value is true and you can use this setting to specify if you only want the delta data or the complete data of a data source when you reload or update. If you change it to false, the
complete data of the data source will be reloaded. I don’t know if this setting makes so much sense but maybe someone use it.

• EnforceDataPickerForCalendarDayVariable

The default value is false, this means the date picker is not enabled and the dates are displayed in a list. If you change it to true, you get a date picker and also there is no fetching of date
values from the backend system. This is very useful, many threads in the SCN are about the date picker problem. Thanks.

• SetEmptiedDoubleDataCellsToValue0

The default value is true, this means if you save empty planning data cells, they are saved as 0. If the value is false, the old value remains and the cells are not saved as 0. I don’t know if
some „features“ are necessary when you see that there are other problems like this.

These posts might also be interesting:

• Analysis for Office 2.3 is available
• Analysis for Office 2.4 Table Design features
• Analysis for Office 2.4 File System Settings
• Analysis for Office 2.4 SP2 is released

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.

A new feature of Analysis for 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 for Office.

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 for Office protection, it is the Excel protection, which means you can not refresh or drill down anymore.

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

If you use Analysis for 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).

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

These posts might also be interesting:

• What’s new in Analysis for Office 2.4
• Analysis for Office 2.4 Customize User Interface
• Analysis for Office Cancel long-running Queries
• Analysis for Office Infofields, formulas & Dashboard functions

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 2.4 also provides new file system settings. Especially for the new Customize User Interface function. The file Cof_app.config provides all these parameters:

• AppBuilderDefaultProfilePath
• AppBuilderUserProfileDirectory
• AppBuilderCompanyProfileDirectory
• AppBuilderReadOnlyProfileDirectories

And also these parameters:

• CurrentCodePage
• SapWebGuiPath
• NwbcTicketIssuerPath

Only then AppBuilderCompanyProfileDirectory is a PerMachine parameter, the others are UserRoaming. How the other parameters exactly work has to be tested. The
Ao_app.config also provides new parameters:

• DefaultBWQueryDesigner
• DoSelectorHierarchyExplicitSelection
• AutoCompleteFetchMemberLimit
• HanaHttpConnectionTimeout

So it can be possible that the user can choose between the old BEx Query Designer and the new BW
Modeling Tools. The default parameter is „0“, so at the moment I cannot say what exactly has to be the value for other query designers. The parameter
DoSelectorHierarchyExplicitSelection should select only the child nodes of a node and the parent node is not automatically checked. But I haven’t got a chance to test this. So I
can’t confirm this. I don’t know at the moment how the parameter AutoCompleteFetchMemberLimit works, I only know the default value is 30. But as soon as possible
I add these information to this post.

These posts might also be interesting:

• What’s new in Analysis for Office 2.4
• Analysis for Office Table Design, API and Design Rules
• Settings for the Analysis for Office Plug-in
• Analysis for Office Variable Operator Contains Pattern

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.

A new feature of Analysis for Office 2.4 is that you have a function called Customize User Interface. On the
first view it looks similar to the Excel customize ribbon function. But it has more flexiblity to switch between different interfaces. First you have to open the Customize User
Interface dialog via File >> Analysis. The following dialog appears.

To define a new profile you have to click into the drop down box and enter a name, e.g. reyemsaibot. After you entered your profile name, the save button is active.

After you saved your profile, you can delete it or set it as standard profile.

Now you can modify the ribbon interface by select or unselect the groups and elements. If you want to add a own function, make right click and add a New Group.

You can now define the group.

After you add the group, you are able to add your own elements to this group. Make a right click and select New Element. You can choose between Button,
Separator, Split Button and Toggle Button as element. For all elements except for Separator you have to define a
Label, Macro, Size and an Image.

For example I add a Button Open Workbook and choose my macro SAPOpenWorkbook. You can choose your macro either in this workbook or in an external source like a
Excel add-in. So you are able to design different interface for different people or use cases. The interfaces are stored under
C:Users<User>AppDataRoamingSAPCofUser Interface. There you find a xml and an image folder, in which are the selected images are saved.

If you want to distribute them in your company, take these files (xml and the image folder) and move them to C:ProgramDataSAPCofUser Interface. Now it is a company user
interface and can’t be deleted by the user.

If there is any question feel free to write a comment. I think it is a cool feature if you want to restrict the view of the ribbon and distribute it in your company. If it will be used a lot,
will we see in the future. So stay tuned for other Analysis for Office 2.4 content.

These posts might also be interesting:

• What’s new in Analysis for Office 2.4
• Analysis for Office SAPInsertLine
• Analysis for Office Cancel long-running Queries
• Analysis for Office Save Query View

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.

Since yesterday Analysis for Office 2.4 is available. You can download it with a S-User under Support Packages and Patches >>
By Alphabetical Index (A-Z) >> A >> SBOP Analysis Office >> SBOP Analysis MS Office 2.4.

The SAP help page isn’t updated yet. But I think it would be updated in the next days.

A new feature is to protect your workbook. You can choose between the complete workbook and only
sheet protection. It seems like a stripped down protection from Microsoft Excel. Why this should be necessary must be clarified.

Also a new feature is to load and save comments directly from the SAP Business Objects BI platform. How this exactly works I
have to discover. A really cool feature is the Customize User Interface where you can
easily configure different user interface. Maybe you can also configure them through the file system
settings.

You can now define in the properties of the design panel to set a dimension to No Display.

The Table Design Rules editor now has a copy button, if the previous restrictions are obsolete now, have to be seen. You can now also exlcude copy and paste values from clipboard or file.

Also new is Link Dimension. This means when you filter on the main Crosstab it will also affect the linked Crosstabs. You can see the little icon that indicates the Crosstabs are
linked.

A really cool feature is Group Crosstabs. This means, that you combine to Crosstabs to one.

Here is the result of the Group Crosstabs.

So a first look at Analysis for Office 2.4 is done. I hope SAP release the necessary help files so we can found more about this version.

These posts might also be interesting:

• Analysis for Office 2.2 SP2
• Analysis for Office Cancel long-running Queries
• Analysis for Office Excel formula video
• Analysis for Office SAPInsertLine

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.

After @xjhacking conviced me or say talk round, here is a one day offer for my book Analysis Office – The Comprehensive Guide. You can buy it for 9,99 € until tomorrow evening.

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.

Here is the post Analysis for Office: How to work with Excel formulas as a short video.

More about Excel formulas and Table Design can be found in my book.

These posts might also be interesting:

• Analysis for Office SAPOpenWorkbook
• Analysis for Office Workbook vs. DataSource Variants
• Analysis for Office Infofields, formulas & Dashboard functions
• Analysis for Office 2.1 Logoff via VBA

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.

Since Analysis for Office 2.3 was released, you are able to cancel long-running queries. In the Ao_app.config you can define the
parameter CancelPopupDelay. The default value is 5 seconds. You can change this setting to specify after how many seconds the cancel dialog should be displayed. The dialog could
appear when you inserting a data source or navigating through the data and it took more than 5 seconds.

If the dialog is displayed, you could press „cancel“ to cancel the server request. In the following message dialog, you can select restart to go back to the workbook and the data source is
active. Or you select close to go back to the workbook and the data source is offline. If you don’t cancel the request, the dialog will disappear automatically
when the server request is completed.

These posts might also be interesting:

• Settings for the Analysis for Office Plug-in
• Analysis for Office 2.3 features
• What’s new in Analysis for Office 2.4
• Analysis for Office 2.2 SP2

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.