Sub cube MDX optimization question

#1

Use the following sub cube query to filter out the customer info in MDX

SELECT {filter( { [Customer].[Cust ID].Levels(1).Members}, [Customer].[Cust
ID].CurrentMember.member_value = @CustID ) } on columns

but when I didn't use Levels(1), it is very slow. What's the difference it
makes?

Any insights,

Thanks,

Yongli.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sub cube MDX optimization question

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

Sub cube MDX optimization question - 11-09-2006 , 04:41 PM