Creating Sub Cubes - Visual and Non Visual Mode
With AS 2008 , you can create subcube in Visual and Non Visual Modes. First of all What is Visual and Non Visual Mode. I will try to write some simple MDX to demonstrate it.
Fire this query without any subcubeing
select {[Measures].[Reseller Sales Amount] } on 0,
[Business Type].members on 1
from
[Adventure Works]
where
[Category].members
You Get
Tags: mdx