Analysis Server 2005 question

Hi all,
My apologies if this is off-topic in this N.G. but I'm stumped on this one!
I'm playing around with Analysis Server 2005 and specifially the Business
Intelligence Studio.
I've managed to get a basic cube setup and am playing around in the browser
tab of studio and really like the capabilities.
Heres my problem:
Thusfar, I've looked all over but found no activeX control or anything
similar to the browser I refferred to above. Is there any client-side gui
like that browser that I could use in a web-based application. I can't
believe Microsoft would provide such good server-side tools without a
corresponding client-side gui-type browser (I do believe the end goal of
cube creation is for the end user).
Is there any client-side way for me to do this or do I have to pay a fortune
for a 3rd party solution?
If I do have to pay for a solution then to anyone from MS reading this -
thanks for nothing.
Regards
John.The typical way for an end-user to browse a cube is using the pivot table
feature of Excel.. It allows them to connect to a cube and browse the data
similiar to what you see in the intelligence studio. With 2005 there is
also a sharepoint web part that allows this. There may be other controls
(Do a net search on pivot tools or something similiar)
"John" <a@.b.com> wrote in message
news:ebRD2Hj6FHA.2040@.TK2MSFTNGP14.phx.gbl...
> Hi all,
> My apologies if this is off-topic in this N.G. but I'm stumped on this
one!
> I'm playing around with Analysis Server 2005 and specifially the Business
> Intelligence Studio.
> I've managed to get a basic cube setup and am playing around in the
browser
> tab of studio and really like the capabilities.
> Heres my problem:
> Thusfar, I've looked all over but found no activeX control or anything
> similar to the browser I refferred to above. Is there any client-side gui
> like that browser that I could use in a web-based application. I can't
> believe Microsoft would provide such good server-side tools without a
> corresponding client-side gui-type browser (I do believe the end goal of
> cube creation is for the end user).
> Is there any client-side way for me to do this or do I have to pay a
fortune
> for a 3rd party solution?
> If I do have to pay for a solution then to anyone from MS reading this -
> thanks for nothing.
> Regards
> John.
>sql

AMO: refresh DSV and accept changes..

I tried the sql server OLAP newsgroup, but without success... this is fairly urgent, so will try in here:
I am stumped on this, how can I programmatically do what can be done in
Visual Studio by:
1. Right clicking inside datasource view
2. Choosing refresh
3. Accepting the changes

I am trying to get new fact table columns into the DSV, obviously
without doing the manual steps above.

I have tried dsv.Refresh() and dsv.Update() but it is not as simple as
that or the sequencing is incorrect (or, most likely, I am looking in
entirely the wrong place).

Thanks for any help.

There is no programmatiic way to do refresh on DSV. However, You can use data adapter to fill schema and get a new datatable and merge the table yourself.

For adding a column, you can use data adapter to do FillSchema() with the table you want to refresh and add the new column into existing table. Finally, call DSV.Update().

|||Thanks for the response - this was pretty much the only way we could solve this as well.... but why isn't the method that MS uses to do this exposed for our use as well? It seems like they have a pretty efficient way of doing this. Nearly everything else allows you to "script the action", why not this?
|||This refresh of DSV from relational DB is part of the execution of DSV but not on AMO. Although we found that it is useful if we move the code to AMO, it is to late of the cycle. Since it has work around, so we cut this feature. We will consider it in next release. Thanks