April 9, 2009 at 12:27 am
Hi,
I'm new to SSAS and i'm going thru the concepts of multi dimensional DBs and cube. I just wanted to know how a multidimensionla database is internally represented on disk( as it has FACT and Dimension tables which are relational tables ..i suppose). Aren't they(Multi dim DBs) represented in relational format as tables? And also i wanted to know how a cube is internally represented in SSAS.Is it just a logical representation of multidimensional data or is there any specific data structure to store this? All these questions came up when i'm going thru the basics of SSAS. Any clues or inputs reg the above queries is greatly appreciated.
Thanks
Kiran Mahamkali:-)
April 9, 2009 at 11:00 pm
Hi,
I would be really grateful if any one answers my question...Gift wat abt u?
April 10, 2009 at 9:17 am
Hey you know I was asleep here in the US at 1 AM so here are the Microsoft samples just use them for dimension modeling because there is a separate site for prediction modeling. So download the Analysis Server samples and work through that samples. You may also need to buy a book and there are a lot of tutorials in the second link.
http://www.codeplex.com/SqlServerSamples#e2e
http://www.databasejournal.com/article.php/1459531
Kind regards,
Gift Peddie
April 15, 2009 at 11:35 am
Dimensions and fact(s) data are internally represented in terms of flat files, atleast in msas 2000. Should be the same in SSAS2005 ..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply