Set env::username for testing PRPT in Pentaho Report Designer (PRD)

by Andrew Cave | Jul 23, 2019 | How To, Pentaho, Resources, Training

A common technique to restrict access in Pentaho Report Designer is use the variable ‘${env::username}’ in queries. This is replaced with the currently logged in username on the server and allows group memberships/rows access to be identified at the...

Pentaho Enterprise Edition: Extract the BA schedule into a database

by Andrew Cave | Sep 3, 2018 | How To, Main Blog, News, Pentaho, Resources, Training, Uncategorized

Pentaho Enterprise and Community Editions offer the Scheduling tool to enable jobs to be set to run at certain times on a repeatable basis. At the moment, while the schedule is viewable, there is no built-in method for extracting the schedules for reporting or...

Your competitors are doing this. Why aren’t you?

by Zachary Zeus | Aug 24, 2017 | BizCubed, Main Blog, Resources

Unlock your business – your team has the answers We have recently been reviewing the impact that data quality has on workforce productivity.  In the analyses that we have seen, there is an impact of 10—32% of workforce time being wasted due to poor data productivity....

5 Keys to Creating a Killer Data Lake

by Zachary Zeus | Jul 20, 2017 | How To, Main Blog, Pentaho, Resources

It’s been several years since the term “Data Lake” was coined by my friend and Pentaho co-founder James Dixon.  The idea continues to be a hot topic and a challenge to execute properly. The problem is that too many people think all they need to do is dump data into...

Filling the Data Lake with Hadoop and Pentaho

by Zachary Zeus | Jul 20, 2017 | BizCubed, How To, Main Blog, Pentaho, Resources

What is the “Filling the Data Lake” blueprint? The blueprint for filling the data lake refers to a modern data onboarding process for ingesting big data into Hadoop data lakes that is flexible, scalable, and repeatable.  It streamlines data ingestion from...

3 Challenges to Unleashing Your Data Preparation Potential

by Zachary Zeus | Jun 14, 2017 | Analytics at Operational Scale, BizCubed, Main Blog, Pentaho, Resources

There is a growing trend wherein business analysts have more control than ever to prepare and analyze a variety of valuable data, often circumventing IT processes and policies.  What are IT leaders to do?  Can they liberate data to be used by analysts, yet provide...