帮助编写MDX以获取以下数据 [英] Help on writing MDX for the following data

问题描述

HI，

我需要编写MDX来获取2016,2017,2018的Jan数据和2016,2017,2018的feb数据等数据。

I need to write the MDX to get the data like Jan data for 2016,2017,2018 and feb data for 2016,2017,2018 and so on.

你可以帮我解决这个问题。

Can you please help me on this.

谢谢你



推荐答案

不知道你的立方体&尺寸结构很难协助;这是一个基本的MDX查询：

Without knowing your cube & dimensions structur it's difficult to assist; here is a Basic MDX query:

select { [Measures].[TurnOver Amount] } on 0
      ,
       NON EMPTY { [TimeDimension].[Month] } on 1
from [TurnOver]

这篇关于帮助编写MDX以获取以下数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！