dbTalk Databases Forums  

MDX - Count Number of Minutes In A Selected Period Up To Current Day

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss MDX - Count Number of Minutes In A Selected Period Up To Current Day in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ben
 
Posts: n/a

Default MDX - Count Number of Minutes In A Selected Period Up To Current Day - 09-17-2003 , 12:37 PM






I have created a calculated measure that counts the number of minutes
in a selected date period (ie. Year, Month, Week, Day) based on what
is selected from the date dimension. It works fine for periods that
are in the past, but what I really need is if a period is not complete
to only return the minutes up to the current day. (ie. Today is
September 17. If I am reporting on the month of September, I want
total minutes through yesterday, not total minutes for the entire
month.)

This is the calculated measure as it currently exists (1440 - 60
minutes * 24 hours):

count(descendants( fiscal_calendar.currentmember,[day])) * 1440

Any help would be appreciated...

Ben

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.