Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 21st, 2004, 09:51 AM
Registered User
Join Date: Jun 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MDX, Crystal Reports, and OLAP

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


Reply With Quote
  #2 (permalink)  
Old August 23rd, 2004, 06:43 AM
Authorized User
Join Date: Apr 2004
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts

I don't know if it does it better but it does it. You've got a realy god whitepaper on the subject here:


Reply With Quote
  #3 (permalink)  
Old August 24th, 2004, 05:03 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

Just a wild tought. . .

Have you tried creating a pivot table in Excel and then pointing it to the OLAP data source? This eliminates the need to write MDX as well as the need to re-create a report. The linked pivot table gets re-populated as the datasource gets more data.

You can save the Excel file in the network and then the users can just open it as needed. Crystal reports is a great tool, but Excel may still be better for this. MDX is for non static data, so using Crystal reports to create static reports defeats the purpose of MDX and cubes.

Go to this site www.mosha.com there is a lot of info in there.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Show OLAP Crystal Report with drill down in ASP SaralaManoharan Classic ASP Professional 1 October 2nd, 2007 06:00 AM
Comparitive Reports in Crystal Reports tarunm Crystal Reports 1 January 21st, 2006 01:08 AM
comparision among crystal reports and Data reports avats Crystal Reports 0 April 13th, 2005 01:01 PM
How to create/design reports with crystal reports BassmaniaQ Crystal Reports 0 December 14th, 2004 04:58 AM
Running MDX Query from crystal reports syedjavid Crystal Reports 1 August 23rd, 2004 06:41 AM

All times are GMT -4. The time now is 05:39 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.