Hi,

I am working on an SSAS analysis application, written in Silverlight and making use of the Infragistics data visualisation controls. I would like to have complete control over the users interaction with the available SSAS cubes and this includes navigation of hierarchies within a given dimension. What I would like to do is present the user with the members within a given hierarchy as a flat list i.e.

Parent

Child

Grandchild

The user can then navigate directly to any level within the hierarchy without the need to start at the top and work down. I have successfuly created custom data source, data provider, command etc. objects based on the Infragistic base classes, which allows me more control over the querying. In order to fulfill the above requirement I have been extracting hierarchies from the available dimensions where the number of levels is greater than 2, and then displaying the hierarchy members by using the levels.

When selecting a level other than the top level I have been asynchronously loading each filter members members recursively until the required depth is reached, which as you can imagine is highly inefficient and often times out due to the number of async calls being made.

Is there a better way to do this and could you possibly supply some sample code? Ideally I would like all operations, including MDX generation shifted to the server to avoid client-side processing and the number of roundtrips required to support the given action ,but I know this would be a fair amount of work.

Kind Regards,

Chris