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.
Unfortunately, activation email could not send to your email. Please try again.

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.

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.

 

C#

 

 

                 Figure: OlapGrid in OlapClient with enabled hyperlink cells

 

 

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

 

Article ID: Published Date: Last Revised Date: Platform: Control:
2761 11/21/2014 11/25/2014 Silverlight OlapClient
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.