MDX, Crystal Reports, and OLAP

From: maria (anonymous_at_discussions.microsoft.com)
Date: 06/21/04

  • Next message: Hugo Kornelis: "Re: Using Stored Procedure returned fields in another Stored Proc or Query" 
    Date: Mon, 21 Jun 2004 07:43:30 -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

  • Next message: Hugo Kornelis: "Re: Using Stored Procedure returned fields in another Stored Proc or Query"

    Relevant Pages

    • OLAP, MDX, and Crystal Reports
      ... 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.datawarehouse)
    • 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: Localization Question (Please tell me Im wrong)
      ... ASP.NET ignores the .NET culture settings and instead uses the country ... > We are using the Crystal Reports version that comes with Visual Studio ...
      (microsoft.public.vb.crystal)