Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multidimensional database internal representation. Expand / Collapse
Author
Message
Posted Thursday, April 9, 2009 12:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 9, 2013 4:19 AM
Points: 16, Visits: 82
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
Post #693762
Posted Thursday, April 9, 2009 11:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 9, 2013 4:19 AM
Points: 16, Visits: 82
Hi,
I would be really grateful if any one answers my question...Gift wat abt u?
Post #694607
Posted Friday, April 10, 2009 9:17 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, July 27, 2014 12:14 PM
Points: 3,433, Visits: 14,423
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
Post #694912
Posted Wednesday, April 15, 2009 11:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 12, 2010 7:43 AM
Points: 15, Visits: 73
Dimensions and fact(s) data are internally represented in terms of flat files, atleast in msas 2000. Should be the same in SSAS2005 ..
Post #697771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse