I am modeling a system for a Judicial (Criminal, Civil etc) client and
most of my users are Judges and Court Administration who are interested
in Monthly Detailed and Summery Reports of the Cases.
Critical measurements are Case Age(Number of days Case Opened) and Case
Load( Number of cases assigns to a Judge) and so I am planning to have
two separate periodic snapshot fact tables one for "Case Age" having
TimeDIM , JudgeDIM and CaseDIm as Dimensions and the second one is for
"Case Load" having TimeDIM and JudgeDIM as Dimensions. These two facts
tables are good enough for Summery reports but I have few detailed
reports where Case Load of a Judge detailed with Case Details( Data
from Case Dimension) because I do not have Case Dim mapped to Case Load
fact table I can not make this report.

In the CaseDIM I have all the data pertaining to case including the
Judge assigned to it but my current design some how is not comfortable
in generating the Detailed reports. Any suggestion for design
Alternatives are appreciated