can somone lay out the high level steps needed from getting raw data, to building a cude, reporting services, etc any online resources explain this in details also?
Hi, It's a very broad topic about building cubes. You can read in more detail in BOL or search online for this. Also SSP has got many good articles on this
Look at the SQL 2000 analysis services operations guide, that would give some information in this regard. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.