tag:blogger.com,1999:blog-4019598559914347729.post6661347864949141696..comments2024-02-09T04:19:32.395-06:00Comments on Tim Tow's Hyperion Blog: How Does the Essbase Excel Add-in Work? (Part 1)Tim Towhttp://www.blogger.com/profile/01455458983202814616noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4019598559914347729.post-65653730081441500752011-12-16T10:27:49.581-06:002011-12-16T10:27:49.581-06:00This is very interesting. As I had to replicate ...This is very interesting. As I had to replicate similar logic in a custom solution, I find that the logic here is very efficient but certainly has some shortcomings. For example, if there is only one member of a specific dimension, it should not matter at all where on the sheet it is. Also, when you have a bad member name (especially if the outline changes), the Essbase addin isn't terribly friendly. It will ignore it if for example it is a row header, but if it happened to be a row header with another column of row headers to the right, it may just replicate the data above it (which is likely worse than being blank). Multiple ranges per retrieve should also be supported because if you and I can inherently associate which members apply to which data points, the system should as well. But overall an efficient tool that has lasted for quite a while.SickSkilzhttps://www.blogger.com/profile/05548564193204303895noreply@blogger.com