OLAP, MDX, and Crystal Reports

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Maria (anonymous_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 02:48:39 -0700

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

Relevant Pages

  • MDX, Crystal Reports, and OLAP
    ... and the database logs the number of hits ... I've written an MDX query that looks at this cube and, ... produce static reports for users. ... Crystal Reports. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Whats the deal with Crystal Reports?
    ... Admittedly, I am not using the latest version of Crystal Reports, but I ... say I have five disparate elements with a shared property ... at Telerik and Active Reports first, and Crystal Reports only if there is ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: No Touch Deployment Not Working On Some PCs
    ... I've tried placing all the crystal reports dlls in the same application ... When I installed the app to run locally on the machine that would ... >> BusinessObjects assemblies disappear from the Global Assembly Cache. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Err Msg: "Load Report Failed" when running a .NET Windows application
    ... Reports on Terminal Services. ... Our server doesn't have a C drive and we are unable to generate reports ... Please note that the article refers to Crystal Reports 10, ... Just search the registry for ConnectionDirectoryPath where a value is ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: OLAP, MDX, and Crystal Reports
    ... Crystal Reports. ... we are using the Proclarity Add-in for OLAP inside of RS which ... generate well formed MDX either tool would be fairly difficult to use IMHO. ...
    (microsoft.public.sqlserver.datawarehouse)