0

is there a difference between a native cube measure (for example Measure1) and this mdx measure : Measure2=[Measures].[Measure1] ?

Because when I use these measures together I dont get any results, and when I use them one by one I get what I want.

Hamza Lahbabi
  • 29
  • 1
  • 9

1 Answers1

0

So the Cube Measures are present at the time of cube processing where the "MDX measures"(correct name is calculations) are determined at the query time. You should try to use the Cube measures where ever possible. Secondly they can be easily used together.

MoazRub
  • 2,881
  • 2
  • 10
  • 20
  • Nomally if I define a calculation like Measure1 = [Measures].[CubeMeasure] then Measure1 and [CubeMeasure] should work exactly the same, no ? and it's not what I get. – Hamza Lahbabi Feb 27 '20 at 11:56
  • Yes that is how it should work. Share the query or screen shots. – MoazRub Feb 27 '20 at 12:38