This blog will talk about how to create a dashboard using Pentaho CDE (Community Dashboard Editor) framework:-
1. Open Browser and paste this url in below
localhost:7080/pentaho
login inside pentaho according to username and password which one provided in your browser.
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
2. Go to File->New->CDE Dashboard and save your in favourite location.
3. CDE Dashboard are divide in Four major panel like Layout Panel, Component Panel, Datasource Panel and Preview your Dashboard.
Layout Panel- where i can design the resources, rows > column > and html tag.
component Panel-in query component i can access data source where i can provide a
datasource name.
Datasourced Panel-where i can create datasource.
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
4. inside layout panel.
create Resource Name-style, inside resource create row and column and again create row and inside
row create html tag.
Row-
column
Row
Html Name-title, HTML-<H1>Customer Report</H1>
Html Name-Query, HTML-<H1>Write any thing</H1>
5. Go to Datasource Panel-
create Datasource-go to SQL Query ->select any
a)sql over sqljdbc, b)sql over sqljndi
I have selected sql over sqljdbc->
Name- DataConnection
Driver- org.postgresql.Driver
user name- postgres
password- postgres
url- jdbc:postgresql://localhost:5432/foodmart
Access Lavel- public
Query- select count(customet_id) from customer;
6. Go to Component Panel-
go to Others-> Query Component.
Name- customer_component
Result Var- myresult
Datasource- DataConnection
HtmlObject- cust_query
PostExecution- function fun()
{
document.getElementById(‘cust_query’).innerHTML = myresult;
}
7. Save the component and click on Preview Your Dashboard. And See the output.
For any questions regarding CDE, please get in touch with us Helical IT Solutions
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
1. Open Browser and paste this url in below
localhost:7080/pentaho
login in pentaho according to username and password which one provided in your browser.
2. Go to File->New->CDE Dashboard and save your in favourite location.
3. CDE Dashboard are divide in Four major panel like Layout Panel, Component Panel, Datasource Panel and Preview your Dashboard.
Layout Panel- where i can design the resources, rows > column > and html tag.
component Panel-in query component i can access data source where i can provide a
datasource name.
Datasourced Panel-where i can create datasource.
4. inside layout panel.
create Resource Name-style, inside resource create row and column and again create row and inside
row create html tag.
Row-
column
Row
Html Name-title, HTML-<H1>Customer Report</H1>
Html Name-Query, HTML-<H1>Write any thing</H1>
5. Go to Datasource Panel-
create Datasource-go to SQL Query ->select any
1)sql over sqljdbc, 2)sql over sqljndi
I was selecting sql over sqljdbc->
Name-DataConnection
Driver- org.postgresql.Driver
user name- postgres
password- postgres
url- jdbc:postgresql://localhost:5432/foodmart
Access Lavel- public
Query- select count(customet_id) from customer;
6. Go to Component Panel-
go to Others-> Query Component.
Name- customer_component
Result Var- myresult
Datasource- DataConnection
HtmlObject- cust_query
PostExecution- function fun()
{
document.getElementById(‘cust_query’).innerHTML = myresult;
}
7. Save the component and click on Preview Your Dashboard. And See the output.
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:””;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Calibri”,”sans-serif”;}
Best Open Source Business Intelligence Software Helical Insight is Here