Hi all,
Browsing a cube using SQL server management studio and Analysis servcices project is possible. Is there any possibility to have custom application built to have the option of browisng without opening Studio management or analysis services project?
Purpose of this is simple. End user should simplay have measures and dimensions and he will just drag and drop in to the browse area.
One thing I really like about Microsoft is that almost anything is possible 
. Programming one cube/dimension browser yourself is quite an interesting task. I'd use AMO to get the cube and it's dimensions structures, and then I'd use those to build up MDX queries when the user drags-n-drops. To enumerate the cube and dimensions is very easy using AMO. The hard thing here is to convert the drag-n-dropping into well formed and accurate MDX. Like did they drop on columns, rows, as a filter etc? Which hierarchy and level did they expand/drill down?
Some resources:
Query using C#: http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=640
AS objects: http://technet.microsoft.com/en-us/library/ms124924.aspx
There is a good example on how to enumerate an OLAP db in the SQL Server samples, which can be downloaded here:
http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
After installation the AMO browser is located at c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AmoBrowser\
Else there is this ProClarity browser which allow end users (say management) to browse a cube in an intuitive way, but that one costs $$$.
No comments:
Post a Comment