Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Incorrect MDX query results Expand / Collapse
Author
Message
Posted Tuesday, June 1, 2010 10:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 12, 2013 8:23 AM
Points: 41, Visits: 81
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
Post #930863
Posted Wednesday, June 2, 2010 10:21 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 9:42 AM
Points: 670, Visits: 229
Can you provide your MDX here please?

-RP
Post #931491
Posted Wednesday, June 2, 2010 11:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 12, 2013 8:23 AM
Points: 41, Visits: 81
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
Post #931515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse