[Post] pentaho deployment FAQs

Pentaho deployment FAQ

Pentaho Q & A list

 

The following link shows the PDF format of this document:

Http://dl.iteye.com/topics/download/80c28022-bbf0-3b3a-9bb3-6dcc066b7135

 

 

Author: Http://flyfoxs.iteye.com

Directory

 

 

 

1. Bar Chart and line chart

2. line chart and XY line chart

3. pentaho bubble chart (buddle chart)

4. Hide all

5. How to sparse display the X axis when there is too much data

6. How to display two charts in a report when pentaho report designer is developed)

7. Differences between inline subreport and banded subreport

8. How to Use variables/parameters in pentaho report designer

9. pentaho user console multi-language

10. The pentaho (OLAP) July picture is garbled and the pentaho report (Chart) is garbled.

11. session expiration

12. After metadata (metadata) is published, server logs are garbled and real-time reports cannot display multiple languages

13. Explanation on the July Toolbar

14. Set the publishing password (publish report, metadata)

15. Modify the log level (you can print out detailed errors, such as the mdx SQL statement)

 

 

 

 

1. Bar Chart and line chart

The difference between a column chart and a line chart is obvious, that is, when the data is not continuous, the line chart will "default" hidden data. this results in inaccurate reports. of course, this can also be compensated, that is, this is only the default behavior. for more information about how to compensate, see the differences between the line chart and the XY line chart.

 

 

2. line chart and XY line chart

When the data is not continuous, you can mark the existence of the data by marking the display of discontinuous points. I did not find this option on the XY line chart. the following are related options and corresponding display results.

 

 

 

 

L when the coordinate density is large, the XY line chart can control the display interval, but the line chart cannot. for details about how to use the XY line chart, refer to the official example. prd-ce-3.9.0-GA/Report-designer/samples/charts/XY line chart. prpt. note the highlighted parameters.

 

 

 

 

 

3. pentaho bubble chart (buddle chart)

I personally think the bubble chart in the official example is incorrect (maybe I don't quite understand it). After checking its parameters, I found that there are many parameters such as series-by-field, if productname is selected for this parameter, a productname can only have a bubble on the chart and select the last data that appears.

 

 

 

 

In this way, the following data cannot be displayed in the pentaho bubble chart. for the same product, we made such a set of data (this set of data is just to illustrate the fictitious problem, not necessarily reasonable ). then there will be only one bubble on the pentaho bubble chart. however, using Excel, you can easily get four bubbles.

Cost	Budget	Revenue	Product
1	2	3	Food1
2	3	4	Food1
3	4	6	Food1
4	5	4	Food1

There is a way to fold, that is, to replace the product column with a number that is certainly not repeated, so that pentaho can display the correct bubble chart.

4. Hide all

July provides strong OLAP analysis. A useful function is to display charts. however, if you do not pay attention to it, the summary data will be introduced in the chart, which is the highlighted part. at this time, we actually want to use the information at the same level as the chart. However, when you view the generated chart, you will find that the summary part is imported into the chart, this chart is easy to misunderstand (Red always takes half of it ).

 

 

Solution: Click the highlighted drill replace button to get the following result, and then click the highlighted downward arrow. Then you can see the picture and you will get a very intuitive picture.

 

 

 

 

 

 

 

 

 

5. How to sparse display the X axis when there is too much data

You can refer to the following blog. I have found other solutions, so I have not verified them. my solution is to use xy-line chart to easily specify the coordinate interval. if this parameter is specified, see [line chart and XY line chart].

Http://www.itisbi.com/thread-72-1-1.html

 

 

6. How to display two charts in a report when pentaho report designer is developed)

Unlike Cognos, A Report of Cognos can easily display multiple lists or icons. pentaho can only be implemented in the form of sub report, because a report can only have one active result set. the development process always finds that there is no data in the report, and there is a result set that may not be active.

Pentaho has two types of sub reports: inline subreport and banded subreport, which are described in detail in the next question.

 

7. Differences between inline subreport and banded subreport

To put it simply, the total report size is different. The Inline is fixed and accurate based on the size you specified. The banded determines the report Size Based on the content.

 

If you do not know how much data you have, you need to consider using banded. Otherwise, you can select banded.

 

Reference:

Http://wiki.bizcubed.com.au/xwiki/bin/view/Pentaho+Tutorial/+inline+vs+banded

8. How to Use variables/parameters in pentaho report designer

The following document describes in detail how to use SQL when using various queries in PRD.

 

Http://diethardsteiner.blogspot.com/2009/11/using-parameters-in-pentaho-report.html (the web site is walled and needs to be accessed using a proxy)

 

9. pentaho user console multi-language

Most of pentaho's support for multiple languages can be easily found based on your feelings. for example, when you define metadata for an ad hoc report, you can set multiple languages for each field. however, the pentaho user console is not very easy to find. the following is an official example.

 

To implement this multi-language, you mainly need to check two files and one is index. XML, one is index_jp.properties. for the file content, see the official example. the key is to modify the value corresponding to the name. Other values do not need to be modified. you can convert the name to ASCII. You can use the online tool:

Http://www.00bug.com/native2ascii.html

Http://tool.chinaz.com/Tools/native_ascii.aspx

 

 

 

10. The pentaho (OLAP) July picture is garbled and the pentaho report (Chart) is garbled.

When I was using pentaho, there were not many garbled characters, mainly two. One was when metadata was published, and the other was the image generated by pentaho.

 

In pentahoreport, use jfreechart to generate an image (for example, introduce a chart in PRD or use July to generate a chart in OLAP). If you only generate an image with garbled characters, the report can normally display text, congratulations! I can help you solve this problem. (You can also manually enter a Chinese character into the report. If the report can be displayed normally, the problem will be further determined)

In fact, the root cause of the problem is the lack of fonts. For more information, see the following link. in centos, you can directly use the following command to install the font, and then restart bi-server.

Yum list | grep-I font | grep Japanese Yum install fonts-Japanese
Http://space.baidu.com.cn/yanghlcn/blog/item/8e29afa48dfa23fc9152ee2d.html http://zhanghaoeye.iteye.com/blog/708211

 

11. session expiration

During development, you often come back from meetings. Bi-server will ask you to re-enter your password. This is annoying. You can modify the following configurations to prevent session expiration:

 

Vi./Web apps/pentaho/WEB-INF/Web. xml
<! -- Insert additional servlet mappings --> <session-config> <session-Timeout> 30 </session-Timeout> </session-config>

 

12. After metadata (metadata) is published, server logs are garbled and real-time reports cannot display multiple languages

Although the solution has been found, I still don't understand the cause. I guess it is because the server and client have different unicode encoding methods, leading to garbled characters.

 

The solution is to modify the client STARTUP script according to the highlighted part.

(Pme-ce-4.5.0-stable \ metadata-Editor \ metadata-editor.bat)

Set opt =-xmx256m-CP % classpath %-djava. Library. Path = % libspath %-dfile. Encoding = "UTF-8"

 

 

 

The following are error exceptions.

Caused by: org. xml. Sax. saxparseexception; linenumber: 5585; columnnumber: 61; invalid byte 3 of 3-byte UTF-8 sequence. At org. Apache. xerces. parsers. domparser. parse (unknown source) At org. Apache. xerces. JAXP. documentbuilderimpl. parse (unknown source) At org. pentaho. Metadata. util. xmiparser. parsexmi (xmiparser. Java: 905) ... 70 more Caused by: org. Apache. xerces. impl. Io. malformedbytesequenceexception: Invalid byte 3 of 3-byte UTF-8 sequence. At org. Apache. xerces. impl. Io. utf8reader. invalidbyte (unknown source)

 

 

13. Explanation on the July Toolbar

 

 

 

Most of the buttons in This toolbar are well understood, such as printing, generating images, and exporting excel. I just picked out a few of the buttons that are hard to understand.

 

L OLAP Navigator

 

 

Click the pink button to determine whether the dimension is displayed in the row or column.

Click the yellow button, you can decide to filter according to this information. But this function is bug in some versions, has been fixed at the biserver-ce-4.5.0.

The button of the triangle and the button of sorting are well understood.

If you have multiple measurements, only one is displayed by default. You can click the measures link to set them.

 

L suppress empty rows/columns

 

 

This button indicates whether empty data is displayed. For example, sparse data is often encountered during OLAP analysis, such as the sales volume of a cotton jacket in summer, in this case, you can use this button to hide the data.

 

The result of this button can also be clearly found through the mdx SQL editor. This button corresponds to the keyword "non empty"

 

L drill Member/drill position

 

 

 

The difference between the two buttons is that when you expand a dimension and expand the second dimension, you can use the following picture to compare the two buttons.

 

 

Comparing the two images, we found that when you select drill member and expand the second dimension (department), all departments will expand. however, if you choose drill position, only the part you choose will be displayed.

 

In addition, this button is mutually exclusive.

 

 

 

L drill replace

 

 

 

This button can solve the problem that the data is always summarized when OLAP generates a chart.

 

 

L drill through

 

 

This is simple. You can drill through and click the highlighted arrow.

 

 

 

 

L show chart/chart config

 

 

 

The two buttons have obvious functions, but there are several points to explain.

If a summary data section is generated when an image is generated, you can refer to [hide all When plotting in July]

If the image is not produced, it may be that the image is too large. You need to adjust the Image Height and bandwidth.

If the generated image is garbled, it is because there is no corresponding font. You can refer to the above description about Garbled text.

 

 

14. Set the publishing password (publish report, metadata)

This password must be set. The default value is null. Report and metadata cannot be published.

VI biserver-Ce/pentaho-Solutions/system/publisher_config.xml

 

15. Modify the log level (you can print out detailed errors, such as the mdx SQL statement)

./Server/biserver-Ce/tomcat/webapps/pentaho/WEB-INF/classes/log4j. xml