Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What user interfaces or tools (commercial and/or open source) can query a star schema model (Ralph Kimball dimensional model)? So for example, if we have X fact tables, and Y dimension tables, and Z cross reference tables, we'd like to query a random fact table. If you are aware of such tools, can you provide a reference of each.

share|improve this question

put on hold as off-topic by RolandoMySQLDBA, Paul White, dezso, Mikael Eriksson, Phil yesterday

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – RolandoMySQLDBA, Paul White, dezso, Mikael Eriksson, Phil
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

up vote 3 down vote accepted

Mondrian OLAP server http://mondrian.pentaho.com/

Pentaho Schema Workbench (for creating the cube schema) http://mondrian.pentaho.com/documentation/workbench.php

Pentaho Aggregation Designer (for finding useful aggregations and building them) http://infocenter.pentaho.com/help/index.jsp?topic=%2Faggregation_designer_guide%2Fconcept_pad_overview.html

Saiku AJAX pivot tables http://analytical-labs.com/

Pentaho Report Designer for designing reports.

Pentaho Data Integration (Kettle) for ETL into data warehouse http://kettle.pentaho.com/

DataCleaner for quality control

share|improve this answer

We are familiar with the IBM toolset where I work. IBM's Cognos toolset can read star schema, especially since IBM recommends star schema for mart design.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.