Search
InstantDoc ID
GO

Browse By: Author | Issue

February 18, 2004 07:18 PM

23 Business Intelligence Tips

Build cubes, write MDX queries, optimize DTS, and more
Rating: (0)
Various Authors
SQL Server Magazine
InstantDoc ID #41531
Improve Performance at the Aggregation Level
You can improve OLAP performance when you set a cube's aggregation level. When you build a cube, you set the aggregation level according to the desired speedup in processing queries. (Speedup describes how much faster queries run with precreated aggregations than without aggregations.) The system estimates the speedup based on the I/O amount that the system requires to respond to queries. The total possible number of a...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Good summary. Some of us are not as savvy and am glad to see this collection of tips. Not disappointed at all.

jcsf2000 7/28/2004 12:17:11 AM

Wow, when I saw the title I was excited to find some really useful stuff, what a huge disappointment to find a collection of old tips (some already outdated with reference to SQL 7.0). I read that March is the celebration month, this should have warned me. Basically this is clean out of the fridge, all stuff close to expiry date goes into a stew. Didn't taste good at all, now I need some stomach medicine :( (If you make a voting, this is my favorite for worst article in 5 years of SQL Mag) congratulation to the rest you did achieve, that was 92% excellent stuff :)

Andreas 2/20/2004 2:13:50 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.