dbTalk Databases Forums  

Sum Children at different Levels

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


Discuss Sum Children at different Levels in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Milind
 
Posts: n/a

Default Sum Children at different Levels - 01-03-2006 , 01:27 PM






Hi

I have a Answer dimension with following levels
Field -- Exercise
Value -- 1
member prop - Description (Caption) -- 00 to 15 minutes

Now I want to do this
(Pseudo MDX code)

Select [Exercise].[00 to 15 minutes]+[Swim].[Less than 15 minutes] on
rows,
[Measures].[Encounter] on columns
from AnswerCube

Exercise and Swim are members of Field level.

thanks

Milind


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.