A requirement make you go in depth of subject... The same happened with me to work out this awesome functionality of Pentaho CDE...
Requirement :
Display aggregate value of some column on Dashboard.
Or
The usage of Query Component in Pentaho CDE.
Environment:
Pentaho BI server stable 4.8
Approach:
Step 1: Lay Out section
Design your dashboard as shown in below picture with rows and columns and with the addition of HTML code.
Requirement :
Display aggregate value of some column on Dashboard.
Or
The usage of Query Component in Pentaho CDE.
Environment:
Pentaho BI server stable 4.8
C-Tools: CDE,CDA,CDF latest version : v13.09.10
Database : Sample data (HSQL db) - installed with pentaho directly. Approach:
Step 1: Lay Out section
Design your dashboard as shown in below picture with rows and columns and with the addition of HTML code.
Step 2: Data sources Panel Section
In the properties :
Name: sampledata_count_value
Jndi: SampleData
Query: select count(customernumber) as count_cust from customers
NOTE: don't go for any Output Options and Columns until and unless if you have any requirement in your dashboard
Step 3: Components Panel Section
As shown in figure , from left side of the panel select " Query Component" and then give the properties
Name: value_of_count ( You can give your favorite name)
Result Var: define a variable of your choice(It's just giving a name)
Next, In the advanced properties of "Query Component" .write the below code in "Post Execution"
Code:
function fun() {
document.getElementById('value').innerHTML = myresult;
}
In the above code:
'value' is the name of the Name of the Column in the lay out section where you want to display the count value.
myresult is the name of the "Result Var" property.
OUTPUT:
Save the dashboard and see the preview.
The sample output is shown below.
122 is the value of the query.. A single value of the result set is displayed using the Query Component and Post Execution code of the component.
Thanks,
Sadakar
BI developer
相关推荐
赠送jar包:pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar; 赠送原API文档:pentaho-aggdesigner-algorithm-5.1.5-jhyde-javadoc.jar; 赠送源代码:pentaho-aggdesigner-algorithm-5.1.5-jhyde-sources.jar; ...
解决 Cannot resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde jar放入D根目录执行: 以下命令加入本地maven库 mvn install:install-file -DgroupId=org.pentaho -DartifactId=pentaho-aggdesigner-...
org / pentaho / pentaho-aggdesigner-algorithm / 5.1.5-jhyde / pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar,解决maven引入hive的jar包时依赖报错Could not find artifact org.pentaho:pentaho-aggdesigner-...
解决maven引入hive的jar包时依赖报错Could not find artifact org.pentaho:pentaho-aggdesigner-algorithm:pom:5.1.5-jhyde in xxx的问题,maven路径org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho...
java maven 仓库包 pentaho-aggdesigner-algorithm-5.1.3-jhyde.jar
可以解决,maven引入hive jar包时,hive Could not find artifact org.pentaho:pentaho-aggdesigner-algorithm:jar:5.1.5-jhyde 问题
datax编译报缺pentaho-aggdesigner-algorithm-5.1.5-jhyde解决
maven编译pentaho-big-data-plugin遇到的所有问题解决,pentaho6.0
Pentaho-Data-Integration-完全自学手册.2016.12.11, kettle
Shims是Pentaho提供的一系列连接各个source的适配器,具体配置位置根据Pentaho的组件来决定,现在的PDI Spoon的配置位置在../data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations 下,注意这个...
(Hive输出)ETLDesigner\common\system\karaf\system\pentaho\pentaho-big-data-kettle-plugins-hive\6.1.0.1-196\下的文件。 (Hive输出)pentaho-big-data-kettle-plugins-hive-6.1.0.1-196。
Pentaho Data Integration - Java API Examples.docPentaho Data Integration - Java API Examples.docPentaho Data Integration - Java API Examples.doc
Shims是Pentaho提供的一系列连接各个source的适配器,具体配置位置根据Pentaho的组件来决定,现在的PDI Spoon的配置位置在../data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations 下,注意这个...
kettle 9.1 连接hadoop clusters (CDH 6.2) 驱动