Ну и напоследок пример того как можно использовать VisualBasic для доступа к EssBase
Drill-Through from an Essbase cube or a Planning application is a fairly common requirement. There are a couple of ways to do it: EIS, Essbase Studio, FDM, etc. The main drawback of most (probably all) of these tools is that the cube/application needs to be built from the ground up using one of these tools. There are a couple more drawbacks in some of the tools like upper level drill-through, retrieval speed and format of the returned data so there is some kind of compromise that has to be made. Business users do not necessarily see eye to eye with the consultants or hyp-admins when it comes to compromises.
Drill-through can also be done in reporting products like Web Analysis and OBIEE however the link between users and Excel cannot be broken easily.
Dealing with the Essbase API from .NET apps is a headache due interop, so I managed to wrap the Essbase MaxL API in a C++/CLI project and simplify my life developing Essbase admin features.
A working Essbase client or server is required. The wrapper depends on unmanaged DLLs. I have used Visual Studio 2010 and Essbase 11.
Essbase C API and .Net does not appear to be the hottest topic on the net, probably for obvious reasons, but somebody might find this useful. Working with the Essbase C API is fairly intuitive (after a while) and if imagination helps great products can come out.
Here are the steps to get the Essbase C API working in C# :
Хочу обратить внимание на сайт biwed.ru, в котором на живых примерах описываются приемы анализа данных, как в электронных таблицах, так и в кубах.