MDX的openingperiod、closingperiod和sum(measure)返回相同的值。

要解决这个问题，您可以使用MDX的OpeningPeriod、ClosingPeriod和Sum函数来计算相同的值。下面是一个代码示例：

WITH MEMBER [Measures].[OpeningPeriodValue] AS
  OpeningPeriod([Date].[Year - Quarter - Month - Date].[Date])
SELECT
  [Measures].[OpeningPeriodValue] ON COLUMNS
FROM
  [YourCubeName]
WHERE
  [Dimension].[Hierarchy].[Member]

WITH MEMBER [Measures].[ClosingPeriodValue] AS
  ClosingPeriod([Date].[Year - Quarter - Month - Date].[Date])
SELECT
  [Measures].[ClosingPeriodValue] ON COLUMNS
FROM
  [YourCubeName]
WHERE
  [Dimension].[Hierarchy].[Member]

WITH MEMBER [Measures].[SumValue] AS
  Sum([Date].[Year - Quarter - Month - Date].[Date])
SELECT
  [Measures].[SumValue] ON COLUMNS
FROM
  [YourCubeName]
WHERE
  [Dimension].[Hierarchy].[Member]

将上面的代码中的[YourCubeName]替换为您的立方体的名称，[Date].[Year - Quarter - Month - Date].[Date]替换为您的日期层次结构的路径，[Dimension].[Hierarchy].[Member]替换为您要查询的维度成员。

运行上述代码后，OpeningPeriodValue、ClosingPeriodValue和SumValue将返回相同的值。