Formula references

Pentaho Metadata Editor

Version: 10.1.x
Audience: anonymous
Part Number: MK-95PDIA007-11

Get started with Pentaho Metadata Editor
Tour of Pentaho Metadata Editor
A conceptual overview of relational data modeling
The Physical Layer
The Business View
The Abstract Business Layer
Incorporate Metadata
Create a domain
Apply metadata properties and concepts
Publish a domain
Importing and exporting domains
Import a domain
Export a domain
Domain backup and recovery
Advanced topics
Troubleshooting
Create a domain
Setting up a database connection
Set up a database connection
Add a new database type
Method of access
Import physical tables and columns
Import tables inside a schema
Create a business model
Build a business view
Creating a business model
Create a business model
Add business tables and columns
Remove business columns
Add relationships between business tables
With the navigation pane
With the editor graph
Hadoop Hive-specific SQL limitations
Build a business view
Create a new category
Build a business view using Manage Categories
Create a new category from a business table
Move columns into categories
Add a new category
Remove categories and columns
Apply metadata properties and concepts
Apply properties
Use the properties editor
Properties list
Property settings
Add a property
Remove a property
Apply concepts
Use the Concept Editor
The default concept
Build concepts
Add parent concepts
Remove parent concepts
Metadata properties reference
Out-of-the-box properties
Custom properties
Custom table joins
Required properties per business object
Publish a domain to the Pentaho Server
Before you begin
Make a model available as a data source
Metadata security
Configure the security service
Retrieve security settings offline
Change security constraints
Add column-level security constraints
Add global row-level security constraints
Add user or role row-level security constraints
Add role model-level security constraints
Remove security
Enable anonymous access
Modify application security
Modify Pentaho configuration
Modify repository properties
Map the appropriate role
Remove security from data source management
Remove security from the metadata domain repository
MQL formula syntax
Global constraints
User and role row-level constraints
Manage international locales
Pentaho metadata formulas
First use: MQL constraints
Second use: Physical table column formulas
Formula syntax
Metadata references
Formula references
Supported functions and operators
Supported functions
Supported aggregate functions
Supported operators
Metadata issues
Managing multiple outer-joins
Slow responses or inconsistent results in reports
Metadata-based reports generated in version 4.8 produce different results in version 5.x

The following functions and operators are supported by the Metadata Editor:

Supported functions
Supported aggregate functions
Supported operators

Back to home page