Sign up ×
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

closed as off-topic by RolandoMySQLDBA, Paul White, dezso, Mikael Eriksson, Phil Jan 27 at 10:00

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

Pentaho Schema Workbench (for creating the cube schema)

Pentaho Aggregation Designer (for finding useful aggregations and building them)

Saiku AJAX pivot tables

Pentaho Report Designer for designing reports.

Pentaho Data Integration (Kettle) for ETL into data warehouse

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.