This project has moved and is read-only. For the latest updates, please go here.

SSAS Cube Calculated Measure "Sum" does not work

Topics: Developer Forum, Project Management Forum, User Forum
Dec 11, 2013 at 7:09 AM
Edited Dec 11, 2013 at 7:11 AM
Dear all
I am working with SQL Server 2012 SSAS.
I build my Cube everything is working very good.
I want to make a new “Calculations”
Create Member CurrentCube.Measures.[X]
AS
Sum(
{
[Market].[Market]. CurrentMember
[Region].[Region]. CurrentMember,
[Month].[Month]. CurrentMember
},
[Measures].[Value]);

It is not calculating right ?

Month Country | Region | Market | SKU | Value | X
January Egypt | Alexandria | Croissant | MoltoWC | 261570.00 | 728390.00
January Egypt | Alexandria | Croissant | MoltoSC | 201500.00 | 728390.00
January Egypt | Alexandria | Croissant | BrunchTC | 2550.00 | 728390.00
January Egypt | Alexandria | Croissant | BrunchTP | 262770.00 | 728390.00
                                                                               Total                    728390.00


X = the Sum of Column [Value]
Where
Month = same month of the current Row
AND Region = same Region of the current Row
AND Market = same Market of the current Row
Dec 11, 2013 at 6:44 PM
Dec 12, 2013 at 8:31 AM