Yes, this is easy to do.
Look in BOL for the topic: OLAP Schema Rowsets
There is a structure called "MDSCHEMA_CUBES" which returns the available
cubes.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Helma Schapendonk-Maas via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote in
message news:f6946d1efa2645929ef41bba695b8130 (AT) SQLMonster (DOT) com...
Quote:
In my project I want to have an overview of cubes in our database via an
ASP page. It's possible to print the names on the screen, but is it also
|
possible to gather the cubenames in a select box?
Quote:
Normally I use the VB object array to do this. Can I use this also or does
something else exists, like a DSO object?
--
Message posted via http://www.sqlmonster.com |