Knowledgebase: RadarCube ASP.NET MSAS
Silverlight add-on for RadarCube for ASP.NET. Getting started
Posted by - NA - on 29 April 2010 09:12 AM

The principles of operation

Our Silverlight OLAP Control is a "double" control, the first part of which is in the Silverlight application and is responsible for visualization, and the second - the invisible one - is on the ASP.NET page and is responsible for OLAP-calculations.

Thus, the invisible ASP.NET control is a sort of "web-service" able to process a significant amount of data while making OLAP-calculations and transferring to the Silverlight-application only those data that are needed for visualization.

In addition, this scheme of work is perfect for security purposes - no information about connecting to the data sources is sent to the client's computer: no server names, no paths to them, no passwords - that completely excludes any possibility of sniffing.

Creating a simple SL-application

The OLAP-control architecture described above implies placing and tuning the appropriate controls both on the ASP.NET page and in the Silverlight application.

Tuning Controls on the ASP.NET Page

A simple ASP.NET page should contain at least two controls of RadarCube library besides the ScriptManager and the Silverlight-host. These are a TOLAPCube or a TMDCube as data sources, and a SilverlightOLAPGrid or a SilverlightOLAPChart as the ASP.NET part of the Silverlight-control, responsible for the interaction of the OLAP data source and the Silverlight application control.

Setting the data source controls is nothing different from the standard and is described in details for both the Direct-version and the MSAS-version of the RadarCube.

For the SilverlightOLAPGrid and the SilverlightOLAPChart components it is important to set two properties: CubeID and CommunicationGuid. The first one is responsible for the interaction with the data source control and its value should be the ID of the data source component (TOLAPCube or TMDCube). The second one is a unique identifier, whose value should be the same for the ASP.NET control and the appropriate Silverlight-control. The easiest way to create this identifier is by pressing the "..." button to the right of the property value editing box.

Tuning Controls on the Silverlight application

In the Silverlight-application the same OLAPControl class is responsible for the visualization of the OLAP Grid and the OLAP Chart. It has a single property for mandatory setting: the CommunicationGuid, whose value should be the same as the value of the same-name property of the twin ASP.NET-control. Thus, the way of displaying data (Grid or Chart) is selected in accordance with the type of the twin ASP.NET control.

Before adding the OLAPControl to your Silverlight application, you MUST add references to the RadarSoft.RadarCube.Silverlight.dll and the RadarSoft.RadarCube.Silverlight.Controls.dll from the \ClientBin folder of the RadarCube installation directory, and to the System.Windows.Controls assembly from the standard set of Silverlight assemblies.

If there're a few OLAP-controls in the same Silverlight-application, the value of the CommunicationGuid property should be unique for each pair of the ASP.NET-Silverlight controls.

(348 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako Resolve