0
votes
0answers
27 views

Shared measures in fact tables

I'm working on a star-schema and trying to find a best practise for the database design. I have three (at this moment) dimension tables for several facts. Most of the facts look-a-like (meaning ...
4
votes
2answers
346 views

Open source and commercial tools to build dynamic queries of fact tables in star schema

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 ...
1
vote
2answers
486 views

Data warehouse support tickets

I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows Now one of the ...