dbTalk Databases Forums  

Assistance required!

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


Discuss Assistance required! in the microsoft.public.sqlserver.olap forum.



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

Default Assistance required! - 07-07-2004 , 01:10 AM






Hello...

I have a cube that has a Time dimension... Within this dimension there are
three members 2003, 2004, 2005...

I am using this MDX as a calculated Member SUM(YTD(),[Measure].[Whatever])
which works fine.. However now I need to create another calculated member
that acts like the YTD function but covers all periods..

Can anybody assist?



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

Default Re: Assistance required! - 07-07-2004 , 01:52 AM






Solved it..

Thanks anyway

Member [Measures].[All Whatever] AS

'Sum(Periodstodate([Period].[(All)], [Period].CurrentMember),
[Measures].[Whatever])'

"AshVsAOD" <.> wrote

Quote:
Hello...

I have a cube that has a Time dimension... Within this dimension there are
three members 2003, 2004, 2005...

I am using this MDX as a calculated Member SUM(YTD(),[Measure].[Whatever])
which works fine.. However now I need to create another calculated member
that acts like the YTD function but covers all periods..

Can anybody assist?





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.