<Dimension name="Hierarchy">
<Hierarchy hasAll="true" primaryKey="casedimid">
<Table name="case_dim"/>
<Level name="Division" column="hierarchylvl4name" uniqueMembers="true" approxRowCount="8"/>
<Level name="Region" column="hierarchylvl3name" uniqueMembers="true"/>
<Level name="District" column="hierarchylvl2name" uniqueMembers="false"/>
<Level name="Business" column="hierarchylvl1name" uniqueMembers="true"/>

I get incorrect aggregates every time. I've even tried the foodmart database, but it has to do with multi-level hierarchies. It's explained in more detail here Any estimate on a fix would be great as I'm trying to incorporate PAT into a project, thanks!