Hi,

I'm using VBA to send MDX statements to a cube which is returning the
results I need except for the field names which comes back as shown below. I
need the field names to be Group, LineGroupAlt, and 200501, 200502, etc.
Having tried a number of dimension properties (Members WithDataCaption, etc)
with no success, I'ds appreciate if someone could let me know how this is
done.

[Line].[Group].[Group].[MEMBER_CAPTION] [Line].[LineGroupAlt].[LineGroupAlt].[MEMBER_CAPTION] [Time].[Month].&[200501] [Time].[Month].&[200502] [Time].[Month].&[200503] [Time].[Month].&[200504] [Time].[Month].&[200505] [Time].[Month].&[200506] [Time].[Month].&[200507] [Time].[Month].&[200508] [Time].[Month].&[200509] [Time].[Month].&[200510] [Time].[Month].&[200511] [Time].[Month].&[200512]

Many thanks,
Rob

Use dimensions properties like so:

SELECT <Set_Expression> PROPERTIES MEMBER_CAPTION ON 0 FROM ...

"Robert Chapman" <RobertChapman (AT) discussions (DOT) microsoft.com> wrote

Hmm, been trying this out but how do I actually set the member caption? I
think mine must be blank? Ideally I'd like to have names that are set in the
dimension rather than in the MDX query so that the values automatically flow
through to the field names. Is this possible?

Thanks, Rob

"Elad" wrote:

Sounds like you are opening the results of the MDX query into a an ADO
recordset object. This will "flatten" the result set and return these
"strange" column names.

What you probably want to do is to use a cellset from the ADOMD library.
This is a slightly different way of working with the data, if you want
to see some an example the source for the MDX Sample app that comes with
AS 2000 is written in VB6 and works with cellset objects.

Tom Chester also has a little sample written in Excel VBA, that will run
MDX queries, which you might be interested in. You can find it at
http://www.tomchester.net/articlesdo...mdx_applet.xls

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <ABBF926C-597D-47F7-ADBA-BDBFED23EF62 (AT) microsoft (DOT) com>,
RobertChapman (AT) discussions (DOT) microsoft.com says...