Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

Question

Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

Bill Pearson

SSCommitted

Points: 1520
More actions
May 15, 2015 at 7:56 am

#303877

Comments posted to this topic are about the item Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RonKyle SSC-Dedicated Points: 31558 More actions · Answer 1

I'm finding this confusing as you seem to have chosen a measure that can be added across the days. Especially so as the first of the month was so high. These functions would seem to be better used with semi-additive measures such as inventory numbers or account balances. Am I missing something? If so, please clarify. Thanks,

Bill Pearson SSCommitted Points: 1520 More actions · Answer 2

Sorry for any confusion. You could technically use either function to accomplish either purpose you mention. I chose to stay away from semi-additive, as it would have added a further complication to what is intended as a very basic introduction to several Time / Date functions. I do intend to revisit this when I take up semi-additive scenarios later in the series ... these functions will then be re-examined in that context (no pun intended ... 🙂 )

Thanks for reading! Feel free to contact me directly if I can help further.

Bill

William E. Pearson III

CPA, CITP, CGMA, CMA, CIA, MCSE, MCDBA

Business Intelligence Architect

MS SQL Server MVP and SSAS Maestro

D & B MVP

Island Technologies Inc. ®

931 Monroe Drive, NE

Suite 102-321

Atlanta, GA 30308

404.317.8469 Mobile