I've been able to get a solution to the problem. For the rugged hierarchy i just added the mdx compatibility property in the connection string of the datasource in SSAS,...
I'm also new to SSAS(2005) and I have the same problem with my GL Account Dimension Hierarchy. I have level1, level2.....level6 and the Account code as the lowest level. Level3...
Hello. I'm also a newbie. You'll have to execute the stored procedure that comes with the code by typing 'exec sp_createTimeDim' and clicking the execute button.