Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Performance Tuning

Author  Topic 

pssumesh2003
Starting Member

35 Posts

Posted - 2014-05-26 : 07:58:52
Hi All,

I am new in SSAS Development. In My Project i have more than 10 Cubes are there. When I process one cube it takes more than 9 hours to process. When I analaysed the cube using Visual studio it has 8 dimenssion and 2 fact tables. the fact tables are are created using named query and the query used in that i executed using SSMS it takes more than 1 hours each. but when i process the cube it takes more than 9 hours..


Please guide me the performance tuning techniques in the SSAS cubes using named queries


   

- Advertisement -