MS SQL Server OLAP - cube browser control in 2005

Author

cube browser control in 2005

bren@ebesser.com

2005-12-15, 8:25 pm

I'm creating a Windows Forms application in which I want to display
tabular results from an MDX query (results with only two axes, achieved
by submitting an MDX query through an OLEDB connection.)

In SQL Server Management Studio 2005, when connected to an Analysis
Server, there is a Cube Browser (right click on a cube and select
"Browse".)

I would like to have a .NET control to put on my Form just like the
results pane of this browser.

I don't need the interactive graphical query capability. I will define
the query in the code behind.

I've been trying to use a third party grid control, but they are not
designed to do what this control does. Mainly expand and collapse rows
and columns the way this browser control does. (I really only want to
expand and collapse rows, with fixed columns.)

Is this control available to be referenced in a .NET application? Is
there a similar third party control? HierCube from RadarSoft might work
but it only binds to it's own cube definitions, not to MDX query
results from SSAS. I don't even want to bind to a cube, only to tabular
results, like in Reporting Services reports.

If you've even read this far, thanks.

Thanks, Bren

Darren Gosbell

2005-12-19, 7:24 am

The browser in BIDS is a derivative of the Office Web Components OWC,
you can embed these in your own application. The end users do need to
have an Office license, so this is really only suitable for an internal
application.

This control is an ActiveX control, so you would add it to your VS.NET
toolbox by browsing for it as a COM component.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1134684399.186926.269150@g14g2000cwa.googlegroups.com>,
bren@ebesser.com says...
> I'm creating a Windows Forms application in which I want to display
> tabular results from an MDX query (results with only two axes, achieved
> by submitting an MDX query through an OLEDB connection.)
>
> In SQL Server Management Studio 2005, when connected to an Analysis
> Server, there is a Cube Browser (right click on a cube and select
> "Browse".)
>
> I would like to have a .NET control to put on my Form just like the
> results pane of this browser.
>
> I don't need the interactive graphical query capability. I will define
> the query in the code behind.
>
> I've been trying to use a third party grid control, but they are not
> designed to do what this control does. Mainly expand and collapse rows
> and columns the way this browser control does. (I really only want to
> expand and collapse rows, with fixed columns.)
>
> Is this control available to be referenced in a .NET application? Is
> there a similar third party control? HierCube from RadarSoft might work
> but it only binds to it's own cube definitions, not to MDX query
> results from SSAS. I don't even want to bind to a cube, only to tabular
> results, like in Reporting Services reports.
>
> If you've even read this far, thanks.
>
> Thanks, Bren
>
>

michael v

2005-12-19, 7:24 am

Do you have info on changes in this owc component ?

Will it still be supported like now when excel 12 arrives ?

"Darren Gosbell" <jam@newsgroups.nospam> wrote in message
news:MPG. 1e113e49d715ecc89898
27@news.microsoft.com...
> The browser in BIDS is a derivative of the Office Web Components OWC,
> you can embed these in your own application. The end users do need to
> have an Office license, so this is really only suitable for an internal
> application.
>
> This control is an ActiveX control, so you would add it to your VS.NET
> toolbox by browsing for it as a COM component.
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <1134684399.186926.269150@g14g2000cwa.googlegroups.com>,
> bren@ebesser.com says...
>

Darren Gosbell

2005-12-20, 7:23 am

> Do you have info on changes in this owc component ?
>
> Will it still be supported like now when excel 12 arrives ?

I don't know for sure, but the fact that MS are using it in BIDS would
be promising.

A couple of the bloggers I read have posts about Office 12, possibly if
you contacted one of them through their blogs they might know.

Nick Barclay - has been to Redmond as part of the Office 12 TAP
http://nickbarclay.blogspot.com/

Chris Webb - is participating in the Office 12 Beta
http://spaces.msn.com/members/cwebbbi

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

Sponsored Links