OSBI

Creating a Bugzilla Dashboard – hands-on CDE Tutorial – Fuse Day #3 Session Summary

In a previous post we have installed the Pentaho server and used CDF code to create a dashboard.

In this post we will develop another dashboard for Bugzilla using CDE - the Dashboard Editor..

udid 30/03/2011 - 16:13
CDE, CDF, Dashboard, OSBI, OSBI, Pentaho
Core Open Source BI components

Tikal's recent experience with open source business intelligence, data analysis and report generation tools such as Pentaho CE and many others had proven that the tools are efficient, simple, flexible, scalable, reliable and as free as Linux or Apache. 

udid 26/08/2010 - 09:19
.Open Source, ALM, etl, OLAP, OSBI, OSBI, report
Sum Distinct Aggreration in a multi-dimensional model

I am working with a multi-dimensional star-schema

http://en.wikipedia.org/wiki/Star_schema

 

 

and I need a special aggregation function to sum without duplicates

see http://forums.pentaho.org/showthread.php?t=71116

 

I can see how this is done with SQL but not sure what is the best approch to implement it with Mondrian.

 

UPDATE: I was able to create the measure with relativly simle MDX. Code is attached.

 

udid 30/07/2009 - 11:51
Business Intelligence, Mondrian, OLAP, OSBI, Pentaho
Software Quality – OS BI for Bugzilla – now on Pentaho 3.0 - part 2
The first part of this post can be found here

The Software Quality Report (SQR) were build for version 1.2 of the Pentaho BI Platform.

In this document is the list of changes and fixes for the Penatho BI Platform 3.x from version 1.2 of the Pentaho BI Platform.

 

  1. Pre-Requirements

udid 14/07/2009 - 08:53
bugzilla, Business Intelligence, OSBI, Pentaho, SQR
Straight-forward XLS data export in CDA

In previous post we have developed a dashboard with CDE, the dashboard needs a parameterized and secured data access layer to provide the data for the graphs, selectors and texts on the screen while encapsulating the data access complexity - the CDA.

 

Once the dashboard is complete and users find valuable information or spot insightful patterns they would definitely want and ask you to provide data export functionality to the dashboard, which is easier done than said.

 

All you need is a Text Component with this expression:

udid 15/08/2011 - 21:11
CDA, CDE, CDF, OSBI, OSBI, Pentaho
Anouncing the release of Saiku 2.0 - Next Generation Open Source Analytics

For some quite time, the Pentaho community (specifically Tom Barber and Paul Stöllberger) is talking about a new web UI for data analysis (OLAP slice-n-dice) and after a few month of hard work they have released version 2.0 of Saiku and it is fully integrated with Pentaho.

 

udid 26/04/2011 - 17:29
Business Intelligence, OLAP, OSBI, Pentaho
10 Key Trends In MDM

Here is an good forward-looking review of MDM hot trends from Information Management.

udid 24/12/2010 - 16:40
MDM, OSBI, OSBI
ETL for developers, w. video

ETL is the tool of choice for big data transportation and transformation.

udid 27/10/2010 - 00:08
etl, ETL & Data Integration, OSBI, OSBI, pdi
מי צריך MDM?

כולם מדברים על הערך העיסקי והחזר ההשקעה מפתרון Master Data Management. מאמר זה מסביר במילים פשוטות מה זה MDM ואיך תדע אם הארגון שלך זקוק לו.

 

udid 30/04/2010 - 12:59
Master Data Management, MDM, OSBI, OSBI, ניהול רשומות אב
diff and patch for database tables using PDI

Pentaho Data Integration (Kettle) has two cool steps that can "diff" and "patch" database tables.

 

They can be usefull when you need to sync two tables across databases and would not want to "drop-and-load" the entire table each time or when you have a large update and you want to take updates and inserts from batch files.

 

The diff step allow you to sync two tables (might be on different databases) by selecting all rows from both tables, comparing them to each other (you can specify the key-fields and the compare operator) and marking each row as identical/changed/new/deleted.

 

The merge step will run updates/inserts/deletes against the second table so at the end it would be identical to the first table.

 

udid 25/03/2010 - 00:43
Databases, ETL & Data Integration, OSBI, pdi
Syndicate content