Hi Guys

New to analysis services, is there a way to retrieve the underlying fact
table name for a cube by using MDX, or quering the metabase in SQL?

The cube isn't paritioned in anyway.

Thanks in advance

Using DSO, yes.
Get a copy of the Metadata Scripter from the SQL Server 2000 Resource Kit.
It will generate VB6 code which shows you how to walk the DSO to get this
info.

If using managed code, then look at the source distribution of the DSO/XML
utility.
http://www.microsoft.com/downloads/d...displaylang=en
--
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.


"Brett" <Brett (AT) discussions (DOT) microsoft.com> wrote