Local cubes or also known as offline cubes in the SQL Server Analysis Services are files that contain multidimensional data. They work in the same way as normal cubes in MS Analysis Server, but those cubes can be used when the client does not have network connectivity. Local cubes significantly increase the performance of the client application because requests for data are not sent over network, but are handled locally…

Dear reader,

If you are interested in developing an application with XamPivotGrid and you haven't heard about the Infragistics Startup Solutions you might be wondering what assemblies and namespaces you need to add to your project. In the general case you would need 6 of them. The main control assembly two data source assemblies and a few dependencies. The following paragraphs explain it all.

In the Silverlight version…

A common usage scenario for the XamPivotGrid is drilling down in the data. That action normally is done through the UI, but if you want to do it from code and you use XMLA data source things get a bit more complicated.

Normally in a FlatDataSource scenario it would be enough to go through the recursive FlterMembers hierarchy of the IFilterViewModel and set the IsExpanded property of each filter member you want to true…

The XamPivotGrid control is an interactive tool. The data it visualizes changes according to the preferences of the user and they usually change during runtime. Finding information through data mining requires actions such as slicing, drilling down, dicing, etc. The XamPivotGrid allows the user to perform those actions, but the data remains intact – only the view changes. So at some point you might want to go back…