A set has been encountered that cannot contain calculated members

• GG_BI_GG

  SSCrazy

  Points: 2627

  More actions

  May 7, 2019 at 8:16 am

  #3636971

  Hi Guys,

  I have a cube and works for more then 4 years. I get a error when I trying to browse in the Cube:

  A set has been encountered that cannot contain calculated members

  The following MDX Im running:

   SELECT NON EMPTY { [Measures].[% hours] } ON COLUMNS FROM ( SELECT ( { [Bookperiod].[Bookperiod].[All Bookperiods].[Cum. April] } ) ON COLUMNS FROM [productivity]) WHERE ( [Bookperiod].[Bookperiod].[All Bookperiods].[Cum. April] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

  Cum. April is mij calculate value:

  

  Cum. May looks like this:

  [Boekperiode].[Boekperiode].[Fis Period].&[1] + [Boekperiode].[Boekperiode].[Fis Period].&[2]

  and so on..

   

  Can somebody help me why i get the error?