This blog shows how to solve the issue when the drill through in Excel fails and following error message appears: XML for analysis parser error: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.
This blog shows the Excel formulas CUBEVALUE and CUBEMEMBER for advanced self-BI in Microsoft Excel. The example report compares actuals and budget of sales grouped by item group and month.
When installing coresuite cube, the load jobs will be triggered by default at midnight. What is, when the CFO makes some financial transactions and want to see the result immediately in his Excel-Report based on the cube?
Hardcopy, which I used now for years looks quite old-fashioned. Some time ago, my colleague showed me Greenshot. The tool is as simple as Hardcopy, but looks much better and has some additional features.
I’m just testing the SAP forms extender which will be part of coresuite customize in one of the next country package releases. It is a nice tool, which gives additional possibilities to optimize the appearance and handling of user defined tables. To show, how this tool works, I use a small use case, which I implemented on a customer project
With the patch 08 of SAP B1 8.81, there is a small integration to bi.ondemand.com. This blog post shows, how it works.
What was already possible in the B-Cluster of SAP 2007, is now also possible with SAP 8.81 for the different localizations: Multi dimensional distribution rules, mandatory distribution rules, manual distribution rules. Here you find a small overview, how it works, and how it is possible to browse the data in Excel with the coresuite cube.
In SAP 8.8, there are new fields for contact persons. It’s now possible to define a First Name and a Last Name. But as before, you need to define the Contact ID. Now the users need to type in the names twice. The script which you can download here, helps to fill out the first and last name automatically.
Xmarks will stop the service in 2011. So I tried Firefox Sync, a very comfortable tool to synchronize your passwords and bookmarks between your computers.