From clause is used to indicate either the cube itself or sub section of the cuber. These 2 queries show the use of from clause respectively.
select
from
[Adventure Works]
go
select
from
(
select
[Date].[Calendar].[Calendar Year]
on 0,
[Geography].[Geography].[Country]
on 1
from
[Adventure Works]
)
where [Date].[Calendar].[Calendar Year].&[2002]
HTH..
Thanks
Happy Cubing,
ZULFIQAR SYED
Comments