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...

ARTICLE TOOLS

Want to use this article? Click here for options!

...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

advertisement

advertisement

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

eBooks

Playbook for a Virtualized Datacenter | During challenging times, optimizing the IT infrastructure becomes imperative. Many organizations are looking to extend their virtualization efforts to encompass the entire datacenter. Get a step-through of your technology options and more.

White Papers

As the advances in USB devices have made them invaluable to most business users’, they have also exposed organizations to enormous risks. Learn how to easily enforce device/port control and data encryption policies without requiring new infrastructure and additional admin overhead.

WEB SEMINARS

Is Flexible Lockdown Possible? Join Darren Mar-Elia for this free web webinar exploring the various methods you should consider to protect and control your desktops while also understanding the impact on the end user community.
View Seminar On-Demand.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

Subscribe to Windows IT Pro!

DevConnections ITTV Left-Brain SharePointPro Connections SQL Server Magazine SuperSite for Windows Windows IT Pro

© Penton Media, Inc.

Home About Us Advertise Customer Service Privacy Statement Subscribe/Renew Terms Of Use

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