How to hide member within dimension in ASP.NET MVC OlapClient?

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.

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();
       }

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

Did you find this information helpful?

Yes

Comments (0)

How to hide member within dimension in ASP.NET MVC OlapClient?

Access denied