SAS OLAP Server may return missing values for a calculated measure if
the following conditions are present:

  - The calculated measure references a dimension member using
    the currentmember function.

  - Members from that dimension are used as input to an AGGREGATE
    function.

An example query that demonstrates this issue is:

  WITH
  MEMBER [Measures].[SumOfQuantitySum] AS
    'Sum([Geography].[Global].currentmember.Children,
[Measures].[QuantitySUM])'
  MEMBER [Geography].[Global].[&1Global] AS
    'AGGREGATE({[Geography].[Global].[All Global].[Europe],
                [Geography].[Global].[All Global].[North America]})'
  SELECT
    {[Measures].[SumOfQuantitySum] } ON COLUMNS,
     [Geography].[Global].[&1Global] on ROWS
  FROM [OrionStar]

There is no workaround available for this issue.

Operating System and Release Information