How to change second y-axis text font size in pentaho ccc charts
If you want to define ortho2 axis title, put your text to ortho2AxisTitle parameter and its font definition to ortho2AxisTitleFont parameter: ortho2AxisTitle: Your title ortho2AxisTitleFont: 10px sans-serif If you want to adjust font of ortho2 axis label, define the font using extensionPoints parameter: extensionPoints: [["ortho2AxisLabel_font", "normal 17px "Open Sans"'"]] You...
Pentaho CDE Dashboard Component Style Editing
javascript,pentaho,dashboard,pentaho-cde
You can put your code in Draw Function. => Your using Table component. By using java script code or jquery code you can manipulate the data in table component. Example: 1. You want to sum of the row values. 2. You can hide the columns and rows. Note: If you...
How to increase mdx Query speed in pentaho cde and how to clear Mondrian Schema cache
1) 23 queries on first load may be a bit too much. Can't you simplify that? Also, are the queries all as fast as possible but it's just too many of them? Or are there slower queries that need to be improved? Check also the priority of components. You may...
Pentaho CDE parameterized queries on Impala
sql,hadoop,pentaho,impala,pentaho-cde
Not really. The JDBC driver for Impala does not support parameters in PreparedStatements which is what is used in the Reporting libraries. It's a hard one to solve. Probably the best way to workaround it is to use a Kettle transformation that dynamically builds the queries and issues them to...
Pentaho CDE Chart
charts,pentaho,dashboard,pentaho-cde
You need to set your data to have crosstabMode = false. And I believe you'll need to switch the category and series roles: add "series" to the categoryRole option and "category" to the seriesRole option (both under advanced properties)....
Custom HTML Page in Pentaho User Console 5
pentaho,pentaho-cde,pentaho-ctools
CSS and JavaScript files Upload CSS and JS files Browse files > home > New folder.. > Name: test home > test > Upload... > {choose files to upload from file system; e.g. test.css and test.js} Create dashboard, add resources Create new CDE dashboard [Home > Create New > CDE...
pentaho data integration Exception in table output
pentaho,kettle,pentaho-cde,pentaho-design-studio
There is a possibility of version conflict between your browser and the ide. You can have a look at the below links. I found these on searching. SWT Browser & Eclipse https://www-304.ibm.com/support/docview.wss?uid=swg21271865...
Pentaho CDE btables with different datasources
I need more details, but i think i know what is your problem. You have a CDE dashboard with two or more BTable components and after all tables are rendered when you make some operations in first BTable the datasource conection will be a combination between this datasource and the...
Edit data by Pentaho dashboard
pentaho,dashboard,dml,pentaho-cde
Yes. Take a look at the table editor sparkl plugin
Implementing SCD Type 2 using Pentaho Kettle (Pentaho Data Integeration 5.2)
pentaho,data-warehouse,dimensional-modeling,pentaho-cde
You could use the UPDATE step. This will give you the flexibility of updating any columns with the values/fields you like.