please ignore last reply. I now know how to query the cube through the analysis server Client interface (mdxquery.mdx)

However.....

..eventually I need to be able to use Crystal Reports to be the front end of my cube so that I can put a report on the intranet for users to query the cube using the Dimensions created in the cubes as Parameters in Crystal.

Therefore I really need to be able to write some code into my Time dimension in the cube (if possible) that says >= the date the user selects.

And another Time dimension in the cube that says <= the date the user selects.

Therefore achieving a Date range.

Is that possible?

Querying the cube directly defeats my aim of having to manully query the cube myself (as it is labour intensive)and guess I could do this directly from the db.

Any suggestions are much appreciated. I dont know if this is possible. THanks.