Hi All,

Is there any method to identify the Number of Members or Rows or
Columns before executing the MDX.

Regards,
Mansoor

Yes, you can use ADOMD properties to obtain this information:

You can declare an ADOMD cellset, and execute your MDX, and check the counts
of positions and/or members, something like:

cst.Axes(i).Positions(j).Members(k)


Be careful of this, if you have a long running query, it will take a long
time to obtain the information you want because the statement has to execute
completely.



"Muhammad Mansoor" wrote:

SQL McOLAP wrote:
delay that this query will take a long time to execute, but it will be
useless if the user comes to know about it _AFTER_ the query is
executed.

Then you'll have to know up front which queries come back quickly, and which
don't. If you don't use non-empty crossjoins (which you should for
performance) you may be able to calculate how many cells will be returned by
multiplying all dim members on the axis. If your end-users DON'T want to see
empty cells, you may be out of luck. I don't know a way of getting cellset
count without actually executing MDX. If there is a way, I'd be interested
myself.

"Muhammad Mansoor" wrote: