We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to work on Drill-through support in OlapClient Silverlight

Platform: Silverlight |
Control: OlapClient

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.

Steps to Create a Drill-Through support on OlapClient Silverlight

  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.





                 Figure: OlapGrid in OlapClient with enabled hyperlink cells



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


You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile