Report Portal

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

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.