I have a dimension which is not directly related to fact table and I need to link this to fact table going through another dimension. I used referenced relationship in dimension usage tab. But i get same count for all when i browse the cube. The below is the SQL query which i exactly need to impllement in cube. SELECT DOB.[VoltEntity.CustIntID$Customer.CustName] ,COUNT(FPAT.ProjectActivityTransactionID) MyCount FROM Publish.FactProjectActivityTransaction FPAT JOIN Publish.DimOrder2 DO ON FPAT.OrderKey = DO.OrderKey JOIN Publish.DimOrderBranch DOB ON DOB.[Requisition.ReqIntID] = DO.[Requisition.ReqIntID] GROUP BY DOB.[VoltEntity.CustIntID$Customer.CustName] DimOrderBranch is the dimension which is not directly related to fact and connected using DimOrder2. I added DimOrderBranch in dimension usage tab and in relationship i used DimOrder2(referenced) in measure group. Regards, Palash

Hi, Kindly check if Materialize is Ticked in the Reference Dimesion. Check this blog by Alberto Ferrari : http://sqlblog.com/blogs/alberto_ferrari/archive/2009/02/25/ssas-reference-materialized-dimension-might-produce-incorrect-results.aspx PS: This is a SSIS forum.Kindly post Analysis Services Question here. http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threadsRakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hello Rakesh, Thanks for reply. Materialize is Ticked. I unchecked that and started processing the cube. Also I posted the same in SSAS forum http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/770cca5b-f0e8-4651-be49-31ce89767417 Regards, Palash

hopefully it resolved your isssue.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/