I need get the last Id of dimention

• sergio.eduardo.linares

  SSC Enthusiast

  Points: 181

  More actions

  January 26, 2015 at 2:24 am

  #145655

  I have:

  Fact:

  Pk_Fact Id_Dim1 Id_Dim2 Value

  17 2 3 15

  21 2 2 20

  22 2 5 25

  23 2 1 35

  30 2 4 40

  Dim1:

  Id_Dim1 DesDim1

  2 'Description 2'

  Dim2:

  Id_Dim2 DesDim2

  1 'Description 1'

  2 'Description 2'

  3 'Description 3'

  4 'Description 4'

  5 'Description 5'

  I need get the id of the last fact using MDX:

  Result spected : Sum(Value)=145

  Id_Dim1 = 4 --> (*) its posible get this with mdx

  Thanks

• PB_BI

  SSCoach

  Points: 17463

  More actions

  January 26, 2015 at 8:31 am

  #1773133

  Have a look here for your answer: https://social.msdn.microsoft.com/Forums/en-US/a6962f8e-5a7e-4f55-b722-93a2203b87e5/mdx-last-non-empty

  ---

  I'm on LinkedIn

• sergio.eduardo.linares

  SSC Enthusiast

  Points: 181

  More actions

  January 26, 2015 at 11:56 pm

  #1773304

  Thanks my friend