Pivot Grid - OLAP OLAP Browser

City[Filter]
Quantity
Discount
Country[Filter]
Category Name[Filter]
Products[Filter]
[Expand]Beverages
[Expand]Condiments
[Expand]Confections
[Expand]Dairy Products
[Expand]Grains/Cereals
[Expand]Meat/Poultry
[Expand]Produce
[Expand]Seafood
Grand Total

Possibly the most important ASPxPivotGrid functionality is OLAP support. The ASPxPivotGrid supports both Microsoft Analysis Services 2000, 2005, 2008 and 2008 R2. As a data source, it can use an ordinary server, http server or cube file.

To create an OLAP connection in code, you need to specify a connection string via the OLAPConnectionString property. At design time, you can build the connection string via the Connection String Editor available via the OLAPConnectionString property in the Properties grid.

To connect to OLAP cubes, make sure that Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is installed on your system. You can get the latest version of this provider here: http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17.


See Also:
Version: v2014 vol 2.3
Copyright © 2006-2014 Developer Express Inc
Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.