My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.
So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?
Hi,
I am also facing the same problem.
Ronald
|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.
Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).
