Changing the row limit in Analyzer
Posted: April 21, 2011 Filed under: Admin, IT Survival, Pentaho Leave a comment »Analyzer has a row / cell limit set to 2000 by default, this can be increased by editing the following file
…\pentaho\server\biserver-ee\pentaho-solutions\system\analyzer\analyzer.properties
# Max number of cells to show for a pivot table when rendered in the browser
renderer.browser.max.pivot.cells=2000
Depending on your server I would be careful how much you would increase this by
Securing Data Sources
Posted: April 21, 2011 Filed under: Admin, IT Survival, Pentaho, Report Creation 3 Comments »By default, authenticated users have view-only permissions to data sources in the Pentaho User Console. Users with administrative permissions can create, delete, and view data sources. If you want to fine tune permissions associated with data sources, you must edit the appropriate settings.xml file. Follow the instructions below to edit the file.
- Go to …\biserver-ee\pentaho-solutions\system\data-accessand open settings.xml.
- Edit the settings.xml file as needed. The default values are shown in the sample below. You can assign permissions by individual user or by user role. If you are using LDAP, you can define the correct ACLs value for view permissions; the default value is “31.”
- Save your changes to the settings.xml file.
- Refresh the Admin Console.
The typical file is as below
<?xml version=”1.0″ encoding=”UTF-8″?>
<settings>
<!– roles with data access permissions –>
<data-access-roles>Admin</data-access-roles>
<!– users with data access permissions –>
<!–
<data-access-users></data-access-users>
–>
<!– roles with datasource view permissions –>
<data-access-view-roles>Authenticated,Admin</data-access-view-roles>
<!– users with datasource view permissions –>
<data-access-view-users>suzy</data-access-view-users>
<!– default view acls for user or role –>
<data-access-default-view-acls>31</data-access-default-view-acls>
<!– settings for Agile Data Access –>
<data-access-staging-jndi>Hibernate</data-access-staging-jndi>
<data-access-datasource-solution-storage>admin</data-access-datasource-solution-storage>
<data-access-csv-sample-rows>500</data-access-csv-sample-rows>
</settings>
