Cube has DATE dimension and Item fact table
with Calendar and Fiscal hrchies YEAR-Quarter-Month-Date
and
with Calendar and FIscal hrchies Year-week-date

User Request:
The user requested to make analysis on Items fact based on Custom Defined
Business Day, i.e. business day is the custom defined PERIODs of time with
start date and end date(start date-time and end date-time may not be on the
same calendar date, for example, Business day may be defined as 24 hours
starting from jan 1, 11:20pm. therefore, the end for the first business day
will be jan 2,11:20pm ).

How to add Periods to current Item cube? or build another cube?...
to be able to slice by Periods of time (from 'start date-time' to 'end
date-time' ) ?

I am thinking to have PERIOD table and Time table:
PERIOD TABLE:
Period Key
Period Name
Period start date key
period start time key
period end date key
period end time key

TIME TABLE:
Time key
Time Start hrs
Time Start minutes
Time end hrs
time end minutes

Or

Create a separate Item Fact Table with aggregations for PERIODS, i.e. add
attributes to ITEM fact:
start date key
end date key
start time key
end time key



HOW TO MODEL db schema to support any custom defined periods, for
example, for accounting some customers needed 4-4-5 periods, some needed
4-5-4 periods?


thank you,
Alex









I need to build Custom Defined Business Day Dimension or set of dimensions
or???.
to be able:
1. To define Business Day using Start Date-Time and END Date-Time
Custom Definition of Business day:
-