Configuring Mondrian roles

NOTE: new features and further improvements are no longer released for the Mondrian data source.
Instead of Mondrian, our team highly recommends considering Flexmonster Data Server. Just like Mondrian, this tool aggregates data on the server side and can handle large datasets.
You can see the full list of available data sources here: Supported data sources.

Overview

Sometimes it’s necessary to limit access to data. To do this you can define an access-control profile, called a role, as part of the Mondrian schema and set this role when establishing a connection with Flexmonster Pivot.

Requirements

• Flexmonster Pivot version 2.210 or higher
• A relational database with a Mondrian schema
• Java JRE 1.7+

Step 1: Configure roles in the Mondrian schema file

Firstly configure roles in the Mondrian schema file. Refer to the Mondrian documentation for more details.

Step 2: Launch Flexmonster Accelerator

Start (or restart) Flexmonster Accelerator for Mondrian. Refer to the Accelerator "Getting Started" guide for more details.

Step 3: Configure Flexmonster Pivot

Now, let’s specify Mondrian roles in the configuration. Here is a minimal sample created with the JavaScript API (replaceproxyUrl, catalog, cube, and roles parameters with your specific values):

var pivot = new Flexmonster({ 
    container: "pivotContainer", 
    toolbar: true,  
    report: { 
        dataSource: { 
            type: "mondrian", 
            proxyUrl: "localhost:50006", 
            dataSourceInfo: "MondrianFoodMart", 
            catalog: "FoodMart", 
            cube: "Sales", 
            binary: true, 
            // Mondrian roles 
            roles: "California manager" 
        } 
    }
});