Post reply

MDX with 3 axis for OWC

  • February 22, 2005 at 7:46 pm

    #109869

    Dear Gurus,

    I would like to display my OLAP cube using Office Web Component (OWC). I have some difficulties writing MDX statement with 3 axis ( for columns, rows, and pages in OWC).

     

    Does anybody knows how to write these query? Or is there any other way wihtout using MDX?

     

    Regards,

    Hendra

     

     

  • February 24, 2005 at 12:44 pm

    #544003

    The sintax of the MDX is like this:

    SELECT {[Dimension]} ON PAGES,
{[Dimension]} ON COLUMNS,
{[Dimension]} ON ROWS 
FROM [Cube]

     

    Also, I think you can use the pivottable object to desing the report.

     

  • February 24, 2005 at 4:59 pm

    #544049

    I cannot execute those query on MDX sample appilcation. Is there any other tools that I can use to?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply