Join Bill Pearson as he further develops intermediate concepts using MDX in Analysis Services. In this tutorial, Pearson works with hierarchical relationships in leveraging MDX to meet analysis needs.
Other News
BMC updates management tools for DB2
By Stacy Cowley – BMC Software plans to soon release new versions of two applications for managing IBM’s DB2 UDB (Universal Database), making available to DB2 users features already out for those working with Oracle’s database software.
Oracle, Plumtree target Sarbanes-Oxley
By James Niccolai – Oracle will release a new application in the coming weeks designed to help companies comply with the Sarbanes-Oxley Act of 2002, a set of corporate disclosure and financial reporting rules for companies that are traded publicly in the U.S., the company said Wednesday. Meanwhile,
Advanced Type Mappings
Can XmlSerializer deal with choice compositors? How about mixed content models? XmlSerializer won’t serialize objects that implement IDictionary by default, so how do you get arount it? And more.
Cross Broswer Display of XML/XSL
By David Silverlight – This snippet is a very simple example that uses ASP to merge the XML/XSL server side and displays the output as pure HTML instead of XML. This will work will for non-IE5 browsers.
FIX: Incorrect Cardinality Estimates for NOT EXISTS Predicates After You Upgrade to SQL Server 2000 Service Pack 3
After you upgrade to SQL Server 2000 Service Pack 3, the SQL Server query optimizer may incorrectly estimate the cost for queries that involve a predicate that uses a NOT EXISTS () construct. The estimate will be too high, and results in poorly performing queries as compared to SQL Server
XML Power Job Hunting
by John E. Simpson – Q: What can you tell me about XML-based résumés? Is there an XML standard language for curriculum vitae data?<br><br>A: First, for the uninitiated: a curriculum vitae (Latin for "race [or course] of life," often shortened to "CV") is a more detailed version of what’s also — pa
How to troubleshoot connection problems
By Alexander Chigrik – Should you have connection problems, review this troubleshooting checklist to find potential solutions.
Purging Merge Metadata
MSmerge_contents causes problems for anyone that is running merge replication for any length of time. The problem is that MSmerge_contents will grow forever unless you manage it. Merge replication makes very heavy use of MSmerge_contents which can cause problems as the size grows. This is normall
Kickstart XML Tutorial
In this tutorial you will learn what XML is about. You’ll understand the basic XML syntax. An you will know what’s needed to make XML usable. You won’t be an XML expert after following this kickstart tutorial. But you’ll understand the basics of XML. And you’ll be able to understand XML Documents