YSLGuru (10/28/2014)
SELECT{[Accounts Budget].[Default].&[UNITS]} ON 0,
NON EMPTY {DESCENDANTS([Properties].[Default].&[Total], , LEAVES)} ON 1
FROM [Budget Model]
WHERE ([Time].[Default].&[2014M01], [Measures].[Value], [Time Perspective].[Default].&[BASE], [Version].[Default].&[ACT]) CELL PROPERTIES VALUE
It would seem that the measure group where you are getting the [Measures].[Value] measure from is intended to be linked to the [Accounts Budget] dimension. This dimension might be there to indicate what type of fact is in a measure (for example Budget, Actual or Forecast - in this case Units). So to find out what the constituent parts of the query are then you should look to the fact table that's building the measure group. I would expect this fact table to have some sort of foreign key in it to indicate what member of the [Accounts] budget dimension that the fact pertains to. Isolate the ones that pertain to UNITS and you have your answer.