This article Querying an OLAP datasource with C# shows how we can handle MDX queries with ADO.NET. This is achieved using ADOMD (Multi-dimensional) 2.7 with a runtime callable wrapper.
Its worth a read..
http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=640
I wonder if Microsoft has any plans to introduce managed provider for OLAP. That would be great!
To know more about MDX Query of SQL Server Analysis Services visit
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agmdxbasics_0v7d.asp
With Best Regards,
Mitesh Mehta
Email : miteshvmehta@gmail.com
http://cc.1asphost.com/miteshvmehta/
No comments:
Post a Comment