Hi !!
I need to retrieve all MEMBER PROPERTIES of a Level. How can I do that
with ADO MD OpenSchema() method or with DSO methods ?

thanks in advance..
===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
cristiano (AT) sigbrasil (DOT) com.br
www.sigbrasil.com.br
+55 552268699

Hello Cristiano,
use DSO only if you want to Create or Process an Server Object.

Try this:
conn.Open "Provider=MSOLAP;Data Source=local;Initial Catalog=Foodmart 2000"
Set rec = conn.OpenSchema(adSchemaProperties)


HTH
Jörg





"Cristiano Moraes da Silva" wrote:

You just want to get the name of the memberproperties in a level?
for example: "Weight" is a property at the SKU level of product dim.

Or you want to get the value of the memberproperites with a list of members?
For example:

SKU; Weight
===
SKU1; 10Kg
SKU2; 20Kg

....