| 事实 | 预订流程/房晚 |
|---|---|
| 维度 | 房型/渠道/价格计划 |
| 指标 | 入住率/RevPAR/ADR |
房晚事实
房晚事实
CREATE TABLE fact_room_night (
stay_date string, hotel_sk bigint, room_type_sk bigint,
room_nights int, revenue decimal(18,2)
) PARTITIONED BY (dt string) STORED AS ORC;房源库存（可售房数）来自客房维或库存快照，计算入住率时做分母。