Hi, How to pass date range filter to Saiku dashboard from saiku UI, without swithing to mdx mode ( as I have to keep UI for further dashboards modification. How can I update my measure values based on date range passed?
Dear all, I'm evaluating Pentaho for an IoT project. I'm primarily an R user. I've read that one can execute R code into Pentaho. That's fine, R script executor - Pentaho Data Integration - Pentaho Wiki. I'm wondering now if it is possible to integrate or embed the powerful interactive reports of R Shiny (a package of R) in the framework of…(Show moreShow less)
Hello! I have the problem and I don't know how to solve this.. I have a db, this is part of it: And I've created a Mondrian schema for this (snowflake). This is a part of my schema: <Cube name="fact_document_control" visible="true" cache="true" enabled="true">…(Show moreShow less)
Hello Misha, First of all, it isn't a good schema .... If you create a Fact_Table (fact_document_control), you need to have two differents dimensions: dim_document and dim_date. I understand that you want to filter your measure based on table "fact_document_control" by dim_date, maybe you could considerate that, for granularity, you can put…
Hello, I´m accessing a Pentaho User Console configured on a Linux machine. It uses an Oracle 11g Data Source in another machine called "DB1" and a connection called "user1". I needed to import a big dump file from our customer, so I shouldn´t have it mixed with the contents of the original connection "user1". So I created a new…(Show moreShow less)
Hi, We are testing Pentaho8 and we found this situation: - A query created on Saiku fails with this error after 1-2 minutes: "Error executing query. Please check the server logs or contact your administrator!" - If we check Mondrian logs the query is still running on background. On Pentaho5, same query it is finishing OK after 20…(Show moreShow less)
Hi Michael, Thank you for your return but I don't understand how I apply what you have proposed either it isn't the relevant solution for my problem. So, I send you as an attachment an image on my need. Basically, I want to format Y-Axis ticks label (time duration in second) to HH: MM: SS). Thanks again for your suggestion.
Hi, Exporting queries to Excel file I am getting the following error: "The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook" Do you know how to fix it? I tried to change poi*jar files using different versions but that did not help. Regards, Manuel
Our new Pentaho reports preview in the PRD console but they are blank in the system console. We have copied the same configurations as the standard shipped reports which work well even after customisation but the new ones just wont show in Mifos, our java based open source system running in apache tomcat. By the way the the same version used for…(Show moreShow less)
Using PRD 5.4 and connecting to Oracle DB. When clicking on the pencil icon to open up SQL Query Designer, nothing happens. There is no message or anything. Is there something I'm missing? Thank you in advance for any information you can provide.
Hi everybody, I am trying to create a parameter that contains a two-dimensional array. For this purpose I used the ARRAYCONCATENATE() formula where each element of the array is a MULTIVALUEQUERY() formula that returns an array. The problem is that the main ARRAYCONCATENATE() formula joins all the values from the sub-arrays into a single array…(Show moreShow less)