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)  Building Cube on Billons of Records

Author  Topic  Aung Starting Member 1 Post Posted - 2008-10-31 : 03:24:03 BI is a new technology for me and now I am trying to built the cube which query out on billion of records. I can build the cube properly and point that cube from Report, and the Report also working properly. But there has some performance issues. It takes very long time to load up and sometime it fails by getting out of memory error. And also cube building time takes a couple of hours. Thus I am trying another approach, splitting the records by category and building the particular cubes based on the categories. I assume that it is not a good approach. I want all the records in single cube with better performance. Using partitioning does not take effort.