I'm trying to create an OLAP Cube in Project Server based on a snowflake schema. I'm doing this programatically on the OnCubeBuilt event. I'm not using anything strictly related to Project Server, only the classes in the Microsoft.AnalysisServices namespace, but I wanted to be clear about what I'm trying to implement. Has anyone worked with anything like this? I've already built a cube based on a star schema, so I'm more interested in handling the normalization of the database. Any links or pointers would be appreciated, as I've been searching the web for two days now and I still haven't found anything relevant.