How to hide member within dimension in ASP.NET MVC 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.

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