September 22, 2004 at 10:58 am
Hello,
As I am in the Cube Editor and watching the cube process - I wonder what is actually happening.
I watch the dimensions being built, and I see there is a display for the number of unique dimension members. I think I understand - as it is building a highly indexed dimension table for the fact table to reference.
But looking further, as it writes the partitions and segments, and counts up though the rows - it a large table being written with all the fact rows, or is it a series of smaller tables by segment with some master table to link them all together? How many rows does it count up to - is it a compilation of the dimension and fact tables?
Any references to articles or books would be appreciated. I want to learn a little more than is normally explained in the BOL and standard technical books on all of our shelves.
Thanks,
Rob
September 23, 2004 at 7:38 am
Try these -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapunisys.asp
"Processing Interaction" (more to do with dims, but worth a look) http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part6/c2661.mspx
http://www.microsoft.com/sql/evaluation/bi/bianalysis.asp
http://www.only4gurus.com/v2/ShowCat.asp?Cat=OLAP%20/%20Data%20Mining%20/%20BI
September 23, 2004 at 6:45 pm
Depending on the type of cube you are processing, MOLAP, ROLAP, or HOLAP, the dimension data and the fact table data and aggregates are stored either in files on the operating system (MOLAP), in relational tables (ROLAP) or a combination of the two - hybrid - (HOLAP).
I've only used MOLAP so far, and with that the data is stored in files under the Analysis Services directory tree from Program Files (if you chose the defaults during installation). Each database in Analysis Services has a folder in the Data directory, and within that you will find a folder for each cube. The dimension files are under the database folder, while the fact table data and aggregates that are formed when you process a cube are stored under the cube folder.
The book Analysis Services Step by Step is good, as is the MDX Solutions book.
The Repository is another area of interest where you can see some high level meta data about your cubes. By default the repos is stored in an Access database, or it can also be migrated to a SQL Server database of your choice.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply