-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|