take a look at the ADOMD.NET API
you'll found everthing you need
create a connection using the adomdconnection object
then choose the database you want
then list the cubes & dimensions etc... in this database
you'll found samples into the BOL.
<rahulchudiwal (AT) yahoo (DOT) com> wrote
Quote:
Hi,
I am new to analysis services 2005. In fact new to the world of BI.
How can I query meta data for an OLAP database? Basically I want to
find out what are different cubes, dimensions, hierarchies in my
database. Is there a script sample someone have?
Thanks,
/R |