Urgent: MDX with Pivot table

#1

I want to assign a MDX statement to a Pivottable at Runtime. Can
anyone help in doing it.

#2

I have done something like this in the past (I am assuming that you are
referring to the OWC pivot table):

MyPT.CommandText = _
"select {[Measures].Assets, [Measures].Expenses} " & _
"on columns " & "from [" & Cube.value & "]"

Where MyPT is the object id.

Hope it helps
Murthy
"Jeethendar" wrote:

Quote:

I want to assign a MDX statement to a Pivottable at Runtime. Can
anyone help in doing it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Urgent: MDX with Pivot table

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Urgent: MDX with Pivot table - 10-05-2004 , 01:41 AM

RE: Urgent: MDX with Pivot table - 10-06-2004 , 11:47 AM