Incorrect MDX query results

  • I have a cube with Customer, Item, and ServerTime dimensions and several measure groups. I'm concentrating this query on my Forecast measure. The forecast fact table is linked to the customer dimension via customer account and company id and to the item dimemsion via Item Id and company id. As long as I include the Customer Name attribute from the Customer dimension I get the correct results. When I try to query the Item dimension by itself I get only partial results. If I remove the Customer dimension from the cube and re-query then the results are correct. I have been over the linking in the dsv and the Dimension usage and have not found any problems. What could i be missing here? This is SSAS 2008 64 bit on Windows Server 2008. the OLTP db is on SQL 2005 on a separate server and I am using MOLAP.

    Thanks,

    Don

  • Can you provide your MDX here please?

    -RP
  • I wouldn't mind posting the MDX at all except that I got it working now. Not sure why though. Yesterday i added and removed a table to the DSV and that seems to have caused it to start working after I deployed it again. The only thing I can think of is that caused the relationships to refresh.

    Don

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply