pentaho cde 包含三个部分
1、Layout Structure(页面的布局)
2、components (图表等数据载体)
3、Datasources (数据源)
步骤
1、登入pentaho , 点击Create New
![这里写图片描述](https://img-blog.csdn.net/20170314112803565?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
2、选择CDE Dashboard
![这里写图片描述](https://img-blog.csdn.net/20170314112839863?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
3、点击应用模板图标
![这里写图片描述](https://img-blog.csdn.net/20170314112859252?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
4、选择相应模板后,点击OK
![这里写图片描述](https://img-blog.csdn.net/20170314112926817?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
5、点击Components Panel图标,进入 Components。
![这里写图片描述](https://img-blog.csdn.net/20170314112951396?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
6、在左侧选择相应的图表,然后双击
![这里写图片描述](https://img-blog.csdn.net/20170314113009065?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
7、点击DataSources Panel图表,进入DataSources
![这里写图片描述](https://img-blog.csdn.net/20170314113030912?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
8、在左侧找到SQL Queries 选择 sql over sqljndi ,然后双击
![这里写图片描述](https://img-blog.csdn.net/20170314113047831?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
9、设置sql over sqljndi属性
![这里写图片描述](https://img-blog.csdn.net/20170314113228175?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
10,点击Components Panel图标,进入 Components,设置相关属性。
![这里写图片描述](https://img-blog.csdn.net/20170314113246644?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
11、点击save 保存该cde
![这里写图片描述](https://img-blog.csdn.net/20170314113308119?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
12、点击预览图表,预览cde
![这里写图片描述](https://img-blog.csdn.net/20170314113325145?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbmltYV9hcHBsZQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
图形的Advanced Properties参数设置
参数名称 | 值 | 功能 |
---|
plot2 | TRUE | 开启双图 eg:柱形图+折线 |
plot2OrthoAxis | 2 | 开启双轴 |
barSizeMax | 数值 | 设置柱状图的宽度 |
orientation | Horizontal | 设置为条形图 |
selectable | TRUE | 选中某个数据后,会高亮显示 |
stacked | TRUE | 将柱状图变成堆积图 |
hoverable(pie chart) | TRUE | 可以将选取的扇形分离出来(用于饼图) |
titleFont | 数值 | 修改图表标题大小 |