OLAP App Dev With ADO MD.NET: An API Smorgasbord -- Visual Studio Magazine

OLAP App Dev With ADO MD.NET: An API Smorgasbord

Discover an array of OLAP APIs for developing top-notch dedicated OLAP applications.

By Andrew J. Brust
05/01/2006

Listen to the audio and watch the slides!

Microsoft offers an array of OLAP APIs for developing top-notch dedicated OLAP applications, adding OLAP functionality to your existing apps, and more. Examine ADO MD.NET for OLAP data access, Analysis Management Objects (AMO) for OLAP database management, and XML for Analysis (XMLA) for a SOAP-based combination of ADO MD.NET and AMO. Discover AdomdServer, which creates true .NET CLR stored procedures and functions for your OLAP cubes. And learn how to write applications and queries that take full advantage of SQL Server 2005 and deliver on the promise of business intelligence.

About the Author

Andrew Brust is Research Director for Big Data and Analytics at Gigaom Research. Andrew is co-author of "Programming Microsoft SQL Server 2012" (Microsoft Press); an advisor to NYTECH, the New York Technology Council; co-moderator of Big On Data - New York's Data Intelligence Meetup; serves as Microsoft Regional Director and MVP; and is conference co-chair of Visual Studio Live!

Printable Format

comments powered by Disqus

Featured

Visual Studio Devs Demand Claude 3.5 Sonnet AI: 'Why Is VSC Always Preferred?'

The brand-new Visual Studio 2022 v17.12 lets devs specify the AI model they want to use with the baked-in GitHub Copilot, but some are clamoring for more options, such as the latest/greatest Claude 3.5 Sonnet model from Anthropic that is available in VS Code.
SQL Database in Microsoft Fabric in Preview for Faster AI Apps

Microsoft's early embrace of advanced AI in its dev tooling continues apace with the new public preview of SQL database in Microsoft Fabric, the company's analytics/data platform.
Microsoft Seeks to Sort & Simplify its Agentic AI Dev Story

The company will infuse multi-agent runtime tech developed in its AutoGen research project into its production-ready Semantic Kernel SDK, both open source.
Uno Platform Unveils 'Hot Design' Tool for Cross-Platform .NET Apps

Uno Platform provided a new take on visual designers for .NET app development, claiming a breakthrough that changes code at runtime rather than the design stage.
Simple k-NN Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of k-nearest neighbors regression to predict a single numeric value. Compared to other machine learning regression techniques, k-NN regression is often slightly less accurate, but is very simple to implement and customize, and the results are highly interpretable.