RE: Scope question

Tech-Archive recommends: Speed Up your PC by fixing your registry

Just query the Sales Amount Quota for Year 2005 and the qtrs and you will
see the results. Nothing special. As for the allocation query the month
level.

"Oded Dror" wrote:

Hi there,

I'm using SQL Server 2005 SP3 Dev. Edition
I understand how to create a scope (like this from BOL)
Scope
(
[Date].[Fiscal Year].&[2005],
[Date].[Fiscal].[Fiscal Quarter].Members,
[Measures].[Sales Amount Quota]
) ;

This = ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year], 1,
[Date].[Fiscal].CurrentMember
) * 1.35 ;


/*-- Allocate equally to months in FY 2002 -----------------------------*/

Scope
(
[Date].[Fiscal Year].&[2002],
[Date].[Fiscal].[Month].Members
) ;

This = [Date].[Fiscal].CurrentMember.Parent / 3 ;

End Scope ;
End Scope ;


Now, how do you use it? or call it? or select from it?

Thanks,
Oded Dror
Email: odeddror@xxxxxxx










.