dbTalk Databases Forums  

time dimension - Urgent

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


Discuss time dimension - Urgent in the microsoft.public.sqlserver.olap forum.



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

Default time dimension - Urgent - 06-08-2005 , 06:54 PM






Hi all gurus

If I want to get the sum of measures for time period from time dimension
for date from 11 to 17 and 22 to 25 for particular month.

How can i get it?

--
Thanks

Am



Reply With Quote
  #2  
Old   
OLAPMonkey
 
Posts: n/a

Default Re: time dimension - Urgent - 06-09-2005 , 10:17 AM






Something like this example against Foodmart 2000 would do the job...

with member [Time].[My Time] as
'sum([Time].[1997].[Q1].[1]:[Time].[1997].[Q3].[7])'
select
{
[Measures].Members
} on columns,
{
[Gender].Members
} on rows
from Sales
where ([Time].[My Time])

Notice the ":" operator allows you to specify a range of values. Also
Notice that placing the calculated member on a dimension other than
Measures (in this case the Time dimension) allows it to slice across
Measures affecting each measure.


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.