MDX, Crystal Reports, and OLAP
I'm new to all the technologies above and so really need some help as I am solely in charge of building a Warehouse solution that uses all of the above!!
I have created a cube in OLAP that based on Usage statistics of our website; so each UserName is assigned to a CompanyID, and the database logs the number of hits against each person (as they use the site this information is recorded into a SQL database). These hits are date\time stamped and when summed up they show when and how often the User accessed the site.
I've written an MDX query that looks at this cube and, based on the CompanyID and date-range I give it, returns the amount of hits against each user for the given CompanyID, and within the given time-frame.
Now all i need to do is, using Crystal Reports 8.5 and Crystal Enterprises, produce static reports for users. Basically, our sales team will email us saying: "I need usage statistics for Shell for the entire year so far". we should then prepare the MDX query\Crystal Scheduler so that, overnight, the report gets generated. The next day all the user has to do is browse to Crystal Enterprises and pick up the report.
Please help: how do i do this? I have no idea how to build a front end onto an MDX query and somehow integrate Crystal Reports. Also, do you think the new Microsoft Reporting Services would be better for this?
Any help would be greatly appriciated! :-)
Thanks in anticipation