Can someone give me a quick example of an MDX query that lists
dimensions on a cube? Also another example for determinining an MDX
query to list measures of a cube.

thanks for any and all help,

Scott

To obtain OLAP schema information, such as dimensions in a
cube, cubes in a database, and so on, you should use
OLE DB for OLAP schema rowsets.
The MDX Select statement is designed to retrieve data from
a cube, not the cube's structure.
You also have the option to use other interfaces based on
OLE DB for OLAP, such as ADO MD, ADO MD.Net or XML/A
(Discover Method).
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Brian Altmann" <brianaltmann (AT) yahoo (DOT) com> wrote

Agree with Brain. You still can use MDX statements to get this information
if you need to create some generic calculations.
I.e.

Measures.MEMBERS - returns all visible measures
Measures.ALLMEMBERS - returns all visible measures and all visible
calculated measures
Dimensions.Count - returns number of dimensions
Dimensions.Item( i ) - returns dimension with index i
<dim>.Levels.Count - returns number of levels in dimension
<dim>.Levels.Item( i ) - returns level with index i in dimension

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Hello,
Open a Cellset with
"Select from [CUBE]"
and loop through the
cset.filteraxis Collection

HTH
Jörg