Error with MDX

• nitin.gupta 32678

  SSC Enthusiast

  Points: 111

  More actions

  January 3, 2011 at 10:27 pm

  #232574

  Hi Expert ,

  I am using MDX query but i am getting error like

  "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples." .

  when i remove some columne from it,it works.

  Please help me .

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  January 4, 2011 at 12:38 am

  #1268779

  Do you have dimension security or are you using NONEMPTY?

  If yes, read the following KB article:

  http://support.microsoft.com/kb/940019

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP