dbTalk Databases Forums  

mdx Two custom periods

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


Discuss mdx Two custom periods in the microsoft.public.sqlserver.olap forum.



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

Default mdx Two custom periods - 07-22-2005 , 04:47 AM






I want to get sales value for 2 custom periods - the problem is that
periods is not simple ( like compare one week to another) but in ex.
compare 3 days to 2 months

How can i do that ?

Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: mdx Two custom periods - 07-22-2005 , 10:30 PM






You might find this recent discussion of "Time Ranges in AS 2005" from
Chris Webb's blog relevant:

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
262.entry
Quote:
...
Basically he needs two Period dimensions in his cube, from which the
user can select individual members or ranges, allowing the user to
compare values for a measure across these two different Period
selections. For example the user might want to compare Sales in January
1997 with Sales in February and March 1997 combined.
...
Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


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.