dbTalk Databases Forums  

How to fill a selectbox with cubenames?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to fill a selectbox with cubenames? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Helma Schapendonk-Maas via SQLMonster.com
 
Posts: n/a

Default How to fill a selectbox with cubenames? - 01-10-2005 , 04:28 AM






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?
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

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: How to fill a selectbox with cubenames? - 01-10-2005 , 05:51 PM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.