ssas - Dynamic Work shifts in Tabular model -
i have static calendar hierarchy in ssas tabular model minutes, hours, days. way can cool metric grouping dates like:
2017-01-01 45 2017-01-02 3 2017-01-03 17
i want able groupings work shifts no more 24 hours long. extend calendar hierarchy static shifts. need work shifts user definable on fly.
for example user can set 22-hour shift 03:00 01:00.
what approach should take include dynamic shifts calendar hierarchy?
Comments
Post a Comment