Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Group By MDX for YTD Rate Topic Display Mode Topic Options
Author
 Message
 Posted Tuesday, October 15, 2013 3:26 PM
 SSC Rookie Group: General Forum Members Last Login: Wednesday, November 20, 2013 8:30 AM Points: 42, Visits: 194
 HI,I'm New to MDX querying, so looking for some help here :This is the query that got generated out of profiler : `SELECT CROSSJOIN( { [Fiscal_Year].[2014] },{ [Period].[Jun], [Period].[Jul] }, { ADDCALCULATEDMEMBERS([Function].[All Function].Children) })ON 0 ,NON EMPTY CROSSJOIN( { [Fund].[10]}, { [Account_Code].[ABCD] }) ON 1FROM [TFA_Budget2]WHERE ( [Measures].[Value])` 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 Jun Jun Jun Jun Jun Jun Jul Jul Jul Jul Jul Jul A B C D E F A B C D E F 10 ABCD 10 20 30 40 50 60 10 20 30 40 50 60 Result Set 2014 2014 2014 2014 2014 2014 Total Total Total Total Total Total A B C D E F 10 ABCD 20 40 60 80 100 120 So we total sum(A) for Jun and JUly and put it in Total.Thanks in advance.
Post #1504999
 Posted Wednesday, October 16, 2013 3:32 AM
 SSC Eights! Group: General Forum Members Last Login: Today @ 12:54 AM Points: 876, Visits: 2,469
 Hi,Try something like this`With Member [Period].[Total] as ( [Period].[Jun] + [Period].[Jul])SELECT CROSSJOIN( { [Fiscal_Year].[2014] },{ [Period].[Total] }, { ADDCALCULATEDMEMBERS([Function].[All Function].Children) })ON 0 ,NON EMPTY CROSSJOIN( { [Fund].[10]}, { [Account_Code].[ABCD] }) ON 1FROM [TFA_Budget2]WHERE ( [Measures].[Value])`
Post #1505120

 Permissions