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.
Tell me more
×
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.
|
|
|
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 Data Integration (Kettle) for ETL into data warehouse |
||||
|
|
|
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. |
|||
|
|
