April 15, 2008 at 5:37 pm
I have a couple of questions regarding SSAS
1] I have built the Dimension and fact tables using t-sql and SSIS. Now i aim to prepare the cube so that reports can be built off it. What all do i have to learn to prepare the cube and then use SSRS to build reports off the cube.
2] Does anyone have any links for tutorials which i could purchase? or any other resource?
How long should i practically expect to finish building the cube so that reports can be built off it.
I apologize it this may seem like cross-posting, with reference to other posts , but i realized(later) that this would probably be the better forum for this question.
May 26, 2008 at 3:13 am
Hi,
If you are still searching for an answer:
You need to learn SSAS (Analysis services) 2005 to build your cubes. You can make use of the wizards which would guide build your dimensions and cubes. Depending on the complexity of the cube, how detailed you want your dimensions to be, calculated measures, KPIs, etc the duration will vary.
Sometimes it also depends on how well you have designed your dimension model..
Hope this helps.
Neel
Warm Regards,
Neel aka Vijay.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply