"Maria" <anonymous@discussions.microsoft.com> wrote in message
news:1f52601c4583e$188c6fd0$a601280a@phx.gbl...
> Hello all
>
> 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
>
> Maria
>

"Maria" <anonymous@discussions.microsoft.com> wrote in message
news:1f52601c4583e$188c6fd0$a601280a@phx.gbl...
> Hello all
>
> 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
>
> Maria
>

"Dennis Redfield" <dennis.redfield@acadia-ins.com> wrote in message news:<#Wg#lLIWEHA.1888@TK2MSFTNGP11.phx.gbl>...
> you would do well to move this query over to the reporting services
> newsgroup.
>
>
> "Maria" <anonymous@discussions.microsoft.com> wrote in message
> news:1f52601c4583e$188c6fd0$a601280a@phx.gbl...
> > Hello all
> >
> > 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
> >
> > Maria