I'm looking at Pentaho BI Platform to extract information from Mantis, but I don't find any tutorial to setup a full working environment (without preloaded data). Do you know any tutorial? Maybe another way to develop reports from Mantis data? Thanks! ...
Hello people! My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've installed a version, and I got it up and running quite painlessly. So that's good....
We are migrating our test report data (unit, regression, integration, etc..) from an XML format to a database format for better analysis. Right now the majority of our test analysis is done using the CruiseControl.NET dashboard, but this is limited to primarily the most recent test data. Older test data can be accessed but not easily com...
I have some numbers in a fact table, and have generated a measure which use the SUM aggregator to summarize the numbers. But the problem is that I only want to sum the numbers that are higher than, say 10. I tried using a generic expression in the measure definition, and that works of course, but the problem is that I need to be able to ...
For a big commercial online shop my company needs to start a business intelligence project. We have done the online shop; there are probably only a couple of data sources, so the integration i think it's quite easy. We're creating the data warehouse database, revisiting the actual database from another point of view. I start to look...
I see that Pentaho wants to charge me for their software. How can I get to the underlying Open Source software for dashboards to see what it can do without having to deal with Pentaho marketing folks? ...
I've defined a Dimension in a schema file containing multiple Levels. One of my Levels contains multiple properties, like: <Level name="MyLevel" column="MyLevelColumn" nameColumn="MyLevelName"> <Property name="Property1" column="PropertyColumn1"/> <Property name="Property2" column="PropertyColumn2"/> <Property name="Property...
We are in a situation to decide one among MS SSAS and Pentaho. Is there any comparision list for both of them with pros and cons? Any help is very much appreciated. ...
Hi all, At the moment I have a Ruby on Rails application which maintains my Users, I have a seperate application (Pentaho) which uses Acegi/Spring Security to authenticate Users. I have been able to change the way Acegi/Spring Security authenticates Users and now it points to my Ruby on Rails application's database and I can get Users ...
Where can I find Pentaho Kettle architecture? I'm looking for a short wiki, design document, blog post, anything to give a good overview on how things work. This question is not meant for specific "how to" starting guides but rather a good view at the technology and architecture. Specific questions I have are: How does data flow betwe...
Where can I find a src-jar for Kettle? I'm looking for a jar that contains the Java files, and I can point my IDE to (like for example junit-4.6-src.jar). ...
I have a master database, that has a table (companyTable) stores the name of the child database for each company. I need to use Pentaho to Obtain a list of company database name from companyTable. Establish the connection to the company database by iterating over the value obtained in 1. Obtain some information from those company data...
Does Pentaho's ETL system, Kettle (http://kettle.pentaho.org/) have a plugin to accept information from JMS messages? I'd like to set up a job that can read messages each containing a hash, extract certain data, and stuff it into a table. Has anyone had any experience with this? Is this a good idea? Any pitfalls? Thanks. ...
I was looking for ETL tool and on google found lot about Pentaho Kettle. I also need a Data Analyzer to run on Star Schema so that business user can play around and generate any kind of report or matrix. Again PentaHo Analyzer is looking good. Other part of the application will be developed in java and the application should be datab...
I am building a Mondrian Cube that shows information for a large range of dates. One of the measures for this cube is an average of a percentage value. Because some of the items in the cube should not make up the final average, I need to know how to filter them out based off this measure and only for this calculated member. ...
Hi all, I have the following XUL markup: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet href="chrome://global/skin/" type="text/css"?> <window width="400" height="275" title="Placeholder" xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" xmlns:pen="http://www.pentaho.org/2008/xul" onload="mainToolbarHand...
Is it possible for a step or transformation in Pentaho Data Integration to call itself, passing the results of the previous call as parameters/variables? My first thought was to create a loop in a transformation, but they don't seem to be allowed... ...
Hi folks, im pretty newbie at mdx sintaxys. I have the next requirement that i need to be able to solve it using mdx, if its possible. I need to show the number of SALE transactions which amout value is greater than "X" , the number of SALE transactions which amount value is less than "Y" , the number of CREDIT transactions which amout...
There are two parameters while using RBF kernels with Support Vector Machines: C and γ. It is not known beforehand which C and γ are the best for one problem; consequently some kind of model selection (parameter search) must be done. The goal is to identify good (C;γ) so that the classier can accurately predict unknown data (i.e., testin...
Hi, i'm having problem restricting a query in mdx, using except function at where clause. i need to retrieved a set of data but which not in an specific set. Then i created the next query: select {[Measures].[Amount], [Measures].[Transaction Cost], [Measures].[Transaction Number]} ON COLUMNS,{[ManualProcessing].[All ManualProcessings].[...