Hi,

From a client application, I would like to obtain the definition of a
given calculated member. The cube is a Virtual cube and the calculated
measures could be defined as sums of other non-calculated measures. Is
this possible using Pivot Table Services API? If so, can someone point
me to the exact functions to be used?

Thanks

Hello Yash,
you can use schemarowsets.

dim conn as new adodb.connenction
dim rec as new adodb.recordset

conn.open "Provider......"
Set rec = conn.OpenSchema(adSchemaMeasures)

HTH
Joerg



"Yash" wrote:

If I understand the question correctly, you want to get the calculated
measure defined by the user on the client OWC/Pivot Table?

In OWC Pivot table, you can use PivotTable.XMLData which returns you the XML
version of the current state of pivot table. In this you will find the
calculated measures (and everything else used to query/display) as PivotField
elements. If you know the name of the PivotField (calculated measure), you
can then extract the expression from the sub elements.

Murthy.

"Joerg" wrote:

Hi,
I am not referring to the OWC Pivot table. I meant the Pivot table
service that acts as the interface between a client application and an
OLAP server. This interface is used by client like Crystal Analysis to
connect to remote or local OLAP servers.
In our application, we would like to use it for firing MDX queries on
an OLAP cube, and also, in certain cases, we will have to obtain the
definition of certain calculated measures. This is like obtaining the
definition from a data dictionary.

Yash


MurthyJ wrote: