How to work on Drill-through support in OlapClient Silverlight

Drill-Through feature which enables the user to drill through any value and see the raw data which results in the given value. This can be achieved in the grid is placed in OlapClient Control by enabling the Hyperlink support for the cell values in the grid and using the Link_Click event to form the query. Then the CellSet returned from that query will be set as an itemsource for the GridDataControl to show the raw data.

1. Create a Silverlight Project along with Web application.
2. Add the OlapClient control in MainPage.xaml .
3. Create a ChildWindow in the Silverlight Project and add the GridDataControl in that window.
4. Create a WCF service as “OlapManager.svc” and inherit the IOlapDataProvider interface.
5. Explicitly implement the IOlapDataProvider. The connection to the cube database is done with the help of this WCF service.
6. Initialize the connection with the OlapManager service. Then create a report and assign the OlapDataManager with current report to OlapClient.
7. Then set the “IsHyperlinkCell” property of ValueCellStyle in OlapGrid to true.
8. Handle the LinkClick event of OlapGrid and add the following code in that event.

C#

                 Figure: OlapGrid in OlapClient with enabled hyperlink cells

Figure: GridDataControl with raw data has been shown in child window.