Using "ON PAGES" in Query

[Nelson]

Hey,

it is possible to use the "ON PAGES" statement in a MDX-Query?

I've tried this and i get an error:


@result = olap.execute <<-MDX
SELECT
{[CallChannel].[HTTP],[CallChannel].[WEB]} ON COLUMNS,
{[ServiceProvider].children} ON ROWS,
([TroubleType].children) ON PAGES
FROM [Sales]
MDX

[Raimonds Simanovskis]

Instead of

([TroubleType].children)

you need to write

{[TroubleType].children} or just [TroubleType].children

In MDX {...} is syntax for set and (...) is syntax for tupple (read e.g. http://msdn.microsoft.com/en-us/library/aa216769 for bried introduction to members, tupples and sets in MDX).

As [TroubleType].children already returns set then you don't need to enclose it in {...}

See more examples about how to iterate over results of pages in

https://github.com/rsim/mondrian-olap/issues/3

Raimonds