| Author |
Accessing repository via DSO
|
|
|
| Does anyone know if there is anyway for me to access the repository
connection string using the DSO library?
I am working with Analysis server and I want a quick way to get the list of
Cubes? If I can get this connection string I should be able to query the
OLAPObjects table for what I need. I think this will be quicker than
looping through each database.
Thanks
| |
| Darren Gosbell 2006-03-28, 7:29 am |
| No, I don't think you can get the repository connection string from DSO.
And it is not a good idea to access it directly anyway.
I have a VBScript on my blog that will use DSO to list all the cubes and
their sizes. You should be able to adapt this script to your particular
needs.
http://geekswithblogs.net/darrengos...cles/70585.aspx
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <OqB2aVfUGHA.5828@TK2MSFTNGP10.phx.gbl>,
mfraser@henwoodenerg
y.com says...
> Does anyone know if there is anyway for me to access the repository
> connection string using the DSO library?
>
> I am working with Analysis server and I want a quick way to get the list of
> Cubes? If I can get this connection string I should be able to query the
> OLAPObjects table for what I need. I think this will be quicker than
> looping through each database.
>
> Thanks
>
| |
|
| Thank you.
"Darren Gosbell" <jam@newsgroups.nospam> wrote in message
news:MPG. 1e93c7fe8f7325579898
d2@news.microsoft.com...[color=darkred]
> No, I don't think you can get the repository connection string from DSO.
> And it is not a good idea to access it directly anyway.
>
> I have a VBScript on my blog that will use DSO to list all the cubes and
> their sizes. You should be able to adapt this script to your particular
> needs.
>
> http://geekswithblogs.net/darrengos...cles/70585.aspx
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <OqB2aVfUGHA.5828@TK2MSFTNGP10.phx.gbl>,
> mfraser@henwoodenerg
y.com says...
|
|
|
|