Category / Section
How to hide member within dimension in ASP.NET WebForms OlapClient?
1 min read
Hiding the members is achieved by setting role in OLAP Cube. You can pass the connection string with additional parameter “Roles” to render a specific permission and it allows you to view only the allowed members and hides the rest.
C#
if (!this.IsPostBack) { var DataManager = new OlapDataManager(@"Data Source=http://bi.syncfusion.com/olap/msmdpump.dll;Roles=Role1; Initial Catalog=Adventure Works DW 2008 SE;"); DataManager.SetCurrentReport(CreateOlapReport()); this.OlapClient1.OlapDataManager = DataManager; this.OlapClient1.EnablePaging = true; this.OlapClient1.DataBind(); }
VB
If (Not Me.IsPostBack) Then Dim DataManager = New OlapDataManager("Data Source=http://bi.syncfusion.com/olap/msmdpump.dll;Roles=Role1; Initial Catalog=Adventure Works DW 2008 SE;") DataManager.SetCurrentReport(CreateOlapReport()) Me.OlapClient1.OlapDataManager = DataManager Me.OlapClient1.EnablePaging = True Me.OlapClient1.DataBind() End If