What does the mapping of a MDX query to a pivot table
(part of cube browse in Management Studio) looks like?

I can see how the columns, rows and where clause work but what about the
data (measures)?

More than that, how does a query look like for the following pivot table
(from AW cube):
- columns: [Date].[Calendar Year].Children
- rows: [Sales Territory].[Country].[Country]
- slicer: {[Product].[Product].&[348]}
- data fields: [Measures].[Reseller Sales Amount]

Thanks in advance.

Gigel

I am assuming that you are using SSAS 2000. With SSAS 2005 you can use
profiler to see what query is submitted by PTS to SSAS.

In SSAS 2000: Try to change connection string in your pivot table by adding
this:
Log File="c:\OLAPLog.log";

This connection string change will force PTS write MDX into c:\OLAPLog.log
file.
As you will see, query is quite complicated and consist of multiple sets and
calculcated members.

Regards,



"gigel" <newbie (AT) newbie (DOT) com> wrote

Thanks Vimas.

I am running SSAS 2005 so I was able to use the profiler.

Seems like PTS is able to handle a thrid dimension on pages while MDX Query
can't.

Gigel

"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

The pages axis (also available are chapters, and sections) is supported by
MDX. I think I read somewhere that 0 to 64 axis expressions can be
specified.

Jamie
--
"gigel" <newbie (AT) newbie (DOT) com> wrote