I may be jumping in to far too fast. but thought I'd ask anyway

I have a sql 2005 database that holds information about our file structure
on our file server. It has several times, one of which is a folder table.
This folder table contains info like

id foldername
1 d:\root\dept\is\reports
2 d:\root\dept\is\data
3 d:\root\user\user1

this data is then related to another table
id filename size
1 test1 64
2 test2 808

and the related table

id folderid fileid dateofgather
1 1 1 1/1/2006
2 2 2 12/15/2005
3 3 1 1/1/2006

when i tried to create a cube on this drag my folder dimension over, it list
all the folders out as seperate rows, but i want it to do it in a
hierarchy... so when i click on d: i'm shown root next, then dept and user

can you do this in a calculated field.. or is this something where with a
lot of work, i'd have to store in the database first.

i don't know how hard or easy this would be.. but been around long enough to
know sometimes what one person thinks is really hard someone else has
already done and can make seem simple

hope someone can help
thanks
shannon