In the results of an adomd.net query, I'm trying to determine if a cell is based on a formula. i get the following error in the code below:

CODE:
if (cellSet.Axes[0].Positions[i].Members[0].Type == MemberTypeEnum.Formula)

ERROR:

The operation is not valid because of the current state of the object. You can use the FetchAllProperties method to retrieve the data necessary from the server to enable this operation.

However, when i try the FetchAllProperties, i get another error that states the data provider does not support this operation.

ADOMD SDK DOCS:

The online docs for Member.Type property states:

Unless this property has been explicitly requested in the query, accessing this property raises an InvalidOperationException exception if the Member is populated by a CellSet.

QUESTION:

So how do i explicitly request the member type property in the mdx query?

that did it. thanks!

"Brian Altmann" <findme@thesignaturewebsite> wrote