Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2012
    Posts
    16

    Unanswered: Why Showing alwayes empty cell in the measure

    Hi,
    I have a cube in MS analysis service 2008 R2. It was showing values in the morning. But I am surprised why it shows null in all the measures now? I have re created the datasourse, datasource view and cube and still it shows null in all the measures. I have executed different MDX and there it also shows null.

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    You need to determine what you changed - it may have been intentional or not.

  3. #3
    Join Date
    Aug 2012
    Posts
    30
    did you process cube after recreating? check if all underlying tables/views have data

  4. #4
    Join Date
    Jul 2012
    Posts
    16
    I have created separate cubes from the same base tables. I have processed it and still the measures showing null. I have restarted the server but still the problem remain. I have checked the based tables and they are full with data.

  5. #5
    Join Date
    Aug 2012
    Posts
    30
    check if relationships defined inside cube are valid. run the query generated for measure groups and see if they return the data

  6. #6
    Join Date
    Jul 2012
    Posts
    16
    Is it possible to find the query generated for measure groups?
    This is simple row count.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •