Reader small image

You're reading from  Learning Pentaho CTools

Product typeBook
Published inMay 2016
Reading LevelIntermediate
PublisherPackt
ISBN-139781785283420
Edition1st Edition
Languages
Tools
Right arrow
Author (1)
Miguel Gaspar
Miguel Gaspar
author image
Miguel Gaspar

Miguel Gaspar started working at Webdetails about 3 years ago, some time before the acquisition of Webdetails by Pentaho. He was a consultant in the Implementation team and his work involved developing dashboard solutions as part of services. He is now acting as the technical owner of some of the Implementations projects as part of the Webdetails team in Pentaho. He likes to be as professional as possible, but in an informal way. One of his favorite hobbies is learning and his particular areas of interest are: business analytics, predictive analysis and big data, augmented reality, and cloud computing. He likes to play and is a huge martial arts fan and also one of the worst soccer players ever. He is married and a parent of two young and lovely daughters, who would like to spend more time playing like crazies with him. He also likes to spend time with friends or just having a drink and a good talk with someone else, if possible with his family at his side. He really hates liars.
Read more about Miguel Gaspar

Right arrow

Defining data sources for components


We don't want static dashboards, we want to query data to be shown in them. There are two ways to set queries in components. The data sources can be of one of two types, CDA and non-CDA:

  • Going the CDA way, you need to define it using the query it's defining, inside the component, an object such as queryDefinition or chartDefiniton depending on the component, with a set of properties:

    • path: This is the path that points to a CDA file. You can make use of the CDA files created as explained in the chapter dedicated to CDA.

    • dataAccessId: This should set the ID of an available data source, also covered in the CDA chapter, that is set in the file we are pointing at.

  • Going the non-CDA way, by just using a simple SQL or MDX query, we can define, inside the component, an object queryDefinition or chartDefiniton, depending on the component, with a set of properties:

    • queryType: This is the type of the query selecting one of the two values available, mdx or sql.

    • jndi...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Learning Pentaho CTools
Published in: May 2016Publisher: PacktISBN-13: 9781785283420

Author (1)

author image
Miguel Gaspar

Miguel Gaspar started working at Webdetails about 3 years ago, some time before the acquisition of Webdetails by Pentaho. He was a consultant in the Implementation team and his work involved developing dashboard solutions as part of services. He is now acting as the technical owner of some of the Implementations projects as part of the Webdetails team in Pentaho. He likes to be as professional as possible, but in an informal way. One of his favorite hobbies is learning and his particular areas of interest are: business analytics, predictive analysis and big data, augmented reality, and cloud computing. He likes to play and is a huge martial arts fan and also one of the worst soccer players ever. He is married and a parent of two young and lovely daughters, who would like to spend more time playing like crazies with him. He also likes to spend time with friends or just having a drink and a good talk with someone else, if possible with his family at his side. He really hates liars.
Read more about Miguel Gaspar