Is there any feature to add calculated metrics prior to publishing, for the models being published in the server?

Pentaho > faq

Do you need Data Analytics support?

Frequently Asked Questions

Is there any feature to add calculated metrics prior to publishing, for the models being published in the server?

The model being published is the source, other functionality like calculated metrics, aggregate tables, security, etc., will require further development.

Which data sources does Pentaho Reporting supports?

Standard data source like SQL, MDX, Pentaho Metadata, etc, apart from this it also supports Kettle Transformations on the fly, so there are no limits to where your data comes from or how source data are combined.

How can i customize my Report’s design in Pentaho Reporting?

Pentaho Reporting style is flexible which allows the report designer to choose the granularity at which they want to manipulate the look and feel, right down to font styling on individual characters. You can also add your own images and logos to the reports.

Is it possible to add dynamic fields in the Pentaho Analyzer?

It cannot be added directly in the Pentaho application. Download the schema file, update it using schema workbench and then publish the schema file.

Can we edit data in Analyzer reports and save into database?

Pentaho Analyzer is currently a visualization and presentation experience. It does not have the ability to modify the underlying data source.

While trying to view a report in Analyzer, is there any way to view all the records in Analyzer itself without exporting it to PDF or Excel?

Yes, there are a properties file in the Pentaho server to increase the cell size of the Analyzer report.

Can I read data from Excel, CSV or other custom delimited files?

Yes, Pentaho data integration provides a connector to almost any format of data, or atleast capability to build one. Out of the box Pentaho support Excel, CSV, XML, JDBC, ODBC, Big Data Storages like Hadoop, NoSQL storage like Cassandra, Mongo, Marklogic, SAP and more.

Can we use Community Edition is there a difference between Community Edition (CE) and Enterprise Edition (EE)?

EE has more flexible features in terms of self-service such as dashboard designer, interactive reporting. When it comes to support for connectors to various Big Data and NoSQL sources it comes out of the box. Administrative and monitoring features, especially for data integration, are available. Upgrades, support is also available if we use EE.

Can I try out Pentaho Enterprise Edition? If so please provide URL

If you are new to Pentaho you can schedule a demo from Pentaho expert directly from Pentaho (http://www.pentaho.com/request-demo) or from TenthPlanet to understand the various features of the product suite. If you are familiar and want to install and verify it at your location you can download enterprise edition which is available for 30 day trial with all the features for a complete evaluation

What are all the types of filters available in the Pentaho Analyzer?

a. Include/Exclude rows based on Dimension/Measure
b. Value “contains” <user expression> in a Dimension/Measure
c. Arithmetic Operators (>, <, >=, <=)