Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

Mayuri Donda
I am using PRD CE 8.1 I have added drop down parameter (Exam_Id) in report. Static query works fine - select * from Table where ExamId = 1 But dynamic is not working - select * from Table where ExamId = ${Exam_Id} gives me below error org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * from Fact f join… (Show more)
in Reporting & Analytics
Marcos Borio
Hi members! I am working with Pentaho Server 6.1 and I need to integrate a report (made in PRD 5.4). The report works as I expect but I must find a solution to a little problem to put the report in production environment. The report is using a CDA data set and I need to specify a dynamic "server URL" (according with the customers environment). I… (Show more)
in Reporting & Analytics
Roguen Keller
Hi everyone, I'am new to pentaho CDE. I'm creating a CCC chart, I'm facing some issue with bar chart combine with line. The plot 2 is sorted base on month and year. I want the plot 2 is sorted just by month in order to connect each of them together. Like this image below:     readers: ['measure, month, year, value'], baseAxisComposite:… (Show more)
Roguen Keller
Irrespective of locale date format, I need to genereate the report with the date format of the locale which i passed in runtime. Am getting the expected results when I am editing fr in environment-designtime-locale and running it. But I want that to Dynamic. Is anything doable in Penatho Report Desinger end to achieve it. Finally I want the output… (Show more)
Sebastian Schenk
How can I reuse the dimension e.g. employee      with different captions: as broker, employee, advisor but with the      same structure: Name+Employeeno   Example implementation below explained: I want that caption="%{source_employee}" is no longer declared in the global dimension, it should be given in the DimensionUsage for the… (Show more)
in Reporting & Analytics
B493F2HZ
hi,everbody.I am a newer,is there anybody could tell me where to get the offline documnet,such as report designer or BI server and so on?thanks very much
in Reporting & Analytics
Mayuri Donda
Hi all,   I am working on an Item Analysis report for an exam in PRD CE - 8.1   My report should look like below:   S. No /Question No 1 2 3 4 5 6 7 8 9 10 1 15 15 12 12 15 15 15 12 12 12 2 15 12 12 12 15 12 12 12 11.25 9 3 15 12 12 12 15 12 12 11.25 11.25 7.5 4 15 12 12 11.25 15 12 12 11.25 11.25 6 5 15 12 12 11.25 13.5 12 12 11.25 10.5 6 HAG… (Show more)
in Reporting & Analytics
Veronika Florova
Hello, I have to make a cde dashboard with some selectors and two date range components which should reflect on a table component. However I have problems with positioning the date parameters in the source query of the table. WITH SET [~ROWS_Objects_Objects.object] AS {[Objects.object].[object_name].Members} SET… (Show more)
in Reporting & Analytics
Oliver Doepner
Click to view contentMy company uses Pentaho 6.1.   In an Interactive Report, I would like to display for each group the sum of a certain numeric column, but not display the individual rows that are being summed up.   I tried "Sum" from the "Summary" menu on the column, but that just adds the sum to the bottom of the group and the detail rows are all still there,… (Show more)
in Reporting & Analytics
Load more items